Datatype Issues with Power Query Editor

[locopete999]

Hi All,

I have an issue with Power Query Editor, and didn't really know where it goes on this forum.

I've attached two pictures to hopefully show the issue.

When I download data from a database from an ODBC connection, the Power Query Editor shows that it has detected the data type on certain columns as text and others as whole numbers etc.

The problem is then once it is loaded into Excel, all the data types now become general.

Ordinarily for myself this wouldn't be an issue as i would then do further work on the data, but i have colleagues who are downloading the data to make a change on the it before re-uploading it into the database.

Because the data is losing its data type, it is causing issues when uploading.

Has anyone else encountered this issue and have any suggestions that might help?