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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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