Gateway Error on Newly published Paginated Reports

[BillatREM]

I am getting the following error when I try to access pagineted reports on our PowerBI Services.  This error only happens on reports published today, all other reports with the same Gateway work fine.

Error Message: Unable to render paginated report

A data source used by this report returned an error. If you continue to experience this error contact the report author or data source owner quoting: DM_GWPipeline_Gateway_FeatureNotSupported. Received error payload from gateway service with ID 1998743: No DB connection provider factory for provider 'Microsoft.Data.SqlClient' has been registered..

The target Gateway does not support the requested feature.

No DB connection provider factory for provider 'Microsoft.Data.SqlClient' has been registered. 

This report is almost identical to other working reports.  Anyone have an idea of how to fix this?

[danielgoodwill]

We are having the same issue. It is only affecting new pagianted reports. Exisitng reports are working as expected. We also tried updating the gateway to the newest version, but it did not help.  

[redwolfie]

We have come across a similar problem, but unfortunately, we have not been able to find a solution for it yet.

[Charl3]

I have the same issue. 

Unable to render paginated report
A data source used by this report returned an error. If you continue to experience this error contact the report author or data source owner quoting: DM_GWPipeline_Gateway_FeatureNotSupported. Received error payload from gateway service with ID 268375: No DB connection provider factory for provider 'Microsoft.Data.SqlClient' has been registered.. The target Gateway does not support the requested feature. No DB connection provider factory for provider 'Microsoft.Data.SqlClient' has been registered. Learn more: https://aka.ms/pbiservicegatewaylearnmore.

[mganeshphani]

updating the gateway to the recent version fixed our issues

[annerator]

We're having the same issue here and are unable to publish any paginated reports. Microsoft, when are you going to fix this?!???!!!

[AnAnTaReZa]

Exact same issue here as well, no workaround. Non Fabric, pro workspaces.

[bw05]

We are seeing this same issue.  Haven't discovered a fix yet.

[Conlyn]

I am also seeing this issue.  When digging into the logs it seems that the previously published reports used the old "System.Data.SqlClient".  Something must have changed in the publish mechanism to have paginated reports use the updated "Microsoft.Data.SqlClient" instead of the original one that is registered on the gateway.

Please change this back to the old SqlClient while also giving us instructions to update our gateway to register the newer SqlClient so that when this change happens again we won't have failing reports.

-Conlyn

[nikkihital22]

How do we change the old sqlclient

[nikkihital22]

We are facing the same issue, Any fixes for this issue