Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Creating relationships in an SSAS Tabular model vs Power BI

I have an SSAS Tabular model composed of a fact table and 3 dimensions.
I want to understand what is the difference between creating the relationships in the tabular model in advance comparing to import the tables or using a direct query and then create the relationships in Power BI ?

>Solution :

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

If you DirectQuery to SSAS Tabular, then the measures and relationships should already be included.

Power BI essentially is SSAS Tabular under the hood, so the calculations should be the same whether you build your model in Power BI Desktop or SSAS Tabular. The difference is where you’re running it. If you have SSAS Tabular on a strong server, DirectQuery might be faster than running the computations locally in Power BI Desktop.

1 comments

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading