Forum Discussion
Can we change column type in Fabric SQL Endpoint ?
Hi,
I'm finally manage to make the column as Date. Figure it out that I better not using "Drag and Drop" on the csv file to my Lakehouse table. Instead doing the Get Data feature so I can manually change the column inside PowerQuery, before the table created.
Issue solved. Thanks.
Hi KenMann
When you use the Power Query data source from "SQL Server" you can insert a query, which you can use from your screenshot above, which will then bring the data in as Date.
I'm sorry, but I'm not quite understand what is the meaning by 'data source from "SQL Server" ', since my datasource is from CSV. And by looking at this resource : T-SQL surface area - Microsoft Fabric | Microsoft Learn
There are these limitation in SQL Endpoint:
Hi,
I'm finally manage to make the column as Date. Figure it out that I better not using "Drag and Drop" on the csv file to my Lakehouse table. Instead doing the Get Data feature so I can manually change the column inside PowerQuery, before the table created.
Issue solved. Thanks.