Support for refresh Pivot tables created with "Analyze in Excel"
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.
Double digits. Woot Woot
This functionality would be valuable to my clients
Joe Champagne commented
Today we can create the workbook with Analyze in Excel, host it in the Workbooks section, but do not have a way to refresh it automatically. Need the ability to have the underlying ODC connection refresh either on a schedule or automatically.