Forum Discussion

Andy__'s avatar
Andy__
Frequent Visitor
2 years ago

User input for dynamic SQL Queries in Power BI desktop?

Hello   We have a SQL query in a Power BI Desktop file, and this query selects from a database function. The function accepts an input. We would like to allow users to set this input through a visu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Andy__ 

After  testing, if your connection mode is direct query, the create new table can be used, try to clear permission and reconnect the sql again.

Best Regards!

Yolo Zhu

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

 

 

Andy__'s avatar
Andy__
Frequent Visitor
2 years ago

Hello Yolo,

 

I created a new file to do the experiement, and I did not save it.  Therefore I cannot clear the permission to check whether it works or not.  However, when I went back to the existing file, I found that the create new table option is available. 

 

However, the "Bind to parameter" option is not available!

 

When I looked around and when I looked back at one of your reference links, Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

I found under "considerations and limitations" that:

 

"

  • Dynamic M query parameters are not supported on Power BI Report Server.

"

 

And we are using Power BI Report Server.

 

Best regards