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

[karo]

Hi,

When I use Analyze in Excel export from Power BI Service it seems that my numeric fields are not recognized as numeric.  Does anyone know how to fix it?

Regards,

Karo

[v-yiruan-msft · Accepted solution]

Hi @karo ,

You can refer the method in the below links to resolve it:

Getting Error in PivotTable

Analyze Power BI Data in Excel

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[karo]

Thank you a lot @v-yiruan-msft .  I will try workaround from the link, but by quick test it seems that it can be a solution for me 🙂

[karo]

@Anonymous Thanks for reply. It seems that manual change of format is not an option ;(

Regards,

Karo

[Anonymous]

@karo  I can only think of changing the format of that particular column, to numbers in Excel