Hi ResidentX10,
Which version of old Power Query and Excel did you use?
I tested in Excel 2010 and Excel 2016.
But I didn't find the feature in Excel 2010, did you know the name about the feature?
Which kind of data source did you use to connect?
Please provide more information about this problem and I'm glad to help you.
Regards,
Emi Zhang
TechNet Community Support
Please
mark the reply as an answer if you find it is helpful.
If you have feedback for TechNet Support, contact
tnmff@microsoft.com.