Error with refresh: "We found extra characters at the end of JSON input"

[shellacademic]

I am importing data directly from the VSTS API in JSON. This works fine in the Power BI Desktop and when I upload the DataSet to the PowerBi Service. However, when I schedule a refresh of the data I get the following error:

Last refresh failed: Thu Oct 19 2017 13:49:13 GMT+0100 (GMT Summer Time)
There was an error when processing the data in the dataset.

Message: We found extra characters at the end of JSON input. Table: BuildDefinitionCollections.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: bc317ccc-1c86-424d-900f-d8fd21846239
Request ID: d581c802-a16e-7e66-2e12-8608d6c08949
Time: 2017-10-19 12:49:13Z

[devchau]

I also got stuck in same issue. Any workaround ?

[v-huizhn-msft · Accepted solution]

Hi @shellacademic,

It sounds like there's some specific data processing scenario that's not being accounted in Power BI service, please check the table: BuildDefinitionCollections. We have no power to check your data background. I personally suggest you create a support ticket on the right bottom of page for better assistance.

Best Regards,
Angelia

[shellacademic]

OK thanks, I created a support ticket.

[yssant]

hi, does this have a solution? i have same problem