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!

Excel Online needs to be able to have full Pivot Table functions - we need to use excel online for sharing in the team but are frustrated without the ability to drill down!

Preferably, it would be great to be able to highlight the cells for the data range. At minimum, provide the format Excel is expecting.

Pivot Table Right Click options to Expand/Collapse Entire Field

online version still needs more enhancement to add power pivot and slicer.

Pivot Table Sheet Grouping - Group Pivot Table Sheets (Consolidate) similar to Web Page Menu Dropdown. Allow to group different types of Pivot Table Reports(Sheets) into expanding Vertical Sheet Tab (i.e. - Group Sales Reports, Employee Reports, Accounts Payables, etc...) How to group sheets - Use Ctrl and drag sheet within another sheet

Pivot Table column header should be renamed

pivot chart in online excel

Please add the ability to create a pivot table from an existing connection for Excel Online. This ability already exists for Excel.

Currently we're able to create a PivotTable in Excel 365 with ease. The trouble is with updating the data range or when the Data fields need to be extended. There are limited controls to access the normal pivot table Analyze & Design ribbons as within Excel Application.

creating a pivot-chart is not supported in Browser, I thought should allow the user to create pivot-chart.

The warning message "Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?" show every time a user opens a workbook with external connection or opens a page with a web part showing that workbook. That is the case even if the external data used in the workbook is located in a list on the same SharePoint site as the workbook. The message is very annoying to users and we need to have an option to disable it. This option already exists for SharePoint Server.

Excel Desktop PowerPivot Report connected to Azure Analysis Services Tabular model refreshing the data works in Excel Desktop.
However, when you publish this workbook to Power BI workspace (from the workbook's ribbon menu > File > Publish > Publish To Power BI) then you try to refresh the data in Excel Online it doesn't work!!!
Microsoft should fix this limitation otherwise what's the point of having a refresh capabilities for just Excel Desktop PowerPivot.
We want our end users to be able to refresh powerpivot reports Online.

Creating Sales Data in Calendar visualization be it month or a year.

Option of selecting Month/Year

Include Power Pivot with Office 365 for Business subscription

Learning videos that explain DAX measures & connect that with different functions of business like sales, HR , Supply chain management & procurement
Thank you

it would be great if dropbox supported PivotTables based on multiple consolidated ranges

So sometimes people misclick and accidnetally close and lock pivot tables, and after that point they are completely useless for adding new information into. There should really be a way to reopen them as this is currently causing an information entry issue at my work.

I use CUBEVALUE excel reports based on powerpivot data and with slicer. Slicers does not work on Excel Online.

Great that you have automatic date group in excel 2016, but it is calendar ordered. While it can be the default, there should be functionality to allow user to modify. Not everyone has the same fiscal quarters and year ends.