Forum Discussion
Automatically Visualising Calendar/CSV data from Power Automate in Power BI
1. You could use a PowerApp visual inside Power BI to capture the user input, write it into the data storage, and initiate a page rerender (optionally a semantic model or table refresh)
2. Up until recently the report user would not immediately see the results of their actions reflected back in Power BI as your data source is not accessed in Direct Query mode. However, it seems that now a semantic model refresh also caused a re-rendering.
3. If you go anywhere near a premium connector (say, a SQL Server data source) all of your PowerApps users will require a PowerApps Premium license.
Consider using Translytical Taskflows and Fabric SQL databases instead.
Hi pp365 ,
If you're planning to move ahead with the Power Apps visual inside Power BI approach, that’s a solid direction for your scenario. It lets the user trigger your Flow, generate the CSV, write data into storage, and then have the report automatically re-render with the updated results all from within the same Power BI report. It’s much simpler than building a custom ingestion pipeline, and it fits your use case where the end user initiates the data retrieval themselves.
To help you get started, Microsoft has a step-by-step guide on how to embed a Power Apps visual inside a Power BI report: Embed a new Power App in a Power BI Report. - Power BI | Microsoft Learn
Best Regards,
Chaithra E.
Hi lbendlin ,
Many thanks for your reply and taking the time to share some suggesitons.
I had a look at Translytical Taskflows, this seems way too complicated, we do not have any code/SQL experience and as someone new to Power BI this seems out of reach. Also it seems to be in Preview so I can't use it for production.
Moving back to the idea of using a Power App Visual inside Power BI. This seems more feasible and thank you for this idea. I have started some research/design ideas and will try for a PoC using this approach. I'll post back here with any meaningful updates in due course.
I would like to keep the thread open for the time being in case any other community members have suggestion about the general ask, and/or pointers about the 'Power Apps inside Power BI' approach.
Thanks again!
Hi pp365 ,
If you're planning to move ahead with the Power Apps visual inside Power BI approach, that’s a solid direction for your scenario. It lets the user trigger your Flow, generate the CSV, write data into storage, and then have the report automatically re-render with the updated results all from within the same Power BI report. It’s much simpler than building a custom ingestion pipeline, and it fits your use case where the end user initiates the data retrieval themselves.
To help you get started, Microsoft has a step-by-step guide on how to embed a Power Apps visual inside a Power BI report: Embed a new Power App in a Power BI Report. - Power BI | Microsoft Learn
Best Regards,
Chaithra E.