cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
soumyas2505
Frequent Visitor

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

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

<script type="text/javascript">
// Fix for IE10 not supporting location.origin
// IE 10
// 'Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.2; Trident/6.0)';
if (navigator.userAgent.indexOf('MSIE ') > 0 && !window.location.origin) {
window.location.origin = window.location.protocol + '//' + window.location.hostname + (window.location.port ? ':' + window.location.port : '');
}
</script>

1 ACCEPTED SOLUTION
RachelGomez1619
Helper I
Helper I

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

2 REPLIES 2
RachelGomez1619
Helper I
Helper I

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
Community Support
Community Support

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

vhenrykmstf_0-1658134191565.png

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.

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.