Forum Discussion
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 f...
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.