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' exc...
So the problem I have with that is it works with a normal gateway. The data source is a Synapse Delta table and the PowerBI data set just loads tables.