Keeping data updated

170323003 , have you checked Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-or-date-instead-of-the-default-datetime/

 

Power Automate

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

Hi 170323003 ,

 

You will need an On-Premises gateway. This can either be the Personal or Enterprise version, but be mindful that the gateway will not refresh your data if the workstation that it runs on is switched off, so running on a laptop or similar that is switched off often is not the best choice.

As an example, in the past I have taken an old company workstation that was due for disposal, installed the Personal version of On-Premises gateway on it (doesn't require Admin authentication!), and left it running in a server room connected to the network to purely run PBI Service data refreshes on.

From here, it's as simple as setting up your datasets to refresh in the Power BI Service. Once you have published a report, go into the PBI Service and select to view 'Datasets' within your Workspace ('Datasets + dataflows' if you have the New Look switched on). Next to your dataset, you will see a button called 'Scheduled Refresh'. In here, select the days/times you want the report to be auto-refreshed and the PBI Service will do this automatically (again, providing that your gateway machine is switched on and has access to your SQL server).

 

Pete