Corrupt Excel Pivottable; same number on all months

[MikeHendriks]

We have some Excel files connected to a semantic model hosted in Power BI. Worked perfect for long period but since a week we get users complaining about a behaviour that is completely wrong; the total number is also displayed on all months;

Nothing works expect a 'clear all' in Excel which empties the complete pivot. Then we can rebuild succesfully.

Did somebody have had this before? Every hint we can get is very welcome

[MiKeZZa241 · Accepted solution]

Issue is fixed. It seems to be caused by a DAX statement with a filter on the monthnumber which gives back different values for the same DAX statement with the same pivottable. Very strange, but fixed it with KEEPFILTERS.

[v-saisrao-msft]

Hi @MiKeZZa241,

Great to hear the issue got fixed. Please accept your reply as a solution so that other community members with the same issue can find it more easily.

Thank you.

[MiKeZZa241]

I don't see that button/option somewhere??

[v-saisrao-msft]

Hi @MiKeZZa241,

Please refresh the page to see the "Accept as Solution" option, which you can find in the three dots menu mentioned above.

Thank you.

[MiKeZZa241]

I know how it works, but it's not there...

[v-saisrao-msft]

Hi @MiKeZZa241,

Please try logging in from another system and check if the options are visible.

Thank you.

[v-saisrao-msft]

Hi  @MikeHendriks,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @MikeHendriks,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Can you please confirm whether you are exporting the data manually or using another application? This will help us address the issue more effectively.

Thank you

[MiKeZZa241]

Hi @pborah  the semantic model is the source for the Excel file

[pborah]

@MikeHendriks are the excel files acting as data source to the semantic model or is the semantic model acting as a data source for the excel files?