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
But you can also achive column addition, masking etc directly via power automate,logic app etc.
why use an intermittent layer of Power BI for transformations when you can actually leverage transformation tools
I do have few limitations for this project:
- This data will be merged with 1 or 2 other data sources (not Sharepoint).
- There can't be any modifications to the origin as it is Application generated data.
- The origin data is not in Table format. It is either list/comma-separated data.
- The requirement was to implement using only Power Automate & Power BI.
That's is why was exploring this path.
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