Forum Discussion

KenMann's avatar
KenMann
Regular Visitor
2 years ago
Solved

Can we change column type in Fabric SQL Endpoint ?

Hi guys,   I have CSV file that I uploaded into my Lakehouse, soon after by using drag and drop to Tables, I would have 1 table created with the same structure as the CSV. It is actually a CSV cont...
Need Help
Show and Tell
  • KenMann's avatar
    KenMann
    2 years ago

    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.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

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.

KenMann's avatar
KenMann
Regular Visitor
2 years ago

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: