Query Load to -Option of Pivot table report not coming

[wouldbeca]

Hi, recently started using Excel professional 2016. I am not getting option of pivot table report while loading data to excel.

Can any body help. I am getting only two options:-

1. Load to
Table
Only Create Connection

 

[sandy666]

This is PowerQuery options
so,
Only Create Connection
then
Insert - Pivot Table - Use External Data Source (Choose proper Query Table) - (Choose where you want your Pivot Table)
then
Create your Pivot Table with data

 

[sandy666]

something like this:

 

[theBardd]

You want to add it to the datamodel as well to get that option in the pivot.