BUG: VNET Gateway Issue

[chriscooper71]

Standard PowerBI Gateway has no issues refreshing a dataset but when using the VNET Gateway we recieve this error:

Microsoft SQL: The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).\r\nThe size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000)

[GertJano]

We are experiencing the exact same issue.. not able to refresh PBI in the service based on varchar8000 (inferred datatypes) from synapse serverless.

[chavanr]

@Still_Lukad Yes, agree..it was fixed in April 23 & happened again..we have addresed this to the MS support team who is in touch with the product team because this has impacted our month-end reporting.

Cannot afford this kind of bugs & also it takes almost 1 week to fix the issue, very high downtime.

[PowerAndy]

we found a fix for this, very strange 😔

Looking in Native Query for nvarchar(max) and try to remove change type to text step in transforming.

Also Change Number to text or combine two strings makes nvarchar(max) in native query

[v-yanjiang-msft]

Hi all,

The issue was reactive internally, a fix is on the way. I will update here is there's any progress.

Best regards,

Community Support Team

[gertc]

Please indicate time line for the fix. We also see this issue for a couple of dataflows since May 7.  
Known workarounds would be appreciated as well. 

Is this bug the same as posted on PBI support page?:

[chavanr]

thanks @v-yanjiang-msft 

[Still_Lukad]

Issue still not fixed

[gertc]

latest status that also got confirmed by MS support:
"Engineers are actively working on a fix and they expect it to be deployed by end of day Monday (5/15)." 

[Still_Lukad]

Thanks for the information, @gertc !!!

/s

Awesome work by the official support that is active in this thread and keeping us up to date

/s

[gertc]

@Still_Lukad  I'm not MS support. Just opened a ticket with MS support and forwarding info.
For this specific high profile issue you can also follow the updates on PBI support page.
Support | Microsoft Power BI