Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Get Json file from Onedrive folder

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"

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    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.