Creating a pivot table with Connection only

[Certified]

Hi

I have a file with 72K lines of data (file A).

I created an query in file B from the file A data loaded as a connection only (query 1).

When I try to create a pivot in file B from query1, another query is created (query 2) underneath query 1. Furthermore, query 2 has a ton of errors.

I don't understand what is causing this. I was expecting to just pull that data from query 1 without an issue. Am I missing something?

 

[alansidman]

When you close and load, you need to check the box for "Add this Data to the Data Model" You can then open in Power Pivot directly. Don't really understand what is happening that is creating second query. Suggest you show us your Mcode for further analysis.