Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Help with parameter binding!


I am importing SQL data via direct query into my model. The SQL server creates a new database at the end of every calendar month. This creates monthly snapshots of our data. Each month database is named "yyyy-MM". I am using a query parameter that's binding to a single-row table that dynamically changes "yyyy-MM" based on the current date. My issue is that when I bind a parameter to the table value, it does not dynamically change to the expected value. Even when binding, the parameter value remains the original current value. Any advice on what I'm doing wrong or what step I'm missing? Thanks!

Parameter listed in M query:


AD_YTD Parameter:


Parameter table:


Bind to parameter:





Super User
Super User

Hi @JMAlloway  - I don't think this can work because you are effective changing the data source connection with the Dynamic M Parameter.  You could use the parameter to filter between tables within a database, but not to change between databases.

Thanks for the reply, Daryl! Maybe I'm thinking of this in the wrong way. I'm able to successfully pass a parameter value to the database name. If I manually change the parameter value and refresh, the change in database is successful. My issue is that I need the parameter value to change dynamically. For example, based on the current date, I need the parameter to display the last day of the previous month. (This is because the database is named the last day of each month). I'm thinking I should investigate creating a list query.

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors