We found extra characters at the end of JSON input

[Felix]

I'm using Azure Stream Analytics to transfer device data from an Iot Hub to a blob storage. But if I try to connect Power BI Desktop and use "Edit Query" to get the content of the blob for my report I get the error: "We found extra characters at the end of JSON input". Same problem occurs if I download the json-file and try to import it to Power BI Desktop This problem is already discussed at https://community.powerbi.com/t5/Desktop/We-found-extra-characters-at-the-end-of-JSON-input/td-p/20607, but there is still no solution for that problem!!

[thomas_pagel]

This is a problem with other JSON deliveries from Azure as well like IoT hub etc. It's because Azure is not creating "pure" JSONs but "JSON Line" format, so each line in the file is representing an own JSON document. Power BI can't handle that. This is very bad since analyzing files created by Azure should be one of the primary use cases for Power BI!