Forum Discussion

alicemntt's avatar
alicemntt
Frequent Visitor
4 years ago

Update SQL query from a changing data in the dashboard

Hello all,    I'd like to change my SQL query in function of a data that I would change directly in the dashboard. It seems impossible but i'm still trying, hoping someone knows how to do it.  Her...
Need Help
Thejeswar's avatar
Thejeswar
Super User
4 years ago

Hi alicemntt ,

I doubt if this is possible. Changing of parameter in the Report Viewer Screen is way downstream from the place where you import the data. The Data selection that you make here will be available only for any downstream operations that you might do like adding a new column or new measure to the original dataset.

 

You can instead use Parameters inside Power Query to do the filtering and display the parameters as read only values in Data Card.

 

For the Users to be able to edit the parameter, you can use the approach that is used in the below video by Guy in a Cube

https://guyinacube.com/2017/05/24/dynamic-power-bi-reports-using-parameters/

 

Regards,

 

alicemntt's avatar
alicemntt
Frequent Visitor
4 years ago

Thank you for your response ! I did use the parameters even though it was not an ideal solution ... In the end I actually didn't need to change the date anymore so 🤷🏼‍♀️