Help linking 2 SQL views

[Dean0]

Hi,

I am new to reporting writing in general but love the simplicity of Power BI for new comers but also the enhanced features for the more advanced out there 🙂

I have two SQL views that when I link them in crystal reports work fine but when I try to link them in Power BI I get the following message:-

We cannot creare a realtionship between '_AllOrdersWithRep'[HUID] and '_AllOrderDetails'[UID]. This could be because there is missing intermediate data to connect the two columns.

The views were setup by an SQL developer and have worked for him for a long time and also work great in crystal reports.

Any idea why they wont link in Power BI in the same way.

I hope that all makes sense and any help or direction will be greatly appreciated.

Cheers

[v-chuncz-msft]

Hi Dean0,

Based on my test, this error may occur when meets one of the following conditions.

• both columns '_AllOrdersWithRep'[HUID] and '_AllOrderDetails'[UID] contain duplicate values
• one of the two columns contains duplicate values and the other contains NULL value

[ankitpatira]

@Dean0 Basically what error means in one of the table there are values which doesn't exist in other table ie either UID or HUID column has values that does not exist in other. What you need to do is ensure is all values from your FK table exist in your PK table.