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

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more

Reply
GMS1
Frequent Visitor

Analyze in Excel Issues - Excel data refresh

Hi all,
I have 2 excel files connected to the same semantic model in Power BI. The excel files are reports created from the semantic model.
I recently made some changes to the semantic model, and then tried to refresh the excel files.
One file refreshed fine, and I was able to update slicers no problem.
The second file however, either, won't complete the refresh when I click refresh all, or, will complete the refresh when I change a slicer, but won't pull in the changes in the semantic model.
I have tried to copy one of the pivots from the failing file to the file that works, but when i go to connect the slicer, I get a error
'Pivot table report is invalid. Try Refreshing the data'
Odd thing is, the pivot table copied to the working file actually refreshes ok.
So, main issue I want to solver is why won't one of the excel files pick up changes in the semantics model when refreshed.

1 ACCEPTED SOLUTION
GMS1
Frequent Visitor

I solved my issue, 
Seems that the existing slicers in the file that wasnt working were the issue.
Once I removed and specific slicer, saved the file and did a full refresh the changes in the semantic model came in.
I was then able to add the new slicer to the report.

View solution in original post

1 REPLY 1
GMS1
Frequent Visitor

I solved my issue, 
Seems that the existing slicers in the file that wasnt working were the issue.
Once I removed and specific slicer, saved the file and did a full refresh the changes in the semantic model came in.
I was then able to add the new slicer to the report.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.