Solved: Re: Migration of SSRS reports to Power BI Report S...

soumyas2505 · ‎07-14-2022

Hi all,

I am trying to use the below command to migrate SSRS reports to Power BI Report server, below is the command i am using to migrate but unfortunately i am getting the below error

command that i am using is as below

rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://SSRSURL -u ****** -p ******* -v f="/Folder name" -v ts="PowerBIREportmanagerURL" -v tu="*******" -v tp="*********" -v tf="/foldername" -v security="True"

Error message is as below

Error message:

Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE html><html><head>
<meta charset="utf-8">
<meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
<meta content="width=device-width,initial-scale=1,maximum-scale=2,user-scalable=yes" name="viewport">
<title>Report Server Web Portal</title>
<base href="/reports/" ><script>window['___portalRelativeUrl'] = document.querySelector('base').href;</script>
<meta content="width=device-width, initial-scale=1" name="viewport">

v-henryk-mstf · ‎07-18-2022

Hi @soumyas2505 ,

If it is a website issue, you can create a new website in IIS and then use that website using SSRS Configuration Manager. The URL used for the report model will then contain the port number of the other site.
Another method to try is to remove the ISAPI in IIS for the default site from the SSRS virtual directory. Either way, you will need to use the Forms Authentication configuration.

Also for this type of problem, you can refer to a similar solution

Related Migrate SQL Server Reporting Services reports to Power BI document.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

View solution in original post

RachelGomez1619 · ‎07-18-2022

Anyone with permission to access to the SSRS instance and the Power BI workspace can manually migrate reports to Power BI. Here are the steps to follow:

-Open the SSRS portal that contains the reports you want to migrate.
-Download each report definition, saving the .rdl files locally.
-Open the latest version of Power BI Report Builder, and connect to the Power BI service using your Azure AD credentials.
-Open each report in Power BI Report Builder, and then:
-Verify all data sources and datasets are embedded in the report definition, and that they're supported data sources.
-Preview the report to ensure it renders correctly.
-Select Publish, then select Power BI service.
-Select the workspace where you want to save the report.
-Verify that the report saves. If certain features in your report design aren't yet supported, the save action will fail. -You'll be notified of the reasons. You'll then need to revise your report design, and try saving again.

This may help you,

Rachel Gomez

View solution in original post

RachelGomez1619 · ‎07-18-2022

Anyone with permission to access to the SSRS instance and the Power BI workspace can manually migrate reports to Power BI. Here are the steps to follow:

-Open the SSRS portal that contains the reports you want to migrate.
-Download each report definition, saving the .rdl files locally.
-Open the latest version of Power BI Report Builder, and connect to the Power BI service using your Azure AD credentials.
-Open each report in Power BI Report Builder, and then:
-Verify all data sources and datasets are embedded in the report definition, and that they're supported data sources.
-Preview the report to ensure it renders correctly.
-Select Publish, then select Power BI service.
-Select the workspace where you want to save the report.
-Verify that the report saves. If certain features in your report design aren't yet supported, the save action will fail. -You'll be notified of the reasons. You'll then need to revise your report design, and try saving again.

This may help you,

Rachel Gomez

v-henryk-mstf · ‎07-18-2022

Hi @soumyas2505 ,

If it is a website issue, you can create a new website in IIS and then use that website using SSRS Configuration Manager. The URL used for the report model will then contain the port number of the other site.
Another method to try is to remove the ISAPI in IIS for the default site from the SSRS virtual directory. Either way, you will need to use the Forms Authentication configuration.

Also for this type of problem, you can refer to a similar solution

Related Migrate SQL Server Reporting Services reports to Power BI document.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

Migration of SSRS reports to Power BI Report Server issues with SSRS_migration.rss

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024