Import Model from SSAS to Power Bi

[Urid1969]

Hello friends

I have a question,  we have  an imported model option in Power Bi to connect to the SSAS, but it does not derive the realtionship

between tables within a model , so do you do guys ? Build one big view with many joins?

[v-qiuyu-msft · Accepted solution]

Hi @Urid1969,

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, if you want to keep relationship in desktop, I would suggest you connect to SSAS in a live mode.

Best Regards,
Qiuyun Yu