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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BillatREM
Advocate I
Advocate I

Gateway Error on Newly published Paginated Reports

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?

 

1 ACCEPTED SOLUTION
v-jialongy-msft
Community Support
Community Support

Hi @all

 

This issue has been confirmed as a known issue.You can solve the problem through the following workaround.

 

1) Delete the report and upload again (do not rewrite/reupload on the existing one),

or

2) Take Over (ownership transfer)

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

51 REPLIES 51
danielgoodwill
Frequent Visitor

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
New Member

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

Charl3
New Member

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.

updating the gateway to the recent version fixed our issues

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

AnAnTaReZa
New Member

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

bw05
New Member

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

Conlyn
Frequent Visitor

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

How do we change the old sqlclient

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors