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.
Hello everyone, thanks again for your suggestions on this topic and apologies for the delayed reply. Thank you v-echaithra for checking in.
In the end, I used a Power Automate Flow to get the data in to Dataverse, and the plan is to then model the data from there. In the Flow we are able to bulk delete the Dataverse rows which means each time the user requests the data, the previous data is cleared and then refreshed.
It's probably not the most efficient way but it appears to work. Thanks again for your inputs.
Hi pp365 ,
Thank you for the update and for sharing the workaround that has been effective in your case.
If you need any further assistance, please don't hesitate to reach out. We're always here to help!
Best regards,
Chaithra E.