Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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 ...
Need Help
Qxi_623's avatar
Qxi_623
Frequent Visitor
10 years ago

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?

karthik's avatar
karthik
Icon for Advocate I rankAdvocate I
10 years ago

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.