Error when connecting to Sharepoint folder in Get Data in PBI desktop

[Anonymous]

Hello,

I ma trying to connect a Sharepoint subsite in PBI desktop with steps Get Data->Sharepoint folder. I enter the url till subsite.

Then I give proper credentials that has access to this site and when I click on connect I get the below error:

Details:"We found an extra character at the end of JSON input"

When I try to connect to an excel file (Get Data->Excel) which resides in same subsite, I am able to connect well. No problem here.

But I get error when connecting to Sharepoint Folder.

Thanks.

[v-yuta-msft]

@Anonymous ,

I could not reporduce this error. Is the sharepoint URL you have input valid? The format should be like below:

https://domain.sharepoint.com/sites/site_name

Please also update power bi desktop to the latest version and check again.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[trebgatte]

I created this blog post based on a similar question in the forum. The video shows you the steps to get connected. https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/

Hope this helps.

--Treb, Power BI MVP