How can we improve Power BI?

Identify missing join values

Recently some Column Quality and Column Distribution checks have been introduced into the Query Editor, which are great.

A useful addition would be identifying Foreign Key values for which there's no corresponding Primary Key. A simple and common example of this would be identifying Customers who appear in the Sales fact table who don't appear in the Customer dimension table.

The join created by the developer would identify the Foreign/Primary Key relationship, and perhaps any such orphaned Fact table records could be highlighted against the join itself.

Currently such occurrences of this will usually result in Sales values posted against blank Customers in reports. The Customer value from the Fact table would have to be brought into the report to identify the missing Dimension table records.

6 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

UKanExcel (Mark Robinson @ Cloud2 Ltd) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.