Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
52 | |
38 | |
24 | |
24 | |
20 |