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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GMS1
New Member

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
New Member

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
New Member

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors