Field You Are Moving Cannot Be Placed In that Area of the Report - Power BI Service Analyze in Excel

[JaclynPugh2022]

 I have a Power BI Desktop database that I published to Power BI Services – Premium Workspace online. As you can see below, and I have exported the data for Analysis in Excel.  My Values fields are not allowed to be moved into the Values field of the Microsoft Excel Analysis file.  Please see below.  Do you know why this is?  For example, I cannot move Net Payment Amount or Quantity into the Values section for Analysis.  See error below.

Example of Net Payment Amount data field, Data Type: Decimal, Format Currency.

Issue: After Publishing to Power BI Service - then, Export Analyze in Excel, I am unable to move any values field, such as quantity or Net Payment Amount into the Values area of the excel file pivot table. See below:  Error: "The field you are moving cannot be placed in that area of the report".

This makes the data useless and unable to do any analysis.  Please help!

Thank you

[v-yingjl]

When Analyze in Excel connects to an external OLAP model (which is how Excel connects to Power BI), the PivotTable requires measures to be defined in the external model, since all calculations are performed on the server. Some measures stored in your tables in Power BI. These “measure tables” are indicated by the Sigma symbol.

To address this issue, you can refer: Troubleshoot connecting Excel to Power BI data 

For more information , see: Power BI Analyze in Excel – What You Need to Know 

Best Regards,
Community Support Team _ Yingjie Li