Data from Query not Showing up in Pivot Table

[Tjfinley]

Hey All! Hoping someone can help me figure out what's going on with my pivot.

I am pulling 3 data tables into one query. The data comes from reports in our software. As of yesterday all of the data from the query was pulling into the pivot table. But I had to manually add some new data (that highlighted in yellow). The new data shows up in power query but will not show up in the pivot table.

After messing with it for a while it appears new data will pull into the query but not the pivot. And....I can change the amounts (Column C.E) on the existing data and they show up in the pivot correctly, but if I change the account number (Column1) or add a new account number, they will show up in the query but not the pivot.

I have filtered by fund 209, which is the fund of all the new data I added in. Data is on tab Actuals, pivot is on Sheet1.

Thanks. Have a wonderful day

[hansolu]

Hi,

I am not sure if I understand your request clearly. But what i see is that you have many many querys.
Why not load all of them into one fact table, create some dimenions like Funds and date, load all into dimensions and the fact table into the datamodel and then all should be fine?

just a thought

[Tjfinley]

Thank you. I have so many connections because the original document has 20 + tabs of tables and data. What I am currently working with is 3 tables that I pulled into 1 query. For the purpose of figuring out the current issue I deleted the unnecessary tabs, which is why you see so many connections with errors but less than 1/2 of them are actual queries. Thank you for the suggestion. I may have a way to implement the advice in another project. Have a good day!

[alansidman]

I remember reading somewhere that you need to Refresh All twice for the Power Pivot to refresh.