Invalid JSON - OLE DB or ODBC error

Question

Hello,&nbsp;I am attempting to access data from Azure DevOps through an OData feed. When I try to "close &amp; apply" my query, I'm receiving the following message:&nbsp;"OLE DB or ODBC error: [DataSource.Error] OData: Invalid JSON. Unexpected end of input reached while processing a JSON string value.."&nbsp;&nbsp;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!

anonymous · Answer

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

v-chuncz-msft · Answer

tristenc&nbsp;,
&nbsp;
The information is very limited. You may try to&nbsp;do research into&nbsp;The Advanced Editor.

tristenc · Answer

v-chuncz-msft&nbsp;&nbsp;Unfortuantely that is all the information that the error provides. Is there any other information that would help answer the question?

tristenc · Answer

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.&nbsp;

anonymous · Answer

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

Forum Discussion

Invalid JSON - OLE DB or ODBC error

5 Replies

Related content

Power BI Desktop Theme Import Error: JSON Syntax Invalid or Invalid Top-Level Property

Investigating intermittent JSON errors

Error ingesting json files in warehouse table

Invalid credentials Snowflake

Getting Error while pulling data from fabric lakehouse table: Error code 21446 Details Invalid table