Hi All, I have a power query and I have it loading to a table on a sheet.
I have a PivotTable looking at this Table.
In hindsight I should have loaded the power query as a connection only and pointed the PivotTable to the power query.
I can load the query as an connection only, but I can’t change the Data Source of the PivotTable to the power query.
I have changed the Data Source in the past form one table to another, and I think I gone form one power query to another
I have done a lot of formatting to that PivotTable, so I don’t really want to redo all the work.
Anyone know how to change the Data Source form a table to a Power Query
I have a PivotTable looking at this Table.
In hindsight I should have loaded the power query as a connection only and pointed the PivotTable to the power query.
I can load the query as an connection only, but I can’t change the Data Source of the PivotTable to the power query.
I have changed the Data Source in the past form one table to another, and I think I gone form one power query to another
I have done a lot of formatting to that PivotTable, so I don’t really want to redo all the work.
Anyone know how to change the Data Source form a table to a Power Query