cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP_123
Microsoft
Microsoft

relationships 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 5
v-sihou-msft
Microsoft
Microsoft

Hi @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,

right, 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!!!!

@v-sihou-msft

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.

Qxi_623
Frequent Visitor

@karthik

I have the same issue here. I have to import data from SSAS cube since some new measure and calculation needed, which cannot be done in live connection. There is only one object (dimension+measures) in relationship view. When I need to import addtional columns that missed before, it displays in separate object and doesn't work to build relationship between them. Is that means I have to create from scratch every time or make sure ALL required columns included one time?

I'd suggest you to add all new measures in the cube if you are using the direct query connection. Import works well only when you want to extract a small sub-set of the data from the cube.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.