Preview.Error RRS feed

  • Question

  • Hi,

    I am using Power Query in our Company to connect to our gemstone database using Json. Since the last update of PQ we are not able to connect to the json anymore while getting this error: "Preview.Error: Der Typ des aktuellen Vorschauwerts ist zu komplex zum Anzeigen. (German 64 bit Office 365)". 

    We use the "From Web" option using a http link "http://somesite/somefilename.json". Loading the File local is possible and no error is shown.

    Does anyone know why this problem occurs only using the "From Web" option.

    The file is about 30 mb at the moment.

    Best Regards and thanks in advance

    • Edited by BerndSPL Tuesday, July 15, 2014 12:43 PM
    Tuesday, July 15, 2014 12:37 PM


  • Can you please report this problem using the "Send a Frown" feature? One additional thing it might be interesting to check first is whether the data that Power Query gets back is the same as the file you capture manually. You could determine this by using Fiddler or a similar tool to capture the HTTP request performed by Power Query and compare the result with the file you tested with.

    Tuesday, July 15, 2014 4:46 PM