I have a workbook with a Power Pivot table that is connected to an Access DB. The Power Pivot table has two different DB connections (using different DB queries) maintained in the Power Pivot window.
I created a pivot chart from the first PP DB connection and it worked fine. However, when I added a second pivot chart created from the second Power Pivot Window DB connection, it is using the first DB connection data, which it should use the second. I created the second chart explicity from the PP window using the second set of data and I can see in the PP window the correct data is in it. However, the second pivot chart still uses the data from the first connection.
Does anyone know how to resolve this or understand this?