Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I recently upgraded Report Server from SQL Server 13.0.1601.5 to PowerBi 15.0.1102.235.
In SQL Server, the service published to /ReportServer/ReportExecution2005.asmx works, but when I try to call it on the PowerBi instance, the following error is returned. Is the execution service no longer functional although available? Is there any other service that can for example run a report programmatically to get a pdf file?
Thank you in advance.
<s:Fault> <faultcode>s:Client</faultcode> <faultstring>This operation is not supported on a report server that runs in native mode. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: This operation is not supported on a report server that runs in native mode.</faultstring> <faultactor>http://<server>/ReportServer/ReportExecution2005.asmx</faultactor> <detail> <ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsOperationNotSupportedNativeMode</ErrorCode> <HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus> <Message xmlns="http://www.microsoft.com/sql/reportingservices">This operation is not supported on a report server that runs in native mode.</Message> <HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">https://go.microsoft.com/fwlink/?LinkId=20476&Evtsrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&EvtID=rsOperationNotSupportedNativeMode&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=15.0.1102.235</HelpLink> <ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft Power BI Report Server</ProductName> <ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">15.0.1102.235</ProductVersion> <ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId> <OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem> <CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId> <MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"> <Source>ReportingServicesLibrary</Source> <Message msrs:ErrorCode="rsOperationNotSupportedNativeMode" msrs:HelpLink="https://go.microsoft.com/fwlink/?LinkId=20476&Evtsrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&EvtID=rsOperationNotSupportedNativeMode&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=15.0.1102.235" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">This operation is not supported on a report server that runs in native mode.</Message> </MoreInformation> <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"/> </detail> </s:Fault>
I thought this should still work. Are you running this against an RDL based report?
The other option for an rdl report would be to use URL parameters https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-serv...
You can then do a simple get request against a url with the "rs:Format=PDF" parameter to get a pdf version of a report
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |