Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
haleyjn
New Member

How do I make the Power BI service refresh automatically when the Power BI Desktop is updated?

I have a dashboard that I update every week by entering new data into excel. I also have already published it to my workspace and shared with my team. 

 

My issue is - although I refresh the dashboard on the desktop, it won't refresh on the Power BI workspace. Instead, I have to republish it and replace it. Is there a way to have it update automatically??

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi , @haleyjn 

According to your problem and demand description, in fact, the data refresh on the desktop and the data refresh on the service are independent, because when you publish the report to the cloud, the dataset will be stored in the cloud database of PBI as cloud data, so you can enter configuration credentials for this Excel data source on the service to set up scheduled data refresh, you can refer to this official document for details:
Configure scheduled refresh - Power BI | Microsoft Learn

vyueyunzhmsft_0-1675652203503.png

If your Excel data source is stored in a local computer folder, you need to use a gateway as a bridge to connect the data to configure refresh for the dataset on the service, please refer to this official document for details:
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

View solution in original post

2 REPLIES 2
v-yueyunzh-msft
Community Support
Community Support

Hi , @haleyjn 

According to your problem and demand description, in fact, the data refresh on the desktop and the data refresh on the service are independent, because when you publish the report to the cloud, the dataset will be stored in the cloud database of PBI as cloud data, so you can enter configuration credentials for this Excel data source on the service to set up scheduled data refresh, you can refer to this official document for details:
Configure scheduled refresh - Power BI | Microsoft Learn

vyueyunzhmsft_0-1675652203503.png

If your Excel data source is stored in a local computer folder, you need to use a gateway as a bridge to connect the data to configure refresh for the dataset on the service, please refer to this official document for details:
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

otravers
Community Champion
Community Champion

You need to schedule the refresh in the service, forget Power BI Desktop. This means that your Excel spreadsheet needs to be accessible to the service, either in a cloud service like SharePoint (best way to do it) or using the data gateway if the file is on premises (more involved).

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.