Solved: the field you are moving cannot be placed in that ... - Page 2

aadames · ‎09-14-2016

When opening the ODC file in Excel, downloaded using the Analyze in Excel option for the dataset in Power BI Service, the measure is not available for the value area in the pivot table. The following error message appears: The field you area moving cannot be placed in that area of the report.

Curiously, if I connect from Excel to SSAS Cube the measure is available for the pivot table.

Any idea? I think this could be a bug.

Thanks,

Armando

v-yuezhe-msft · ‎09-19-2016

Hi @aadames,

I can reproduce your issue when connecting to SSAS cube from Power BI Desktop via “Import data” option, in this scenario, when you import measures of SSAS cube into Power BI Desktop, Desktop treats the imported model as a normal table and recognizes the measures as normal fields in this table, this behavior is by design. Thus, once you open ODC file of this dataset, you are not able to drag the measure into Values area, and you define a new measure based on original measure in order to work around this issue.

However, when connecting to SSAS cube from Power BI Desktop via “Connect live” option, measures are displayed as follows. And when you open ODC file of the dataset, you are able to drag measures into Values area.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

the field you are moving cannot be placed in that area of the report

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024