Using Mendix OData resources in MS-Excel

By default all numbers in Excel are stored in a datatype that is too small to store Mendix Ids. If you need the id, for example to define relations between rows in different entities, you can change the data model from an oData resource in Powerpivot data model. You need to set the data type to whole number to see the entire mendix id:

Whole number