Solved: Re: Can't Display Visual Error

Champ14 · ‎01-28-2021

Hi Experts,

I am quite new in PowerBi though Ive took a course for it. Based on my understanding, as long as the system detects relationships between two tables, I am good to go, but when I try to combine these tables, it shows this

This is my relationship screen. Whats wrong with this? I tried to interchange the connectivity, but still the same issue.

The visual works when I removed the CR_InduCompliance table

Thank you!

v-lionel-msft · ‎01-31-2021

Hi @Champ14 ,

Try to modify the relationship as shown below.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-lionel-msft · ‎01-31-2021

Hi @Champ14 ,

Try to modify the relationship as shown below.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin · ‎01-30-2021

Follow the arrows. Looks like you have two fact tables, and are trying to display columns from both tables in the same visual. That's not possible. You can't get from here to there when you follow the arrows.

Rethink your data model. Especially LatestmasterFileStatus looks iffy. You may want to get that out of the way, or merge it into the A_MasterFileInfo table.