Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.