Preview.Error: The type of the current preview value is too complex to display.

[Analitika]

Hello,

Whenever I try load data to Power BI. Via transform data I am getting that error message:

Preview.Error: The type of the current preview value is too complex to display.

Via report in dax i saw table contains just 457 rows. So no Idea why I can't be previewed. How to resolve this issue?

[Digger]

dont use json

[Gayatri_D05]

Hi @Analitika ,
May I know your datasource and how are you importing from the source.

[Analitika]

I am getting data from MySQL. Table looks like this:

I see this in DAX but can't see in Transform data section.

[Gayatri_D05]

Hi @Analitika ,
Few checks you can do is checking if your Powerbi is updated to the latest version.
If yes, and you ar egetting the same issue, its due to complex relatoinship that is taking place with the tabke even with the small data.
Try disabling this option and recheck:

If your requirement is solved, please make THIS ANSWER as SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you. 😊

[Analitika]

It didn't help me.