Forum Discussion

clqLoveSpace's avatar
clqLoveSpace
Advocate II
6 years ago

End User ability to change SQL query parameters

Hi All   One of the few things I liked about using Microsoft Query back in the day was the ability to put a ? in a query that could reference a cell value to accept a user-defined parameter into th...
Need Help
Tips and Tricks
TomMartens's avatar
TomMartens
Super User
6 years ago

Hey clqLoveSpace 

 

to some extent this can be achieved using query parameters:

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

 

But you have to be aware that this will only work, when the user(s) has access to the Power BI desktop file, as soon as the pbix gets published there will be (and also should) be one dataset that is shared between your users. Whenever a user changes the parameter values, that data will change and all other users will be affected.

 

Hopefully this provides you with some additional ideas.

 

Regards,

Tom

pawlowski6132's avatar
pawlowski6132
Helper V
5 years ago

Hi Tom, I would argue that I DO NOT want the same dataset for my users as different users have different authorizations to see different data. We should be able to define SQL parameters in a Direct Query (based on USERNAME()) which,  today we can't do as far as I know.