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

[BarrilleauxAP]

I have seen older threads related to this however i have not found anything that is definitive as to the cause.  I get this on one table from a SQL Server database. Tried Direct Query & Import.   I have other tables far more complex than this one that import with no issues. 

If i open the native query window and enter "select * from dbo.coitem_mst" i get the data with no issue. 

I am using version 2.79.  I am hoping someone has some addtional clarity on what causes this error.

[v-frfei-msft]

Hi @BarrilleauxAP ,

Based on my test using Power bi desktop Version: 2.79.5768.1082 64-bit (March 2020). I cannot reproduce your issue here. Could you please update your Power bi desktop to check again or you can disable the option to have a test.

[kreiss]

Add me to the list.  Same issue.  Even on a really small (12 row, 6 column) table.  Help!

[pcalhoun]

I am having the same error when I am pulling data from Netsuite.

I could use help solving this problem.

Thanks

Phil

[BarrilleauxAP]

I confirmed that i am running that version.

I also disabled the option you recommended and tried again but obtained the same result.