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!

54hesh5ltuog;ze

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

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

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

Pivot Table Right Click options to Expand/Collapse Entire Field

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

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.

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.

Include Power Pivot with Office 365 for Business subscription

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

Office 365 - Cloud - Enterprise.
Allow users to create Power Query queries, not just refresh a connection.

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.