Forum Discussion

mindfulmike's avatar
mindfulmike
Frequent Visitor
2 years ago

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!

Need Help

2 Replies

  • hansontm's avatar
    hansontm
    Resolver I
    2 years ago

    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's avatar
      mindfulmike
      Frequent Visitor
      2 years ago

      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.