Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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. 

 

 

 

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

 

thanks!

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.