Get Json file from Onedrive folder

[Anonymous]

Hi,

I am new to Power-BI And have a question:

I get data from sharepoint folder and connect to my onedrive

Then i receive the file name (.json) into a table. (Get a table with Source.Name) and Transform file column.

How do i load the file itself? 

Also when i press on the rows in content columns i get the error: "We found extra characters at the end of the .json input"

[lbendlin]

Use Json.Document() or right click the file and choose JSON. Or click on the Binary link and hope that Power Query recognizes the file as JSON.