Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Error while retrieving the OData - couldn't parse OData response result

Hello everyone, 

 

I'm using Power BI tool to get some data from Web Application. In order to do that I need to consume Published OData Service from that application. During the sync with this OData I received an error. Description of this error looks like: 

 

''DataSource.Error - We couldn't parse OData response result. Error '?', hexadecimal value 0x0B, is an invalid character. Line 15873, position 16514''. 

 

If I understand correctly, this error means that something is wrong with the data that I'm trying to retrieve from this Web Application. So my question here is: Is it possible to find specific data that is responsible for this error? If we look into the description of this error we can see ''Line 15873, position 16514''. Is it possible to find this line and position in Power BI? 

 

Thank you in advance,

 

Kind regards,

Aleksandar Alempic

 

 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Aca,

 

Please copy the OData URL in web browser to see if there is data returned. 

 

When you get data from OData in Power BI desktop, you can run Fiddler with below option enabled to capture the trace. Please share this .saz file with us. 

 

Best Regards,
Qiuyun Yu