Power Query - no pivot table in load to options RRS feed

  • Question

  • Hi! I established a connection between Excel file and SharePoint list 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.



    Wednesday, June 3, 2020 7:34 AM