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.