Invalid JSON - OLE DB or ODBC error

[tristenc]

Hello,

I am attempting to access data from Azure DevOps through an OData feed. When I try to "close & apply" my query, I'm receiving the following message:

"OLE DB or ODBC error: [DataSource.Error] OData: Invalid JSON. Unexpected end of input reached while processing a JSON string value.." 

Is anyone aware of the reason why this happens or how to fix it? I've even tried uninstalling and reinstalling PBI, but no luck (using the 64-bit desktop version). I appreciate the help!

[v-chuncz-msft]

@tristenc ,

The information is very limited. You may try to do research into The Advanced Editor.

[tristenc]

@v-chuncz-msft 

Unfortuantely that is all the information that the error provides. Is there any other information that would help answer the question?

[Anonymous]

Did you find any solution yet? i have the exact same problem.

[tristenc]

No - I still get this error on a regular basis. I've been doing some online searching, but no luck yet. I seem to have better luck when dealing with smaller data tables from the same source, but that is fairly inconsistent, so I'm not sure if there's a correlation between data size and this error frequency. 

[Anonymous]

Same here, after i added filters and removed a couple rows/columns i get it less frequent.