Data Refresh issues with On Premise Gateway

[abhiman]

Scheduled and on-deman Dataset refreshes throwing errors since 19/05/2018, which was previously working fine.

Error seen in Power BI Service schedule history:

Error seen in On Premise Power BI Gateway Diagnostic logs below:

DM.EnterpriseGateway Warning: 0 : 2018-05-21T03:10:27.8600426Z DM.EnterpriseGateway f542527e-ec15-4156-8962-ee43063c6ea3 79aebb0f-147e-4148-bd89-db3cba5c3c76 MGCC 79aebb0f-147e-4148-bd89-db3cba5c3c76 359963D8 [DataMovement.PipeLine.MashupCommon] Failed to find referenced data sources. Exception: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException: Mashup extension kind is not loaded TemplateMessage: Mashup extension SQL does not load into Mashup Engine

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError ExtensionKind=SQL ([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException.StackTrace:) at Microsoft.PowerBI.DataMovement.MashupExtensionsDiscovery.MashupExtensionsManager.IsExtensionDQSupported(String extensionKind, String version) at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.IsDataSourceDQSupported(DbConnection dbConnection)

We have the latest version of the gateway 14.16.6697.1 (May 2018)

Please advise what is causing this issue since the weekend 19/05/2018

[abhiman]

Unable to refresh SQL Server Datasets on Datasources set up on On Premise Data gateway.

The scheduled refreshes are throwing the below error since 19/05:

DM.EnterpriseGateway Warning: 0 : 2018-05-21T03:10:27.8600426Z DM.EnterpriseGateway f542527e-ec15-4156-8962-ee43063c6ea3 79aebb0f-147e-4148-bd89-db3cba5c3c76 MGCC 79aebb0f-147e-4148-bd89-db3cba5c3c76 359963D8 [DataMovement.PipeLine.MashupCommon] Failed to find referenced data sources. Exception: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException: Mashup extension kind is not loaded TemplateMessage: Mashup extension SQL does not load into Mashup Engine

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError ExtensionKind=SQL ([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException.StackTrace:) at Microsoft.PowerBI.DataMovement.MashupExtensionsDiscovery.MashupExtensionsManager.IsExtensionDQSupported(String extensionKind, String version) at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.IsDataSourceDQSupported(DbConnection dbConnection)

Any help would be appreciated as the error is not clear to me.

Thank you.

[v-qiuyu-msft]

Hi @abhiman,

Does the issue happen to refreshing Excel with on-premise data? This is a known issue here: https://powerbi.microsoft.com/en-us/support/

If it's not, please download the same report, reduce data model and ensure it can be refreshed in Power BI desktop, then publish as a new report. On Power BI service, please ensure the gateway and data sources created under gateway are online and the new dataset has been configured to use the gateway fine, then refresh the dataset. 

Best Regards,
Qiuyun Yu 

[abhiman]

Hi v-qiuyu-msft ,

Thanks for getting back to my post.

My responses to your queries below:

Does the issue happen to refreshing Excel with on-premise data?

The issue is only occuring on On Premise SQL Server Datasources not with excel.

The issue did not occur prior to 19/05, scheduled and on demand refreshes where successful until 18/05 on these datasources.

If it's not, please download the same report, reduce data model and ensure it can be refreshed in Power BI desktop, then publish as a new report.

- Yes I have tried that, still having the same issues.

On Power BI service, please ensure the gateway and data sources created under gateway are online and the new dataset has been configured to use the gateway fine, then refresh the dataset. 

- The Gateway is online and the connection test for the datasource is also successful.

Not sure what else to check or what could be causing this issue?

Can you advise what the below error on the gateway indicates?

Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException: Mashup extension kind is not loaded TemplateMessage: Mashup extension SQL does not load into Mashup Engine

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError ExtensionKind=SQL