cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Keeping data updated

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Keeping data updated

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

View solution in original post

3 REPLIES 3
Highlighted
Super User I
Super User I

Re: Keeping data updated

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

Highlighted
Microsoft
Microsoft

Re: Keeping data updated

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

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors