Forum Discussion

markew1's avatar
markew1
Advocate I
11 years ago

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

meysun's avatar
meysun
Resolver 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.

    • PBI77's avatar
      PBI77
      New Member
      11 years ago

      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