Unable to connect - Sharepoint folder ("We found extra characters at the end of JSON input.")

[susmani]

Hi, pros,

I am getting this error when trying to connect Power BI to Sharepoint folder:

Unable to connect

We encountered an error while trying to connect

Details: "We found extra characters at the end of JSON input."

I tried clearing global permission a tried again, the issue remained.

Any idea what could be the problem?

[v-juanli-msft]

Hi @susmani 

Follow the classic tips connecting to sharepoint folder with Power BI, it should work.

It is appreciated to share screenshots of your M query in Advanced editor for further analysis.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.