Powerbi Service - Report dataset after re publishing

[LewisWilliams]

Hi 

Say i have a PBIX file saved locally last refreshed 01-Sept-2022, however this report is published into the service and has a scheduled refresh daily, if i open the PBIX file and do not refresh the data and republish it to the service, which dataset in the service is the report using the daily scheduled refresh or the recently republished dataset?

Thanks 

[Burningsuit · Accepted solution]

Hi @LewisWilliams 

When you republish an existing Report into the service you'll get a Warning to inform you that you'll be overwriting the Dataset, and that this may impact the Reports(s) associated with it.

So in your case you'll overwrite the Dataset with the data dated 01-Sept-2022, then when your scheduled daily refresh kicks in it'll update the Dataset again.

This is why there has recently been a new addition to download an existing Report, so you can download the Report without the associated dataset, connecting to the Dataset in the cloud. You can then make changes with Power BI desktop and repoblish the Report without changing the Dataset.

Hope this helps

Stuart

[LewisWilliams]

Hi Stuart

i just tested the ie replublishing an out of date pbix file and intially the report in the workspace showed the old pbix file data, however it also started a refresh ondemand, is this correct?

Thanks 

Lewis 

[Burningsuit]

Hi @LewisWilliams 

Yes, that looks like a wrinkle I missed, if automated refresh is scheduled, it'll fire an on-demand refresh when you publish the PBIX, very sensible really and stops the republished dataset being out of date for too long.

Stuart