Excel Connectivity Incorrect Behaviour

[djbuncle]

Hi.

Has anyone come across the issue when connecting to PBI from Excel, where Excel treats some measures as dimension attributes.

E.g. A field, 'Num Players', which is defined as a whole number in PBI (and aggregates as such), when connecting from Excel is treated as a dimension attribute to slice on, not a measure you can place in the pivot table values.

I know a work-around is to create another field which is a calculation (which is very annoying when you have a lot of measures). But surely there's some other configuration to fix this!?

Thanks.