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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
hxkresl
Helper V
Helper V

Visuals not refreshing to reflect changed excel source file data

how to refresh dashboard after changing excel source file?   I don't want to pull the dataset in as new dataset and have to recreate the dashboard.

 

 

other info:

source file columns and datatypes are same as previous file

getting no errors on refresh

verified that table view of source file contains the new data

I have even closed and reopened pbi report to see if that would force refresh.

am able to make new connection to new source file and recreate dashboard, and then the data is correct  

1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

Hi @hxkresl,

 

Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

Community Support Team _ Dale
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

4 REPLIES 4
v-jiascu-msft
Employee
Employee

Hi @hxkresl,

 

Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

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

To solve disconnect between tiles and dataset I took my dashboard down (deleted), republised datasets and recreated dashboard.   By not interfering with it since it has maintained sync 

v-jiascu-msft
Employee
Employee

Hi @hxkresl,

 

1. Did you use any filters or slicers?

2. Did you change the type of visual?

According to the document and my test, these two things above would influence the refresh. "pin live page" could be a workaround.

"A tile is a snapshot of your data, pinned to the dashboard."

"Tile refresh updates the cache for tile visuals, on the dashboard, once data changes. This happens about every fifteen minutes. You can also force a tile refresh by selecting the ellipsis (...) in the upper right of a dashboard and selecting Refresh dashboard tiles."Visuals not refreshing to reflect changed excel source file data.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Please reference: Dashboard-tiles-don-t-automatically-update-when-updated-report

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

There are multiple ways to refresh a data set.  If you are working in the Power BI desktop, there is simply a refresh button.

 

If you are working on the Power BI Web Service, you can either:

  • Refresh in the desktop file and press publish
  • Host the file somewhere like OneDrive for Business and set your file as 'directly connect'.
  • Host the file somewhere your computer has access too and refresh using a personal gateway
  • Have an on-premise data gateway and host the file somewhere this server has access to

 

With gateways and connections you can either refresh manually and/or set up scheduled times to handle the refresh.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.