While Analyse in Excel is a good idea, essentially it would mean formatting the Pivot Table each time such a functionality is called. What we really need is to upload a Pivot Table to PowerBI.com as a report which can be called from the PowerBI interface, and which then connects to On-premise using the Enterprise Gateway. This will enable me to keep my PT format in tact and also use the awesome functionality of PT on PowerBI. However i believe you would use the Excel Services model for displaying the Pivot Table. My request is to bring the UI of excel services as near to the UI of Excel Pivot Tables.
on:
Tasks and Notes Pane in Power BI Desktop with Jira...
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
on:
Power BI Subscriptions enhancements sorely needed