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?

[miguelp06]

Hi everyone,
my reports were updating automatically through the gateway. They recently stopped updating. the error is the following:

Anyone can help me?

Thanks

[v-jialongy-msft · Accepted solution]

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.

[pavankumarb]

Yes, it is working after delete and publishing rdl file.

So going forward everytime do we need to delete and re-publish rdl for future changes in the report?

Thank you 

B Pavan Kumar

[BillatREM]

Yes, the issue seems to be fixed.  I deleted the report that was not working from the server and republished and it work correctly now.

[mhammersley]

If you are using System.Data.SqlClient on .NET Framework you must install the January 2024 update(s) for .NET Framework. The problem stems from a Windows update: January 9, 2024-KB5034274 Cumulative Update for .NET Framework 3.5, 4.8 and 4.8.1 for Windows 10 Version 21H2.  The server that is hosting your PBI gateway must be updated as well.

See: https://msrc.microsoft.com/update-guide/vulnerability/CVE-2024-0056

Restart all instances or the problem may persist.

[JohnSRC]

It appears that our reports are functioning as expected now. For verification, we have republished a report under a different name, or alternatively, deleted an old report and republished it

[Jacob_dong]

Hi Guys,

I think they fixed the issue. 

I deleted the report in the workspace, and published again. The report is working now. 

Thanks Microsoft team !

[ppetersen]

I was getting the same error, glad I found this thread. Based on what a few other people said on this thread, I tried saving the .rdl file as a new file/name, then published to Power BI as a new name. This worked. When I tried to just overwrite my old Power BI report, it would not work. So one key may be to go to new file name in both the .rdl and the published report.

[r_i_c_k]

Getting the same error

[r_i_c_k]

I have found it seems to be more tied to the gateway connection. I update the report that uses an older gateway and the report runs. Same server, different databases and different data. We created this new connection yesterday to create reports for the other database on the same server. The connections again point to the same sql server and use the same gateway which is running on a single server internally.

[rk239911]

We are experiencing this issue as well. This error is affecting business critical deliverables - hoping this is high priority in the troubleshooting for the Microsoft prod team 

[rk239911]

Reports are working as of 10AM EST for us.

Thanks!!

[amorrison2152]

We are experiencing the same issue.  We've even tried copying & pasting an existing report within the same workspace.  The original report works, but the copied & pasted report returns with this error. 

As with most here, this is causing issues with workflows and our ability to provide data support to end users.  We need this resolved soon.

[Ewan_Keys]

I get a very similar error message, hopefully Microsoft will fix this soon as it does not inspire end user confidence.

[aggiegirltx]

I just tried deleting the rdl from the workspace and republishing. Still getting the same error.  Hoping that we will see a resolution soon.  We are due to publish some urgent reports. 

[suju]

Hi Guys,

I had similar issue till yesterday and its working fine for me now. Please try publishing the report once againg after deleting the older version in the workspace.

[DavidAllan]

Same issue here, was very surprised to have hit a new and active problem. I should be a lottery ticket 🙂

[jrubino77]

Yes we all should be lottery ticket winners.

So much for Microsofts QA process.

[Anonymous]

I submitted a ticket to Microsoft yesterday and had a call with support this morning. They said this is a known issue and the product team was working on a solution. Hopefully this is resolved soon. 

[Conlyn]

The latest publishes I have done this morning look to be working now.  If it isn't working for everyone, MS might be rolling out the fix by region.