Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
calimero48
Helper II
Helper II

Dax query paremeter in Power BI import request

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

1 ACCEPTED 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

View solution in original post

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

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

v-deddai1-msft
Community Support
Community Support

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.