Forum Discussion
Use if parameters in query
Hi RiccardoBefore ,
Do you want to use the 'what if' parameter in the sql query?
It's impossible to achieve the idea in current version(2.83.5894.281 64-bit (July 2020)).
But you can use 'query' parameter to create dynamic data sources.
Dynamic Data Masking and Query Parameters
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RiccardoBefore , do you mean source query.
In advance option you can query of choice
Also, refer :
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Thank you, amitchandak .
I would have preferred a solution similar to that of Reporting Services.
This use of parameters is not usable by customers.
Thanks.
Riccardo
Hi RiccardoBefore ,
Do you want to use the 'what if' parameter in the sql query?
It's impossible to achieve the idea in current version(2.83.5894.281 64-bit (July 2020)).
But you can use 'query' parameter to create dynamic data sources.
Dynamic Data Masking and Query Parameters
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.