Analyze in Excel for Power BI Desktop is an external tool for Power BI Desktop that with a single click creates a new Excel PivotTable connected to the data