topic Re: Dataset refreshes immediately after publish in Service

Dataset refreshes immediately after publish

michaelshparber — Sun, 19 Jan 2020 12:15:27 GMT

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 can I disable this?

Thanks

Re: Dataset refreshes immediately after publish

GilbertQ — Mon, 20 Jan 2020 00:42:13 GMT

Hi there

I think that they enabled this by design to make sure that once the data is uploaded that it has got the latest data.

As far as I am aware there are currently no settings to change this.

Re: Dataset refreshes immediately after publish

v-lionel-msft — Mon, 20 Jan 2020 08:22:27 GMT

Hi michaelshparber ,

Where is your data source from, local or online?

Test1:

After publishing, the dataset and the report don't refresh automatically when the data source is a local data source.

Test2:

After publishing, the dataset and the report don't refresh automatically when the data source is a cloud data source.

Test results: data is not refreshed automatically during publishing.

"Some of my reports behave strange":

Is there any particularity or commonality in your reports? such as data source, etc.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Dataset refreshes immediately after publish

GilbertQ — Mon, 20 Jan 2020 22:05:23 GMT

I have to say that when I tested this above it did indeed automatically refresh after I uploaded the dataset to the Power BI Service.

As you can see below I uploaded the file and immediately it refreshed the dataset.

Re: Dataset refreshes immediately after publish

a_garnett — Wed, 20 May 2020 18:36:09 GMT

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.

Re: Dataset refreshes immediately after publish

michaelshparber — Mon, 25 May 2020 14:23:39 GMT

a_garnett no incremental refresh in my report.

Re: Dataset refreshes immediately after publish

Anonymous — Tue, 25 Aug 2020 20:57:27 GMT

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.

Re: Dataset refreshes immediately after publish

Anand24 — Tue, 25 Aug 2020 21:26:30 GMT

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

Re: Dataset refreshes immediately after publish

michaelshparber — Sat, 05 Sep 2020 13:01:30 GMT

Anand24

It doesn't do it every time I republish.

So it must be something else

Re: Dataset refreshes immediately after publish

acecinati — Fri, 14 May 2021 12:39:06 GMT

Hi everyone,

I have the same issue. Power BI service update automatically the dataset after publishing.

My report has a standard import mode connection to an Oracle source and to a PBI Dataflow.

It's annoying cause there's no way to stop it! ...except for shout down the gateway.

Any solution?

Thanks in advance

Re: Dataset refreshes immediately after publish

cjpcman01 — Mon, 17 May 2021 17:11:30 GMT

I was also having this problem recently, started once i started using dataflows as one of the sources. To stop I disabled auto refresh first then, published, then once done reenabled the autorefresh setting and that seemed to work.