horseyride
Board Regular
- Joined
- Nov 2, 2017
- Messages
- 82
I have an issue that only started after an upgrade to Office 365 ProPlus 1708.8431.2215
If I create a PowerQuery using Connection Only, when I reference the connection later via a new pivot table [
Insert ... Pivot Table ... Use an External Data Source ... Choose Connection .... Query A ] then on the Queries & Connections list the Query gets duplicated and shown as Query A (1)
If I add another pivot, then Query A (2) shows up
If at the time of initial Query creation I create a PivotReport instead of Connection Only, this does not happen
Any solution other than deleting and recreating all my queries to have initial Pivot Reports ?
Thanks
If I create a PowerQuery using Connection Only, when I reference the connection later via a new pivot table [
Insert ... Pivot Table ... Use an External Data Source ... Choose Connection .... Query A ] then on the Queries & Connections list the Query gets duplicated and shown as Query A (1)
If I add another pivot, then Query A (2) shows up
If at the time of initial Query creation I create a PivotReport instead of Connection Only, this does not happen
Any solution other than deleting and recreating all my queries to have initial Pivot Reports ?
Thanks