Forum Discussion

illeke612's avatar
illeke612
Frequent Visitor
7 years ago

Get Data-SQL Server-Preview.Error The type of the current preview value is too complex to display

Dear,

 

I'm loading data from SQL server (on prem) and keep on getting the error when loading a particular table.

 

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

 

I used this table before in other reports (in fact we bumped into this error in an existing report where we want to change the query)

 

My M-code:

 

let
Source = Sql.Database("xxx", "xxx"),
vtCustomerSalesDataSchema_vtFactsProductCustomerSales = Source{[Schema="vtCustomerSalesDataSchema",Item="vtFactsProductCustomerSales"]}[Data]
in
vtCustomerSalesDataSchema_vtFactsProductCustomerSales

 

The error:

error message

I verified the table in SSMS:

it contains 138 columns and can't find any strange datatypes

 

I found many related error messages but they all refer to a CRM source
https://community.powerbi.com/t5/Issues/Preview-Error-The-type-of-the-current-preview-value-is-too/idc-p/171109/highlight/true#M7057

 

Can you please assist?

We cannot refresh our reports anymore because of this error.

 

Kind regards

Ilse

 

 

Need Help

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi illeke612 ,

     

    Based on my tested in Power BI desktop the latest version ,but not able to reproduce the issue. Would you please update your Power BI desktop to the latest version 2.68.5432.661 ,and then try it again? Or you can enable "tracing" in "file / options / diagnostics" to get the error detail information.

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.