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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors