PBI Model Refreshes Fine in Desktop but Fails in Report Server

[Karthik_Ram]

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 

[Icey]

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.

[Karthik_Ram]

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.

[Icey · Accepted solution]

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.

[Greg_Deckler]

@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".