Forum Discussion

michaelshparber's avatar
michaelshparber
Icon for Advocate V rankAdvocate V
6 years ago

Dataset refreshes immediately after publish

Some of my reports behave strange: Immediately after I publish my Desktop .pbix file to the service - it also starts a refresh... Even if it is scheduled for another time Why is that so and how ca...
Need Help
a_garnett's avatar
a_garnett
Frequent Visitor
6 years ago

I have also observed this behavior in some cases. In short:

  • In 4+ years of using Power BI with gateway servers, the normal and expected behavior I have observed is that when you publish a report containing an imported dataset, the new dataset overwrites what had been published previously, and is not refreshed until the user either manually initiates an on-demand refresh, or the next scheduled refresh takes place.
  • In cases where Incremental Refresh is enabled, it is normal for an on-demand refresh to be triggered when a new version of a report is published.
  • michaelshparber did not mention whether the report in question was set up for incremental refresh, but I have observed that occasionally, publishing a report without incremental refresh will also trigger a full refresh to take place upon publishing. This can create unnecessary delays in making updated content available to users. I have not observed any pattern to when and why this happens; it seems to only affect certain reports regardless of what kind of data source they have.

Is anyone else experiencing this behavior? This forum post is the only reference I have found online. I will submit a support ticket if it continues and I do not learn anything else from other commenters to this thread.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am having this issue too. It's extremely inconvenient as it keeps happening on a dataset that takes an hour to refresh. It's also very debilitating for access because you cant modify RLS security while the dataset is refreshing which means I can't give access until this refresh is done.

      • Anand24's avatar
        Anand24
        Icon for Super User rankSuper User
        6 years ago

        Hi Anonymous ,

         

        Afraid this is a by design feature of Power BI. Basically Power BI services takes the re-publish or publish of report as a changes of layout and data. This is why it will always automatically refresh which should be understandable because usually data changes are also to be reflected by many developers.

         

        However, you can definitely submit an idea here for optional data refresh.

         

        Give a thumbs up if this post helped you !!!