Connectivity to SSAS

[dishathakuria]

When I connect to SSAS, I am able to import Dimensions and Measure Groups, but not the relationships. How does that work? My reports are not showing data because of the missing relationship.

[v-qiuyu-msft]

Hi @dishathakuria,

If we connect to SSAS in import mode, imported datasets are based on the checked measures and dimensions. Those measures and dimensions will be treated as "field" in a dataset. Relationships built on SSAS side will not be imported. In your scenario, I would suggest you connect to SSAS in a live mode.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[BhaveshPatel]

You can Select the automatic detection of the relationship option.

[BhaveshPatel]

Go to Manage Relationships and select Autodetect option.

Hope this would help to generate your report.

[dishathakuria]

@BhaveshPatel Hi Bhavesh,

For auto detection of relationships, i need to have the fact tables imported too. The relationship between dimensions and measure groups is always through fact tables (fact tables have the keys, measure groups dont). But in this case i am not able to import any data from the fact tables. When i try to import data from a cube, it gives me an option to omly import dimensions and/or measures.

@Greg_DecklerHi Smoupre,

I can very well create the relationships in the relationships window, but i need the fact tables to be imported for the same. In this case i am not able to import any data from the fact tables. When i try to import data from a cube, it gives me an option to omly import dimensions and/or measures.

[v-qiuyu-msft]

Hi @dishathakuria,

Have you read my original reply? In your scenario, I would suggest you use live connection instead of import mode. Please check this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/.

Best Regards,
Qiuyun Yu

[dishathakuria]

Hi Qiuyun,

Ys, i got your reply. I am unable to try that one yet, because the version of SQL Server that i am currently using (SQL Server 2012) is not supporting live connections to SSAS. 

I will try the solution suggested by you as soon as i am able to install the suggested version - SQL Server 2012 SP1. I should be able to confirm on this in a few days.

Thanks for your help!

Thanks,

Disha Thakuria

[dishathakuria]

When I connect to SSAS, I am able to import the Dimensions and the Measure Groups, but not the relationships between them.

How does it work? I am not able to see any data in my report because of the missing relationships.

[Greg_Deckler]

Can you go to the relationships tab in the Desktop and drag and drop to create the relationships? It is the third icon on the left (bottom icon)