I have a problem with getting data into Power BI

[treesa2010]

Using python script I got a output file as follows which i have stored in a folder and I need that folder to be pulled into PowerBI

[{'Value': 26.5, 'Unit': '°C', 'WatchName': 'AvgSFTemp Present Value', 'Store': 'Omni'}, {'Value': 23, 'Unit': '°C', 'WatchName': 'SFCoolSP Present Value', 'Store': 'Omni'}]

But In my python code I had appended the intial json list array with key value pair 'Store': 'Omni' as shown above. And this is causing error while pulling data into Power BI.

Can you please help me in resolving it. 

Thanks 

 

[v-yiruan-msft]

Hi @treesa2010 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[v-yiruan-msft]

Hi @treesa2010,

Is the Transform File (2) the output file obtained by the Phython script? Is it a JSON file? Could you please share the applied codes of the query Transform File (2) with me for the purpose of making a troubleshooting? If possible, could you please also provide a simplified version of the output file obtained by the Phython script (without sensitive data)? Thank you. Applied codes in Advanced Editor

In addition, the following links are the threads which has the similar problem with yours. Please review the solution in them, hope they can help you.

Unexpected end of input was found in JSON content

---

this means a Json-file is corrupted. Maybe created by a interface. What you could do if one character is missing at the end and in case put it... so basically reading the binary from json, adding the missing character if missing and then reread it.

DataFormat.Error: We found extra characters at the end of JSON input

Best Regards

[treesa2010]

Sorry @VijayP. I did not understand what you just mentioned.

[VijayP]

@treesa2010  In the snap shot the error is showing for value = '  (single quote)

the error must be within that value parameter . 

[VijayP]

@treesa2010 

You need to check in the json or any other step for the second value , single quote is missing and that is what shown in the error!