Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
I have an DAX query with a parameter (codegpt) working as expected in DAX studio
EVALUATE
Var _phylevel2=SUMMARIZECOLUMNS(
Client[code],
FILTER(ALL(Client[GPTCOD-LV2]),Client[GPTCOD-LV2]=@codegpt))
return _phylevel2
I want now import the result in PowerBI desktop.
So
I created after the paramter codegpt ( Tick enable load and include in refresh report ).
I create a connexion to my SQLserver Analysis Server and paste my query to the DAX query.
And I got the error saying paremeter is codegpt is not declared.
What I am doing wrong?
Thanks in advance for your help
Solved! Go to Solution.
Hi
Thanks you for your response.
I succced to do it.
Just for others if this can help , my code:
let
codegpt = Text.Combine({ Character.FromNumber (34),CodegptParameter, Character.FromNumber (34)}),
QueryParamter=Text.Combine({"DEFINE var cdegpt=",codegpt}),
ActualQuery="
EVALUATE
Var _phylevel2=SUMMARIZECOLUMNS(
Client[code],
FILTER(ALL(Client[GPTCOD-LV2]),Client[GPTCOD-LV2]=@codegpt))
return _phylevel2",
finalquery=Text.Combine({QueryParamter,ActualQuery}),
source=AnalysisServices.Database("servername", "databasename", [Query=finalquery, Implementation="2.0"])
in
source
Best Regards
Hi @calimero48 ,
You need to update your desktop to the latest version and selected it in preview feature and restart it. It is provided for m-query based source. Please aslo refer to https://blog.crossjoin.co.uk/2020/12/06/using-power-bi-dynamic-m-parameters-in-dax-queries/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi
Thanks you for your response.
I succced to do it.
Just for others if this can help , my code:
let
codegpt = Text.Combine({ Character.FromNumber (34),CodegptParameter, Character.FromNumber (34)}),
QueryParamter=Text.Combine({"DEFINE var cdegpt=",codegpt}),
ActualQuery="
EVALUATE
Var _phylevel2=SUMMARIZECOLUMNS(
Client[code],
FILTER(ALL(Client[GPTCOD-LV2]),Client[GPTCOD-LV2]=@codegpt))
return _phylevel2",
finalquery=Text.Combine({QueryParamter,ActualQuery}),
source=AnalysisServices.Database("servername", "databasename", [Query=finalquery, Implementation="2.0"])
in
source
Best Regards
Hi @calimero48 ,
In power bi, we can't use query parameter directly in dax formula. You many need to use slicer or what-if parameter to hold the @codegpt in your post: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if and https://community.powerbi.com/t5/Desktop/use-parameters-in-dax/m-p/536343
And you can also refer to the following preview function: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi
The only solution I see it's:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
But i do not see how to implement it.
Best Regards
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |