DataSource.Error we couldn't parse OData response result.

[LeGoat]

I'm trying to sync this website to my power bi data, it loads the first 1,000 rows but when I scroll to the 1,000th row this error comes up. There should be a total of around 1,500 rows showing. Please help I do not know what to do in order to fix this. 

[Anonymous]

@LeGoat 
Power BI desktop does cache the OData schema, and power bi cannot disable it for now. Try the workaround solution Clear Cache . Please refer to this post,  
https://community.powerbi.com/t5/Desktop/OData-issue-in-PowerBI-and-Excel-2016/td-p/291960

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LeGoat]

I don't get how to fix it by doing the clear cache? Could you do a show and tell for me. 

After I loaded my data the error popped up so I went to File --> Options and Settings --> Options --> Data load --> and then clicked on clear cache under management options and Q&A cache options but it did not do anything? 

@Anonymous 

[Pragati11]

Hi @LeGoat ,

What happens when you remove "_id" column? Does the error still persist?

Thanks,

Pragati

[LeGoat]

I tried that and it still gives the same error 

@Pragati11 

[amitchandak]

@LeGoat , has some column that has been removed or renamed at the source.

If yes. Open edit query/data transformation mode. and Right-click on the table and open Advance editor and and correct the changes

[Pragati11]

Hi @LeGoat ,

Can you share sceenshot of your data likw what columns it has got?

The error looks to me more like DATATYPE error in one of the columns.

Thanks.

Pragati

[LeGoat]

Here are some pictures that show all the colums in my data. I'm thinking it might be because of that first column labeled "__id". I'm not sure where that colum is coming from because on the website that is not one of the columns.  @Pragati11 @amitchandak