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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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,214,951
Messages
6,122,449
Members
449,083
Latest member
Ava19

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