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
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
Regular Visitor

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.