Forum Discussion
Execute Power BI report using Power Automate
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
Yes, on trigger there will be data refresh to read the latest data alongwith below.
In step 2, there will be some data modification required. Like, masking some data, adding few custom columns.
For this, I was exploring Power BI report/or any other possible way.
After these data modifications, I need the modified data to be stored back to Sharepoint.
I still don't understand why you want to do it this way, but you can use the "Execute a DAX query against a dataset" action to pull the Power BI data.