Keeping data updated

[170323003]

HI!

So my question is:

How can i constantly keep my data in power bi updated? I have data from an SQL Database, and i would like that the data on Power BI update like 1 time per day, getting the most recent version of the database. Can this be an automatic process? what can i do? I´ve searched for Power Automate but i dont know the best answer, so i aprecciate some help!

TY A LOT!

[v-deddai1-msft · Accepted solution]

Hi @170323003 ,

If you want to refresh your data in power bi service please refer to Configure scheduled refresh. 

If you want to refresh your data in power bi desktop. As of now, Automatic refresh is not available within Power BI Desktop. The only refresh option within BI Desktop is the manual Refresh you find in the top ribbon. Here is an idea: Auto refresh data in Power BI desktop 

And you can also refer to  Automatic page refresh in Power BI with direct query data source.

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

Best Regards,

Dedmon Dai

[BA_Pete]

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

[amitchandak]

@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-...
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-...

Power Automate

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