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. Curre...
Need Help
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.