topic Re: How to migrate SSRS reports to Power BI Report Server? in Report Server

How to migrate SSRS reports to Power BI Report Server?

lorcz — Wed, 04 May 2022 16:13:06 GMT

I found this Microsoft documentation but I couldn't anywhere on the page what "-e" means. I looked at the ssrs_migration.rss file and there is no mention of what -e Mgtm2010 even means. Do I need to use -e in my environment? If so, instead of Mgmt2010, what should it be? Thanks!

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Wed, 04 May 2022 22:25:18 GMT

If you are looking for documentation of parameters for rs.exe, you can check this URL: https://docs.microsoft.com/en-us/sql/reporting-services/tools/rs-exe-utility-ssrs?view=sql-server-ver15

If you want to know more about "-e", that exists for backward compatibility and Yes you have to use as "-e Mgmt2010"

Other links of interest in migrating reports

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Thu, 05 May 2022 18:40:38 GMT

Thank you for the response. This is the error I'm getting now.

Could not connect to server: https://sourceServer.myComp.org/ReportServer/ReportService2010.asmx

This is the command I ran.

RS.exe -i C:\Scripts\ssrs_migration.rss -e Mgmt2010 -s https://sourcesServer.myComp.org/ReportServer/ -u DOMAIN\userName -p "password" -v ts="http://destinationServer.myComp.org/ReportServer/" -v tu="DOMAIN\userName" -v tp="password"

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Thu, 05 May 2022 18:51:44 GMT

Can you try browsing in a chrome or edge browser directly?

https://sourceServer.myComp.org/ReportServer/ReportService2010.asmx

Note: if you have an instance, you may need to use it.

Say, https://sourceServer.myComp.org/ReportServer_SSRSDev/ReportService2010.asmx

You will be seeing

<wsdl:definitions xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" targetNamespace="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">The Reporting Services Web Service enables you to manage a report server and its contents including server settings, security, reports, subscriptions, and data sources.</wsdl:documentation>
<wsdl:types>
<s:schema elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer">
<s:element name="CreateCatalogItem">
<s:complexType>

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Fri, 06 May 2022 13:27:07 GMT

Yes, I can access the source report server through the browser.

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Sat, 07 May 2022 00:06:20 GMT

Now we are getting into troubleshooting mode. Can be iterative till we know the issue for connecting. Since we dont have any info, I will ask you to do these.

1. with "-t" to get more details, -t is for tracing i.e., run the same command above with -t

"rs.exe ... ... ... -e Mgmt2010 -t"

See if the info provided, gives any info.

2. Let us do simple connect to retrieve server info, and also test the connection

2.1. Create a file "rs_GetReportServerConfigInfo.rss", you can call the file name of your like

Public Sub Main() DIM results as String TRY rs.Credentials = System.Net.CredentialCache.DefaultCredentials results = rs.GetReportServerConfigInfo("FALSE") Console.WriteLine(results) Catch e As IOException Console.WriteLine(e.Message) End Try End Sub

2.2. Command prompt (run as administrator)

(note: I used http, you can use https also if your SSL site is working fine)

rs.exe -i C:\Users\...\rs_GetReportServerConfigInfo.rss -s "http://.../Reportserver" -e Mgmt2010 -t

Substitute the .rss file location and URL for the reportserver and run the command. If it works well then you should be seeing info in the xml as below:

<ServerConfigInfo><Server><MachineName>...
The command completed successfully

If any errors, it will display here...

Optional, but worth checking the logs (both eventviewer and report logs)

Reference:

https://docs.microsoft.com/en-us/dotnet/api/reportservice2010.reportingservice2010.getreportserverconfiginfo?view=sqlserver-2016

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver15

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Mon, 09 May 2022 19:18:13 GMT

For troubleshooting 1:

RS.exe -i C:\Scripts\ssrs_migration.rss -e Mgmt2010 -t https://sourcesServer.myComp.org/ReportServer/ -u DOMAIN\userName -p "password" -v ts="http://destinationServer.myComp.org/ReportServer/" -v tu="DOMAIN\userName" -v tp="password"

This is the error that came back.

Unrecognized argument https://sourcesServer.myComp.org/ReportServer/

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Mon, 09 May 2022 20:43:48 GMT

Looks like you have a typo in your syntax -t does not have any argument, -s has the argument ... use the original command you had and Add -t to the end and try again

Did you try the trouble shoot 2?

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Tue, 10 May 2022 14:03:55 GMT

I put the -s back and I got the same error as when I performed troubleshoot step 2.

Here's the code I ran.

RS.exe -i C:\Scripts\rs_GetReportServerConfigInfo.rss -e Mgmt2010 -t -s https://sourcesServer.myComp.org/ReportServer/ -u DOMAIN\userName -p "password" -v ts="http://destinationServer.myComp.org/ReportServer/" -v tu="DOMAIN\userName" -v tp="password"

And here's the error:

System.Exception: Could not connect to server: https://sourcesServer.myComp.org/ReportServer/ReportService2010.asmx ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An attempt was made to access a socket in a way forbidden by its access permissions 192.168.1.148:443
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.IsSSLRequired()
at Microsoft.ReportingServices.ScriptHost.Management2010Endpoint.PingService(String url, String userName, String password, String domain, Int32 timeout)
at Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecurity()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecurity()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args, BaseCmdLine instance)

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Fri, 13 May 2022 13:48:31 GMT

Any suggestions? From within that server or outside, I'm able to access the remote server with my credentials.

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Fri, 13 May 2022 19:04:23 GMT

Let us check whether this is port issue or configuration issue.

1. Telnet for port 443, it should not give any error, but worth checking, as you are able to browse the url

An article, that talks about checking a port on a remote server ...

https://kb.synology.com/en-me/DSM/tutorial/Whether_TCP_port_is_open_or_closed#:~:text=your%20Linux%20computer.-,Enter%20%22telnet%20%2B%20IP%20address%20or%20hostname%20%2B%20port%20number%22,will%20say%20Connected%20to%2010.17.

2. Firewall access for port 443, any block. it should not but worth checking, as you are able to browse the url

3. Connect via Powershell and get reports list

$ReportServerUri = 'http://<your report server>/Reports/ReportService2010.asmx' $SourceFolderPath = '/' # Replace with the folder path you have access. without "/" at the end, Say /BI_Finance $items = $null $Proxy = $null $Proxy = New-WebServiceProxy -Uri $ReportServerUri -Namespace SSRS.ReportingService2010 -UseDefaultCredential $items = $Proxy.ListChildren($sourceFolderPath, $true) | Select-Object Type, Path, Name if ($items -eq $null) { Write-Host "No Items found!" } else { $items } # ------------------------------------ Write-Host "----------------------------------" Write-Host "ReportServerUri: " $ReportServerUri Write-Host "SourceFolderPath: " $SourceFolderPath Write-Host "----------------------------------" Write-Host "Proxy: " $Proxy Write-Host "----------------------------------" Write-Host "Items:" $items Write-Host "----------------------------------"

4. Now replace with https Report Server Uri in the above powershell code.

it will not work, indicates that Report Server need to be configured for web service access.

5. Fix the Report Server Configuration Manager

On the report server, after connecting to Report Server Configuration Manager, click "Web Service URL" and see whether https port is configured or any urls already configured.

Most likely http is only configured. You need to add https.

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Wed, 18 May 2022 16:55:13 GMT

1. telnet to port 443 works fine

2. there is no firewall blocking port 443

3. I got the following error.

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Wed, 18 May 2022 17:37:23 GMT

Did the powershell script work with http (and I see your image has https)?

If yes, then I posted the fix above

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Wed, 18 May 2022 18:11:56 GMT

I got similar error.

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Wed, 18 May 2022 18:21:27 GMT

Please do

On the report server, Open, Report Server Configuration Manager, after connecting to Report Server Configuration Manager, click "Web Service URL"

Check if you see any details on the URLs for web service ...

What is expected? atleast one server with the same name you used above. May be http, or https.

If it is not configured properly in the first time, you may see http://localhost/ or 127.0.0.1

Re: How to migrate SSRS reports to Power BI Report Server?

lorcz — Wed, 18 May 2022 18:36:04 GMT

This is the source SSRS.

And this the destination or target Power BI Report Server.

I'm running the powershell script from within the target PBRS.

Re: How to migrate SSRS reports to Power BI Report Server?

sevenhills — Wed, 18 May 2022 18:40:56 GMT

Using the source server url, Please run the Powershell script on the source server and see it works. It should work.

It may sound repeatitive task, but want to check the source server, powershell works fine.

When you repeat the same from target server, and using the source server URL, it will fail, based on your previous posts. If this is true, please let me know. This indicates that target server cannot access the source server.