Power Query close and load to

[srehman]

Hi Team,
Whenever i am close and load to from power query there is no option for power pivot, pivot table and pivot chart. While i have installed power pivot

 

[sandy666]

find and use at the bottom: Add to data model
then create Pivot and Pivot chart from there

 

[sandy666]

second option
Insert - Pivot Table
then

 

[srehman]

find and use at the bottom: Add to data model
then create Pivot and Pivot chart from the

 

[srehman]

Hi Sandy,
Thanks for quick response. My question was that when close and load to all option by default there.

 

[sandy666]

You need to understand Power Query
eg. I DON'T want Power Pivot loaded, but you want = conflict
so there is an options for this

but if you want there is a third option

or even you can use right click on table/query in Workbook Queries , Load to then

it's up 2 you

 

[srehman]

Load To,
Select how you want to view this data there is by default power pivot, power chart, pivot table.
I hope you understand

 

[sandy666]

afaik, Power Query in EX2016 doesn't have option like you show
you need to go through the steps I posted to create PT and PTChart
even in PowerBI you need do the same

 

[srehman]

All right got it thanks

 

[sandy666]

if you are talking about something like this

this is a wishful thinking ?