Skip to main content
Microsoft Idea

Power BI

Needs Votes

Support for refresh Pivot tables created with "Analyze in Excel"

Vote (20) Share
Jeppe's profile image

Jeppe on 05 Aug 2016 15:31:33

I have a Power BI Services model (Power BI model created with Power BI desktop) and created a Excel pivot table using "Analyze in Excel". I would like to view and work with this Pivot table in Power BI Services.

It would be great to be able to use Pivot table in an Excel file hosted in Power BI (and/or Excel Online). The pivot reads data from the Power BI model.

Comments (4)
Jeppe's profile image Profile Picture

Nick on 05 Jul 2020 23:50:51

RE: Support for refresh Pivot tables created with "Analyze in Excel"

As much as we like Power BI, many of our users are still more at home working with BI in Excel. It seems strange to them (and to me), that we can publish an app with a Power BI report and Excel Workbook both sourced from the same dataset, and that the Power BI report will refresh and the Excel workbook will not.

Jeppe's profile image Profile Picture

Ken Beard on 05 Jul 2020 23:36:33

RE: Support for refresh Pivot tables created with "Analyze in Excel"

So helpful please MS why does this not work? PowerBI is not the only tool we need, we need excel for paginated reports.

Jeppe's profile image Profile Picture

Nathan Fredette on 05 Jul 2020 22:52:29

RE: Support for refresh Pivot tables created with "Analyze in Excel"

Double digits. Woot Woot

Jeppe's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:29

RE: Support for refresh Pivot tables created with "Analyze in Excel"

This functionality would be valuable to my clients