Forum Discussion
Why am I getting a Scheduled Data Refresh error indicating a Status Code 200?
OK I think I figured it out. I had a Linked Table data source (PowerQuery ribbon > Excel Data > From Table). Sometimes it broke the refresh immediately and sometimes it worked at first and broke later.
Unfortunately removing the problem linked table PowerQuery does not fix refresh. I had to rebuild the data model without linked tables.
I am getting this same issue. I have a connection via odata and works fine in desktop and excel but when i publish it or upload it i get status 200 error when trying to schedule refresh