This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships.
Read more


Courses highlights
Reserve your seat in Charlotte or Munich for the upcoming DAX courses!

  Charlotte (Mar 24-26) Offer expiring!

  Munich (Mar 31-Apr 2) Last seats!

We also announced three courses in Australia in July and August 2020.


Latest news
• On-premises data gateway February 2020 update
Microsoft released an updated data gateway that you should install to keep the parity level with the Power BI engine. We hope to see the auto-update feature one day, so we can stop publishing this as news!
Feb 11,2020 · Microsoft
• How to convert a Power BI dataset to a Power BI dataflow
Michal Dvorak wrote a PowerShell script to quickly convert the Power Query transformations of a Power BI file into a Power BI dataflow. If you have always done this conversion manually in the past, you better understand the value of this time-saver tool!
Feb 10,2020 · Michal Dvorak
• Power BI E-Mail Subscription support for external e-mail addresses
Microsoft announced that starting in March, it will be possible to subscribe to a Power BI report using an external e-mail address. This article describe this new feature in detail, explaining the impact on security and the possible configurations.
Feb 13,2020 · Microsoft
• SQLBits conference in London
SQLBits is the largest Microsoft Data Platform conference in Europe, but this year it will be the largest in the world: 5 days (March 31-April 4), more than 300 sessions, and one or two outstanding announcements for Power BI. Big news coming in early April...
Feb 15,2020 · SQLBits
• Install Analysis Services 2019 CU2 as soon as possible
Microsoft released the first update to Analysis Services 2019 with SQL Server 2019 CU2. The previous SQL Server update (CU1) did not include any fixes for Analysis Services. This update is very important because it fixes bugs and performance issues in calculation groups that could also affect models that do not use calculation groups. This is a top priority update for Analysis Services 2019.
Feb 14,2020 · Microsoft

DAX Guide