Data correct in Power Query but not pulling correctly in matrix visual

[mindfulmike]

Hi, first time coming across this issue. I see the data in Power Query under the correct code but in my Matrix table, the item is not coming through correctly It is completely missing when I filter for the code. There's no filters on the Matrix either or dashborad page. It's only happening to brand new items i've added to the excel background data, any data I change to already existing items refresh and get pulled into the Matrix without issue. 

Any ideas?

Thanks in advance!

[hansontm]

Is the data/record visible in the power bi desktop data view? 

If no, then it's how you are pulling the data from excel into power bi. Are you connecting to a table which is only pulling a specified range?

If data is in the data view, we'll need to take a look at how your matrix is constructed

Please share any relevant screenshots

[mindfulmike]

Hi Hansontm, apologies for the late reply, I was able to fix my issue. It was related to the background modeling. Since there were files for 2023 and 2024 some of the connections became a little fuzzy. After archiving the 2023 data and dleteing it from my dataset, everything is working fine.