found extra characters at the end of the JSON input error in Power BI DevOps report

[jasonyeung87]

Hi,

I have a Power BI report that queries DevOps for data to generate a report. It obtains the data by accessing the Graph URL and getting the JSON. The first line of the Power Query is:

Source = Json.Document(Web.Contents("https://vssps.dev.azure.com/" & Organization & "/_apis/graph/groups?api-version=6.0-preview.1")),

"Organization" is my company's organization. If I open the URL in the web browser, assuming the authentication is correct, the JSON file is returned. But when I try to refresh the data, I would somethines get the error:

[ValidateMarkupTags][ccon]DataFormat.Error: [ccon]We found extra characters at the end of the JSON input.[/ccon]. Value = [ccon]<[/ccon]. Position = [ccon]4[/ccon]. [/ccon].
The exception was raised by the IDbCommand interface. Table: AzureGroupsUsers.

Sometimes it would fix itself, but other times the problem would continue. I was wondering if there's a way to fix this problem? 

Jason

[lbendlin]

Inspect the data returned by Web.Contents, and switch to Web.BrowserContents if that gives you more details.

As you can probably appreciate it is nearly impossible to help with API queries without access to said API  (which you may not be willing to provide for understandable reasons)