Dynamic Power query

Hi Anonymous ,

Please try:

First create a parameter that you want to pass to the data source:

Then connect your parameter to your data source like this:

Then create a Parameter table in the data model and bind to parameter:

Now you can use this value to create a slicer that can change your data source:

Note:  Dynamic M query parameters  (Bind to parameter option) is only available for some Direct Query source.

Please refer to this:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.