Forum Discussion

JasonSquires's avatar
JasonSquires
Advocate I
3 years ago

Power BI keeps refreshing data set

I have a power bi dataset, prior to this week (2023-08-28), that has been refreshing once a day on a schedule without issue. For some reason this week, as I have profiler open in ADS, I see that the ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

try republishing from your pbix to the workspace. If that doesn't help, remove the report and the dataset from the workspace and then re-publish (warning - this will create a new set of GUIDs!)

 

Is the workspace on Premium?

JasonSquires's avatar
JasonSquires
Advocate I
2 years ago

Thank you for the reply and suggestions. I have tried the suggestions multiple times to no avail. The workspace is Premium as well. However, it is not a Premium level where I can change capacity. I get confused on the subscription levels because we also have PBI Embeded. But, I do not think this workspace is tied to that. Thoughts?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Taking a workspace out of Premium and putting it back in will also stop all currently running refreshes and queries.

    • JasonSquires's avatar
      JasonSquires
      Advocate I
      2 years ago

      Yeah, I acknowledge this. But that is not my primary issue. The primary issue is that it continues to run even after the backend SQL finishes running. Then, internally, it kicks off a refresh again. I see the same SQL code getting executed after a period of time. The spinning wheel never stops spinning. There is no refresh turned on either.