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,
Yes, this what I'm thinking as well. But may I know how to do it in SQL Endpoint ?
Are you referring to that button "New sql query" and write the CAST over there like this ?
But, as this is just a query, how this will alter the table it self which then can be used in my data set outside (Power BI Dekstop)
Thanks,
Super UserHi 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.