By using this website, you agree to our Terms of Use (click here)
Hello,
I understand that Acumatica can connect to Microsoft Flow, but it can be quite a complex process. Has someone built a custom template for this connection?
I wonder whether we could use Flow to push data from Acumatica to a PowerBI database, allowing for live data updates...
I built something in Microsoft Flow a long time ago, but it stopped working with the cookie based authentication. Apparently Microsoft broke cookie based authentication intentionally because Flow runs in the cloud across multiple machines and there is no guarantee that the machine that executes the next Flow step is the same machine which would cause the cookie authentication to fail randomly.
But, Samuel showed how to get Flow working using OAuth at the last Acumatica Summit. His example takes a Tweet and turns it into a Case in Acumatica. I documented that session here:
https://www.augforums.com/connecting-clouds-web-services-summit-2018/
But, in your situation, I don't think that you need Flow to interact with Acumatica. Just connect PowerBI.com to Acumatica Generic inquiries via OData, then use the technique outlined in this article to have Flow refresh the PowerBI.com dataset:
https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33
Flow also has a mobile app where you can create a big button for triggering a Flow. That could be one way to easily trigger a PowerBI.com dataset refresh. Or, if you want a physical button to press, you could try something like this:
https://www.o365dude.com/2017/07/23/physical-buttons/
Online Members
