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

[Aca]

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

[v-qiuyu-msft]

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