Forum Discussion
Pivot Table creating new data source every refresh
Just like the title says I have a pivot table linked to a dynamic data source (sql query) that changes in range size on sheet1 and on sheet2 a pivot table that is just used to format the same data wi...
okay I attached a screenshot of the data sources, picture 1 is the datapage and pivot table is the pivot table, when I first created the pivot table I told it to get the data from the existing CompanyDataNew table and when I refresh it makes it own with a new number and the other one doesn't do that.
Unfortunately, those images show the SQL, but don't really address the questions and assumptions I made. If all this is about Power Query, I am not in a position to offer help. My questions and assumptions had to do with the Excel portions of your situation (apart from Power Query). If you care to try again, please do. Otherwise, we'll have to await somebody else with Power Query experience.