What is this $ExternalData_1 supposed to mean in Excel PowerPivot and PowerQuery?

0
votes

I am using Excel 2016 to clean my dataset using PowerQuery.

Let's say the data table is in Sheet1, and the cleaned data table produced by PowerQuery is Sheet2.

Now when I try to import the table in the Sheet2 to PowerPivot, the Table Import Wizard showed this:

Sheet2 

Sheet2$ExternalData_1

Both of which look identical to me, and I just can't see the difference between them, but I don't want to choose the wrong source here. To avoid needless problems in the future, can anyone enlighten me what's the difference between them and which one should I choose as my source table?

Thanks!

1
excelvbapowerquerypowerpivot

1 Answers

0
votes

I'd recommend you to load the data directly into a pivotable instead of creating a new table and its pivotable. It will reduce the error of choosing the wrong one.