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
Anonymous
Not applicable

DAX/MDX filter import SSAS on data model with multiple tables

Hello!

 

I have a short question regarding the DAX/MDX query when importing a SSAS database.

The database contains data of all projects, and I'm trying to import one specific projectnumber.

Currently I connect to the entire database via livequery and filter the projectnumber that I want, but for some projects I need to add external data to the dashboard, which is not possible with livequery. 

 

I've been looking into the MDX or DAX query options, but I'm not getting far.   

evaluate(filter('Projects', [Projectnumber]="abc123"))

For example this query only returns the one table. But the model has 4 tables, of which one contains the projectnumbers. 

 

1.png

 

My question is: How do i import this entire model, but filter out all except one projectnumber defined in the table projects?

 

thanks!

 

2.png

2 REPLIES 2
Anonymous
Not applicable

Ok so recently I learned that I can in fact import the entire model. I just have to import it per table instead of everything at once, and then recreate the relations in powerbi. That way I don't even need to filter anymore, because I can import the entire model. 

Hi @Anonymous ,

 

You may refer to this offical blog to learn more details about getting data from SSAS in Power BI.

For reference: Connect to Analysis Services tabular data in Power BI Desktop

If you want to pass filter-tables to your SSAS model, you should have a look here (also including the syntax on how to pass simple filter arguments into your MDX-statements).

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

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.