Power BI's Analyze in Excel functionality allows Excel users on the desktop to create reports using PivotTables and cube formulas connected to a published Power BI dataset. However (and this is very hard to explain to customers) these reports only work on the desktop: even though Power BI allows you to publish Excel workbooks to an App Workspace, reports created using Analyze In Excel do not work after they have been published to Power BI because Excel Online does not support connections to Power BI. Please fix this!663 votes
We are working on enabling connectivity from Excel on the web to Power BI. When this work is completed, a PivotTable that is connected to a Power BI dataset will be fully interactive when displayed in Excel on the web. It won’t matter how the PivotTable was created, whether by Analyze in Excel or in some other way. We look forward to implementing and deploying this capability, but I am not yet able to commit to a delivery date.
- Don't see your idea?