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 ,

I’m following up to confirm that all items discussed have been addressed. If there’s anything else you need, I’d be happy to assist.

Regards,
Akhil.