Forum Discussion
onenessboy
3 years agoNew Member
Data Type Issue in fabric dataware house
Hi I am trying Fabric, tried to load data from my Azure Sql database to Fabric DatawareHouse, Struggling with below error for much time. I read lot of documentation, I tried to create that column...
mwsmoley
2 years agoHelper II
Hello onenessboy,
I am not an expert and am new to Fabric and using the data warehouse in fabric as I come from a strong SQL server background. I have run into this issue myself and what you have to understand is that the data warehouse in Fabric is not tradiationl sql server as it is based on parquet files which have different rules. Fabric data warehouse does not have a nvarchar version and it suggests to use varchar instead. You can review the microsoft documentation at https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types for more details.