Excel Power Query - Query duplicates after inserting a pivot

[esssti]

Hi ,

since using Office 365, when i insert a Pivot for a query ( Insert - > PivotTable - > Use an external data source - > Selecting the query) , it gets immediately duplicated. As many pivot I instert the number of queries increase.
I am trying to build a more complex report with several pivots so keeping the duplicates is not an option. I'd like to keep my original 3 queries and not having many replica queries. (with excel 2016 i never had such an issue)
Any suggestions are appreciated.
Thanks!
Eszter

 

[Misca]

Try loading the data into the data model and create your pivot tables from there. This way you'll be able to benefit from the possibilities of the DAX language as well later on.

 

[GraH]

Load to pivot table is available in 365. Same as connection only, but pivot enabled.

 

[esssti]

Try loading the data into the data model and create your pivot tables from there. This way you'll be able to benefit from the possibilities of the DAX language as well later on.

Hi Misca, thanks for the suggestion. Thanks, seems to be working. Sorry, not sure about the DAX - you mean using it within excel? Thanks

 

[esssti]

Load to pivot table is available in 365. Same as connection only, but pivot enabled.

Hi Grah, I could load to a pivot, it just duplicated my queries.

 

[Misca]

The Power Pivot engine is - or at least that's how I've understood it - basically the same as in Power BI. The main difference is with Power Pivot you're stuck with the graphical limitations of Excel. The data model and basically all the DAX functions you're ever going to need are the same.

 

[GraH]

I think you might misunderstood what I tried to explain.
After Load To, select PivotTable Report or PivotChart

Query is loaded only once.