Help with parameter binding!

[JMAlloway]

Hello, 

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:

[Daryl-Lynch-Bzy]

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.

[JMAlloway]

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.