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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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