Forum Discussion

ScottBeal's avatar
ScottBeal
Icon for Advocate I rankAdvocate I
7 years ago

Preview Error

We are receiving the error "Preview.Error: The type of the current preview value is too complex to display." in Power Query Editor. The table that is giving the error has worked up until sometime ov...
Need Help
ScottBeal's avatar
ScottBeal
Icon for Advocate I rankAdvocate I
7 years ago

With further investigation, the error seems to be related to foreign keys.

 

Here is one scenario that causes the error:

 

The table in question is a "Person" table.

We have a phone call table, with fk references to person, for the caller and recipient.

We also have a sales lead table, with fk references to person, for acct manager and sales rep.

With 2 references from each table we receive the "Too Complex Error".

If we remove any one of the 4 fk references (so that there are 2 from one table and 1 from the other) the "to complex" error goes away.

We also added a third fk reference to one of the tables, so that there is 3 from one table and 1 from the other.  This also caused the error.