Hello guys,
I have a dataflow that get data from Azure Synapse, it was working fine for 2+ months and yesterday it started to fail.
When I am editing tables and click on "Refresh" button it loads new data.
But when I save dataflow and schedule refresh or trigger manual refresh it fails and gives the error below.
I have two custom/conditional columns added in this table, nothing big. When I remove them it works fine.
I have data type nvarchar(500) in Synapse, so can't figure why I have 8000 in the error.
Can you help?
Error: Data Source Error : DataSource.Error: Microsoft SQL: The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000). DataSourceKind = SQL
DataSourcePath = XXXXX;XXXX
Message = The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
ErrorCode = -2146232060
Number = 131
Class = 16.
RootActivityId = c0bf418d-3e95-4541-8039-0627a05be615.
Param1 = DataSource.
Error: Microsoft SQL: The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000). DataSourceKind = SQL
DataSourcePath = XXXXX;XXXX
Message = The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
ErrorCode = -2146232060
Number = 131
Class = 6
Request ID: e75f1383-8b30-448a-9da6-173d6eec266f.
