Forum Discussion
Microsoft Employeerelationships in ssas cube
hi,
when i import data from the ssas to pbi,
the relationships active? or should i need them from scratch?
in the "manage relationship" i see one table with measures+dimensions, and not like a diagram
thanks a lot
5 Replies
v-sihou-msftHi MP_123,
When you import data from SSAS cube to Power BI Desktop, it will only import objects(like dimensions, measures) with data in SSAS database, then generate single result set baesd on all retrieved data. It works like the Query Designer in SSRS. The underlying tables with relateships in DSV will not be imported into Desktop so that you can only see a single table containting all dimension members and measures.
Regards,
MP_123right, i do see al like one table
so how i create relationship? i thoght the data come to desktop with whole the relationship like in the cube, if not, whats the point when importing cube?
when i created visualizaion, it seems like the data is correct. what am i missing?
thanks!!!!
karthikAdvocate I
As a best practice I wouldn't recommend importing the data from the cube as you would have significant performance issues when you bring in all the data (lowest level of granularity) for larger cubes. The import cube data feature is relevant only if you are working on a smaller subset of the data and it generates one single mdx query based on your selection criteria for attributes and measures in which case there will be just one table in Power BI holding the dataset of the mdx query generated.
The best option would be to use direct query feature available for Analysis Services (available for both Multi-Dimensional and Tabular). This is very similar to connecting the cubes using Excel. You don't need to worry about importing dimensions, measures etc. and creating relationships in Power BI. You just connect to the cubes and start building the charts.
Hope this makes sense.