Multi-dimensional model with PowerBI on Import Mode

[Anonymous]

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 relationship between tables?

Also on PowerBI Desktop, can I create measures in DAX for all data sources? Am I going to have a problem with DAX Measures given that I have one multi-dimensional as a source among others?

Cheers!

[v-qiuyu-msft · Accepted solution]

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 

[Anonymous]

Sweet. Thanks

[v-qiuyu-msft]

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 

[BalaVenuGopal]

Hi @v-qiuyu-msft

I am using powerbi desktap i have created data model in power bi from the sql sources.Now shall i use this model for another report in another file ?

If yes do i need to save powerbi model file with different extention plese support .

[Anonymous]

I thought I did. Thanks and have a good day