Why am I getting a Scheduled Data Refresh error indicating a Status Code 200?

[KanaseSushil]

Have the same issue when connecting to a SSAS over HTTP using Basic Authentication.

I am able to connect SSAS over HTTP using Basic Authentication in Power BI Desktop.

When publish to Power BI portal is show only “windows” and “Undefined” in authentication method.

[meysun]

Are you using Power BI Desktop and publishing the file directly? If so, there is known issue. Please upload the file using browser Get Data in the service and you should be able to schedule refresh.

The Power BI Desktop publishing bug is fixed and should be rolloed out to production soon.

[Kestenholz]

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.

[meysun]

Could you attach screenshot? Did you configure the credential in schedule refresh page?

[lianna]

Same 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!

[lianna]

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.

[PBI77]

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