Multiple dynamic Dynamic M Query Parameters with SQL​​

[Anonymous]

Hello everyone,

I have two power Native Database Query (Power Query) where I download data that are related to a date, it's always first day in the year(yearly). I would like to if a user could select Year e.g 2024, 2023 etc.. How can I make it work dynamic multiple power queries ? I created parameter but I dont know how to link it and make it work including with changing the time "Years" 

[hnguy71 · Accepted solution]

Hi @Anonymous ,

I believe dynamic M queries are only available if your source is in DirectQuery mode. If your SQL source(s) are set to import mode it won't work.

Switch it over to a DirectQuery mode and then bind your parameters. You can follow these steps to properly bind them:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters