How to use Dynamic M query parameter in dataflow from SQL server

[Zidka]

How to use Dynamic M query parameter in dataflow from SQL server

Do Direct query and import affect to this feature

Does Bind to parameter feature work on dataflow 

[v-rongtiep-msft]

Hi @Zidka ,

I have found a similar post, please refer to it to see if it helps you.

Solved: Dynamic M Parameter an SQL Server - Microsoft Power BI Community

• We will try to solve this requirement by a diffrent way (maybe split the data). 
• Or we try this workaround: https://www.youtube.com/watch?v=3QiTBXfxzHA

I have also found a document, please refer to it to see if it helps you.

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

Best Regards

Community Support Team _ Polly

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

[Zidka]

Do you know dataflow and workspace 

I need to share this report that user need to change parameter with dynamic options

[Zidka]

And I have 3 parameter : Year , Week, Time Period (This week, Last week, False)

[Zidka]

And I am using stored procedure