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!

Would be much better with :
1) Slicer features
2) advanced graphical functions

Make it possible to match two sets of data using more than one reference column ,for example, if table1 has columns Bar Code, Description and Cost and table2 has columns Date, Bar Code and Cost, it should be possible to match the two data sets say using Bar code and Cost columns

In the offline version of Excel, you can double click a value in a pivot table and it will create a new sheet with the associated records.

Enable or allow users to refresh pivot tables while in shared mode. That way, teh group can ge the best reports, without losing history. Necessary in any environment where shared excel files are used.

The right click Show/Hide Field List on a pivot table does not save. My field list keeps coming back, even though I have set it to Hide.

I bought a Chromebook and was expecting to use Microsoft Office excel,word, Powerpoint, etc. but to find out that this is a lite/soft version of the actual Microsoft Office, I should of bought a regular computer

54hesh5ltuog;ze

Don't tell me I can't change data in a pivot table until I attempt to change it! I'm sick of dismissing a dialog when I select and COPY!

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!

After Pivot table, we are unable to pivot on updated data. its showing error like "can't overlap on Existing data" in Desktop Excel sheet having the feature like Analyze-Change Data Source option and we can update the updated data on Existing data and we can refresh the pivot as well as.

I bought a Chromebook and was expecting to use Microsoft Office excel,word, Powerpoint, etc. but to find out that this is a lite/soft version of the actual Microsoft Office, I should of bought a regular computer

When you get an error, provide the sintaxis that you should enter in the field

Pivot Table Right Click options to Expand/Collapse Entire Field

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

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 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 chart in online excel