Forum Discussion
Advocate IWhy am I getting a Scheduled Data Refresh error indicating a Status Code 200?
Has this been solved yet? I am connecting to two SharePoint list sources in O365 (via ODATA) and they work fine in the PowerBI designer. When trying to add them to the PowerBI site they fail to allow refresh - error code 200. I tried to upload using the "select file" from the web - didnt work.
Resolver IVSame problem here. I added a PowerPivot data model that connects to Azure SQL to the Power BI online site (not Desktop).
I can't get to the credentials page because of the error (status code 200).
Is there a list somewhere of what the different error status codes mean?
Thanks!
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
