Forum Discussion

abhidotnet's avatar
abhidotnet
Advocate II
1 year ago
Solved

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 c...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    Can I dynamically pass the date parameter (e.g., first day of the current month) at refresh time?

    It's a two step process

    1. set parameter

    2. initiate refresh

     

    You would need to use a custom connector that can run REST API calls.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi  abhidotnet 

Yes, this is totally doable. You'll need to.

  1. Use Power Automate to trigger on the 1st of every month.
  2. In the flow, calculate the first day of the month and use the Power BI REST API to update the parameter.
  3. Then call the refresh API to refresh the dataset.
  4. (Optional) After a delay, use the export API to generate an Excel/PDF and email it out.


Regards,
Akhil.