Forum Discussion

alicemntt's avatar
alicemntt
Frequent Visitor
4 years ago

update SQL filter from a date from the dashboard

Hello all,   I'd like to know if a filter in a SQL query can be changed according to a date from within the dashboard : I import my datas from a SQL database so i prefilter my datas according to...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi alicemntt ,

 

I think the dynamic M query parameters would achieve a similar output. You need to connect to the SQL Server data source using the DirectQuery mode, and you can only change the parameter values sent to SQL Server using the slicer rather than manual input.

 

Dynamic M query parameters in Power BI Desktop (preview) 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

alicemntt's avatar
alicemntt
Frequent Visitor
4 years ago

Thank you for your response ! Actually it was not possible for me to use a Direct Query but yes otherwise it seems like it could have been a solution. But in the end I actually didn't need to change the date anymore so 🤷🏼‍♀️ Thank you anmyways !