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
VerenaS
Frequent Visitor

Pass parameter to DAX Query within AnalysisServices.Database() statement

Hi all,

is is possible to pass a parameter to a DAX Query inside an AnalysisServices.Database() statement?

I have a Query like this:
= AnalysisServices.Database("Servername", "Databasename", [Query="DEFINE VAR ParamYear = 2014  EVALUATE ......... , Implementation="2.0"])

And I want to add a parameter "=@Year" to this query instead of inserting it like "=2014" as above. I already defined in PowerBI a parameter "Year" . How is it possible to pass the Power BI Year Parameter to the Query?
I want to avoid to query everything in the first step and set the filter in the second step, if it would be already possible to pass the parameter directly to this Query.....

1 ACCEPTED SOLUTION
Jimmy801
Community Champion
Community Champion

Hello @VerenaS 

 

this record-field "Query" takes a text. So cou can hardcode it or use a parameter. Here an example how it could look like

ParYear = "2014"
GetAnalysis = AnalysisServices.Database("Servername", "Databasename", [Query="YourQuerText Year=" & ParYear & " EVALUATE ........." , Implementation="2.0"])

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

View solution in original post

2 REPLIES 2
Jimmy801
Community Champion
Community Champion

Hello @VerenaS 

 

this record-field "Query" takes a text. So cou can hardcode it or use a parameter. Here an example how it could look like

ParYear = "2014"
GetAnalysis = AnalysisServices.Database("Servername", "Databasename", [Query="YourQuerText Year=" & ParYear & " EVALUATE ........." , Implementation="2.0"])

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

Thanks a lot for your help, Jimmy!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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