Forum Discussion
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 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!
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
5 Replies
v-qiuyu-msftCommunity Support
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
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