Forum Discussion
Difference between One drive refresh and Scheduled Refresh
Hi Thiyagu,
Based on my test, if you replace a PBIX file which has been imported into PBI with another PBIX file in onedrive, this will have no effect on the original PBIX or the loaded report. The data in the loaded report will be updated when data in data source is changed through gateway.
Regards,
Jimmy Tao
If you have data on OneDrive used in a Power BI report, by default, if the data on OneDrive changes, it will update the Power BI data model. This happens hourly. If all your data is on OneDrive, you don't need a gateway or scheduled refresh.
A gateway, personal or enterprise, is necessary if you have data locally on a harddrive or server. Once a gateway is in place, scheduled refreshes (up to 8 in 24 hours with a minimum of 30 minutes between each) will use the gateway to update the data model.
So if all your data is on OneDrive, you don't need a gateway and scheduled refreshes, just use the OneDrive refresh.
In your case, if you disable OneDrive refresh it'll go through the gateway refeshing on the schedule you've set up.
If it were me, I'd dispence with the Gateway, and just let OneDrive refesh do it's thing, much easier and avoids problems with the gateway not running etc.
Stuart
Hi Burningsuit
Thank you for your response. I'm not using any source from one drive, i have a data in our server so i need Gateway here.
I have placed my pbix file in workspace one drive. And i load the report to my workspace from onedrive (Get Data --> One Drive-Workspace-->Choose report--> Connect.
So my question is, if incase i have replaced my pbix file in one drive (Same report name). What will happen to my loaded report in workspace?
Thanks,
Thiyaga
If you upload a PBIX from OneDrive, Service wll keep the connection, and if you update or change the PBIX those changes are replicated into the cloud within the hour. However if you delete, rename or replace the file on OneDrive, it seems this connection is broken and the Service report will no longer be updated.
So if you replace your PBIX on OneDrive with a file of the same name, you have broken the link and replication will no longer take place. If you simply edit the file one OneDrive the updates will get replicated to the Service.
Stuart
If you upload a PBIX from OneDrive, Service wll keep the connection, and if you update or change the PBIX those changes are replicated into the cloud within the hour. However if you delete, rename or replace the file on OneDrive, it seems this connection is broken and the Service report will no longer be updated.
So if you replace your PBIX on OneDrive with a file of the same name, you have broken the link and replication will no longer take place. If you simply edit the file one OneDrive the updates will get replicated to the Service.
Stuart