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

Endeavor's avatar
Endeavor
Regular Visitor
7 years ago

Thank you Lydia. :smileyhappy: