Forum Discussion

Endeavor's avatar
Endeavor
Regular Visitor
7 years ago
Solved

Cannot connect to JSON file located on SharePoint

When attempting to connect Power BI to a JSON file on SharePoint, and used the Copy link URL of the JSON file.  Received the following:     The JSON file points to an URL API.  There are no ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Endeavor,

    Please use SharePoint Folder connector instead.

    Enter the site URL of your SharePoint in SharePoint Folder connector, if you are using SharePoint online, please use Microsoft account authentication, if you are using on-premises sharepoint, please use Windows authentication.



    After loading data into Query Editor, then filter the extension to .json, click on Binary in Content column to expand data of the json file.





    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Endeavor,

Please use SharePoint Folder connector instead.

Enter the site URL of your SharePoint in SharePoint Folder connector, if you are using SharePoint online, please use Microsoft account authentication, if you are using on-premises sharepoint, please use Windows authentication.



After loading data into Query Editor, then filter the extension to .json, click on Binary in Content column to expand data of the json file.





Regards,
Lydia

mikkuusi's avatar
mikkuusi
New Member
1 year ago

Hi, excellent solution! Most of my json files flow through nicely! But, I have a rather large file that fails to convert. Not sure why. When using the json import from desktop even that file works fine, but not when trying through the sharepoint way. It does load, but some fields are missing. Is it due to the 1000 row limit or something? How to avoid the error.