cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dustinvu_0320
New Member

Need help on SSRS Migration to Power BI using Power BI Embedded

I'm trying to migrate .rdl file from SSRS to Power BI. I already set up Power BI Embedded for Organization and able to register the API on Azure AD.

 

When I tried to use Microsoft RDL Migration Tool to do automated migration, I got this error after login: 

Sorry, but we’re having trouble signing you in.

AADSTS900971: No reply address provided.

 

What redirect URL needed for this situation? Also do we need any APIs permissions as well?

 

Has anyone had experience using Power BI Embedded for Organization to migrate SSRS to Power BI? Please help me on this!

1 ACCEPTED SOLUTION
nitishsh91
Super User
Super User

Hi @dustinvu_0320 

 

The error message "AADSTS900971: No reply address provided" typically indicates that the redirect URL used in the authentication process is not valid or not registered in Azure Active Directory. To resolve this issue, you will need to register a valid redirect URL in your Azure AD application.

In addition to the redirect URL, you will also need to ensure that the necessary API permissions have been granted to the Azure AD application. Specifically, you will need to grant the "Power BI Service" and "Azure Active Directory" permissions to your application.

Regarding migrating SSRS to Power BI, The Microsoft RDL Migration Tool is intended to help migrating RDL reports to Power BI. However, it is not a guaranteed solution, it may not work for all reports and you may need to do some manual adjustments to your report after migration.

Another way to migrate SSRS to Power BI is to use Power BI Report Server (on-premises) and then move the report to Power BI service.

You might also want to check out the Power BI Report Server Migration Tool, which is a Microsoft tool that can help you migrate your SSRS reports to Power BI Report Server.

Please note, that migrating SSRS to Power BI is not a straightforward process, it might take some effort to get it working properly.

View solution in original post

1 REPLY 1
nitishsh91
Super User
Super User

Hi @dustinvu_0320 

 

The error message "AADSTS900971: No reply address provided" typically indicates that the redirect URL used in the authentication process is not valid or not registered in Azure Active Directory. To resolve this issue, you will need to register a valid redirect URL in your Azure AD application.

In addition to the redirect URL, you will also need to ensure that the necessary API permissions have been granted to the Azure AD application. Specifically, you will need to grant the "Power BI Service" and "Azure Active Directory" permissions to your application.

Regarding migrating SSRS to Power BI, The Microsoft RDL Migration Tool is intended to help migrating RDL reports to Power BI. However, it is not a guaranteed solution, it may not work for all reports and you may need to do some manual adjustments to your report after migration.

Another way to migrate SSRS to Power BI is to use Power BI Report Server (on-premises) and then move the report to Power BI service.

You might also want to check out the Power BI Report Server Migration Tool, which is a Microsoft tool that can help you migrate your SSRS reports to Power BI Report Server.

Please note, that migrating SSRS to Power BI is not a straightforward process, it might take some effort to get it working properly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.