Pivot from existing PowerQuery generates duplicate Query

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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
1. I sypuggets you log a bug
2. Why are you doing insert/pivot/external/choose etc? Why not load the query data to the Data model first, then insert a pivot from there.
 
Upvote 0

Forum statistics

Threads
1,215,454
Messages
6,124,933
Members
449,195
Latest member
Stevenciu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top