Forum Discussion
How to format json data for PowerBI (Error: “Additional characters were found at the end of the JSON
Hello. I am sending data from Node-RED to the Azure Blob Storage and use the Storage Account as a Data Source for Power BI. The messages that arrive to Node-RED are being saved in a json file (every ...
Hi Anonymous ,
By my tests and research, this error should be caused by your incorrect json format.
Please correct your json format.
By my test, if you mofify your json format like below, we could import the json file successfully.
[ { "timestamp":"2019-05-11T22:39:13.908347", "current_ma":22, "voltage_mv":229979, "energy_wh":15, "power_mw":0 }, { "timestamp":"2019-05-11T22:39:18.843627", "current_ma":22, "voltage_mv":230069, "energy_wh":15, "power_mw":0 }, { "timestamp":"2019-05-11T22:39:23.935679", "current_ma":22, "voltage_mv":229988, "energy_wh":15, "power_mw":0 }, { "timestamp":"2019-05-11T22:39:28.865907", "current_ma":21, "voltage_mv":230048, "energy_wh":15, "power_mw":0 }, { "timestamp":"2019-05-11T22:39:33.810613", "current_ma":21, "voltage_mv":230081, "energy_wh":15, "power_mw":0 } ]Best Regards,
Cherry
Hello, I have the same problem I have an adf that automatically saved in my container Azure Blob Storage which use it as a source of data for power bi, the information in my adf are saved in JSON format every time you run a pipeline, when I try to get the data in power bi I get this error