Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Anonymous
Not applicable

Dataflow refresh error - ErrorCode = -2146232060, Number = 131, Class = 6

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.

 

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.