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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mindfulmike
Frequent Visitor

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

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!

2 REPLIES 2
hansontm
Resolver I
Resolver I

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

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. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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