topic Can't Display Visual Error in Developer

Can't Display Visual Error

Champ14 — Thu, 28 Jan 2021 08:56:41 GMT

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!

Re: Can't Display Visual Error

lbendlin — Sat, 30 Jan 2021 23:23:02 GMT

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.

Re: Can't Display Visual Error

v-lionel-msft — Mon, 01 Feb 2021 02:18:25 GMT

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.