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

[susmani]

Hello, professionals,

You see this error when you try to connect Power BI to the Sharepoint folder:

Can't connect

We found an error trying to connect

Details: "We found additional characters at the end of the JSON entry."

I tried to clear the global permit and tried again, the problem remained.

Any idea what the problem might be?

[v-lid-msft · Accepted solution]

Hi @susmani ,

Sorry for that but we cannot reproduce this issue, What is the version of your Power BI Desktop? Could you please try to verify if you can see any rows after creating following query?

let
    Source = SharePoint.Files("https://XXXXXXXX.sharepoint.com/AAA/BBB", [ApiVersion = 15])
in
    Source

Replace url with yours, if it does not work, please also try to use ApiVersion = 14. 

Best regards,

[susmani]

ApiVersion = 14 worked.

Really appreciate all the help.

[Greg_Deckler]

SharePoint Online or On-Premises?

If on-premises what version?

What connector are you using?