Forum Discussion
Helper IDataSource.Error we couldn't parse OData response result.
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.
7 Replies
LeGoatHere 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
- amitchandak
Super User
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
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
