Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Multi-dimensional model with PowerBI on Import Mode

Hello guys, Quick question, if I build a PowerBI Dashboard on Import Mode where one of the sources is an Olap Cube coming from SSAS, on PowerBI Desktop can I still see the diagram view and create ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    When we get data from SSAS cube in Import mode in Power BI desktop, the tables or relationships defined on SSAS side won't be imported to Power BI, we need to select dimensions or measures to generate a new table, then create relationships for these new tables on Power BI side. If you want to keep the SSAS model in Power BI, you need to connect to SSAS cube in a live connection (Connect Live). 

     

    In Power BI desktop, we can create measures for all imported data sources and SSAS tabular, but DirectQuery has some limitations. It's not able to create a measure when Connect Live to SSAS cube, you can vote on this idea: Calculated measures when live connected to MDX cubes. 

     

    Best Regards,
    Qiuyun Yu 

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

Do you have any other question? If you are satisfied with my response, would you please mark a helpful reply as an answer so we can close this thread? 

 

Best Regards,
Qiuyun Yu 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I thought I did. Thanks and have a good day