Jun 13 2022 03:39 AM
I have a bit of trouble understanding the way Field Types in a Power Query get transferred to the resulting table in Excel and to Power bi afterwards.
I have some fields that are defined as Int.64 fields in the Power Query.
Once transferred into that Excel Table the filed are defined as a type 'General'
Once I use this table in Power Bi the Field is defined as a text field.
Is there a way to 'properly' define the field formats so they are recognized as an 'Int' in Power Bi directly?
Cheers
Jun 13 2022 06:39 AM
Data type and Format are different things, that is explained in details here Do Data Types Matter in Power Query? - The Excelguru BlogThe Excelguru Blog
Loading the table into Power BI data model if you didn't change data type explicitly it is considered as text. Same is for PowerPivot.
The only you need is to explicitly define data type loading Excel table into data model.