topic PBI Model Refreshes Fine in Desktop but Fails in Report Server in Report Server

PBI Model Refreshes Fine in Desktop but Fails in Report Server

Karthik_Ram — Thu, 29 Apr 2021 23:42:30 GMT

Hello,

We have a report which uses SQL Server and Sharepoint as Data source. The refresh runs fine in Desktop and Cloud but when I deploy it to Power BI Report Server we keep getting error during refresh.

[0] -1055784934: This feature requires installing a newer version of the .NET framework. To use it, you must install at least 'Microsoft .NET Framework 4.5': https://go.microsoft.com/fwlink/?LinkId=528259. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface

I RDP in to the report server and can see that .Net Framework version is 4.7.

Any help would be much appreciated

Re: PBI Model Refreshes Fine in Desktop but Fails in Report Server

Greg_Deckler — Fri, 30 Apr 2021 01:12:01 GMT

Karthik_Ram You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Re: PBI Model Refreshes Fine in Desktop but Fails in Report Server

Icey — Mon, 03 May 2021 10:09:58 GMT

Hi Karthik_Ram ,

Does this issue occur for all reports?

What's the version of your Report Server? Can downgrade or upgrade the version help?

Best Regards,

Icey

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

Re: PBI Model Refreshes Fine in Desktop but Fails in Report Server

Karthik_Ram — Mon, 03 May 2021 22:44:45 GMT

Issue is not actually with RS. Found that we were trying to do a HTML to text conversion in Power Query editor and it doesn't like it for some reason. Html.Table([Columnname],{{"PlainText",":root"}}). This transformation works well in desktop and cloud but fails in RS.

Re: PBI Model Refreshes Fine in Desktop but Fails in Report Server

Icey — Wed, 05 May 2021 08:12:50 GMT

Hi Karthik_Ram ,

Since it works well in Desktop and Cloud, it may be not supported in Report Server. But there is no official documents mentioned this.

It is suggested to create a support ticket to get further help if you are a pro user.

Best Regards,

Icey

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