Forum Discussion

markew1's avatar
markew1
Icon for Advocate I rankAdvocate I
11 years ago

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

meysun's avatar
meysun
Icon for Resolver IV rankResolver IV
11 years ago

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's avatar
Kestenholz
New Member
11 years ago

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's avatar
    meysun
    Icon for Resolver IV rankResolver IV
    11 years ago
    Could you attach screenshot? Did you configure the credential in schedule refresh page?
    • lianna's avatar
      lianna
      New Member
      11 years ago

      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!

      error_200.png

      • lianna's avatar
        lianna
        New Member
        11 years ago

        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.