Forum Discussion

Vanchy_Liao's avatar
Vanchy_Liao
Advocate IV
4 years ago
Solved

Preview.Error: The current preview value is too complex to display when using WebAPI

Hi,     I am trying to use Web API to deliver Data to end user.       My Developing environment is:     1. windows server 2019: to develop Power BI     2. windows server 2019: to develop Web API...
Need Help
  • Vanchy_Liao's avatar
    Vanchy_Liao
    4 years ago

    I overcome this issue myself.

     

    First, the difference between Edge and IE might caused by the browser security settings I guess.

     

    Second, the bottleneck is not on the Web Connector and it's on the JSON Connector.

    Because I save the JSON as file and import it into Power BI using JSON Connector, then it shows me the same message:

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

     

    Finally I edit my Web API making it return in XML format.

    My report just come alive again!!!!

    I sacrifice the file size and choose XML Connector.

Vanchy_Liao's avatar
Vanchy_Liao
Advocate IV
4 years ago

I overcome this issue myself.

 

First, the difference between Edge and IE might caused by the browser security settings I guess.

 

Second, the bottleneck is not on the Web Connector and it's on the JSON Connector.

Because I save the JSON as file and import it into Power BI using JSON Connector, then it shows me the same message:

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

 

Finally I edit my Web API making it return in XML format.

My report just come alive again!!!!

I sacrifice the file size and choose XML Connector.