Automated Power BI Report with Parameter

Hi all,

I’ve created a Power BI report that connects to a Table Valued Function (TVF) in a SQL Mirror Database. The function takes a single parameter — an input date — which I pass via a parameter configured in the semantic model.

Here’s what I’ve done so far:

1. Created and published the Power BI report.

2. The report uses Import Mode to call a SQL TVF with a date parameter. (see screenshot)

    

3. I’ve defined this date as a parameter in the semantic model.

Now, I want to automate this report to refresh and generate output (EXCEL or similar) on the first of every month, using that month's start date as the parameter.

Questions:

• Is this automation possible within Microsoft Fabric?

• Can I dynamically pass the date parameter (e.g., first day of the current month) at refresh time?

• What combination of tools (Data Factory, Data Activator, Power Automate, etc.) would be recommended?

• Is exporting the report to Excel and distributing it via email also doable as part of the automation?

Any guidance, best practices, or links to documentation would be greatly appreciated!

Thanks in advance!