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


  • Hi there. Load to Pivot Table was not supported in Excel 2016. It was added in Excel 2019.


    Monday, June 8, 2020 4:27 PM