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

[Anonymous]

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. 

 

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

thanks!

[Anonymous]

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. 

[v-rzhou-msft]

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.