Hi guys,

I would like to use power query to synchronise the data between two workbook. In the data source workbook, there are some columns which contain text value and the column type is general.

However, while I was trying to import data using the Power Query, I found that the column type of those text column became "Int64.type" in the advanced editor view and the values were all NULL.

I've tried to changed the column type to text type in the editor view but it still does not work. But when I directly changed the column type on the data source workbook, it became valid when importing.

The point is, I am not allowed to change the column type of the data source workbook as it is owned by another department.

Are there any workarounds on this?

Appreciate a lot.