Power Query - load connection to pivot table not available

karl_s678
Posts: 1
Joined: Wed Jun 03, 2020 5:43 pm

Power Query - load connection to pivot table not available

Postby karl_s678 » Wed Jun 03, 2020 6:56 pm

Hi! I established a connection between Excel and SharePoint list using PQ and I would like to load it to worksheet as a pivot table. The problem is that I only have two options in Load to menu: table and create connection only. Where did I go wrong? Is loading data as a pivot table from data model not available for SharePoint connection?

I am using Excel 2016 and SharePoint 2013.

BR.,
Karo

MattAllington
Posts: 1103
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Power Query - load connection to pivot table not available

Postby MattAllington » Thu Jun 04, 2020 5:11 pm

There should be a flag “add to data model”. Select connection, and “add to data model”. Then insert a pivot table after that.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 4 guests

cron