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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Refresh data set from Excel Table - Drill-down field in visual not changed

After searching the community posts, I could not find a solution to this issue. It seems simple, but maybe not.  I am in Desktop BI where I have three tables; two are related and the third is independent and used for different time frame from first data set.  When I drill down in a visual I see that one field has an old Note term (e.g. "Top Six Sal Adj") and it should say just "Salary Adj."  So, I went back to my Excel table (9K records) and using drop-down on the Note field and found the Top Six Sal Adj line; then changed it to just "Salary Adj;" then saved the Excel.  Then in BI Desktop I have the same report page open as before and the visual is active showing Drill-down with "Top Six Sal Adj", and I click Refresh. All the sources are shown refreshing. But ... the Top Six Sal Adj note remains in my visual drill-down even though I changed it in my source Excel table.  Does this issue have anything to do with the fact that I am using Drill Down (hierarchy)??  Thanks for any help on this.  Jeff

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous,


Glad to hear the issue is resolved. You can accept your reply as solution, that way, other community members would benefit from your solution.

Thanks,
Lydia Zhang

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Solution Found.  I made change in wrong Excel table (the original table of data instead of the "final" table.

Jeff

Anonymous
Not applicable

Hi @Anonymous,


Glad to hear the issue is resolved. You can accept your reply as solution, that way, other community members would benefit from your solution.

Thanks,
Lydia Zhang

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.