Forum Discussion
Execute Power BI report using Power Automate
- 3 years ago
Hey,
Thanks for reverting back!
yes, considering that there is a mandatory aspect of using Power apps and original source wuld stay as is, you can just leverage Power automate to do the needful rather than bringing in Power BI in between.
You can consume from multiple sources and merge and transform them via power automate
https://www.encodian.com/blog/working-with-file-contents-and-files-in-power-automate/
https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-control-flow-branches
2. On this trigger, execute Power BI report (uploaded in Power BI service).
In power BI report, I will make some modifications to the data.
This part is not clear to me. Maybe you mean "Initiate a Power BI dataset refresh"?
Note that dataset refreshes are processed asynchronously. You would have to include logic in your flow to wait for the completion of the refresh before proceeding with the next step.