Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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
Solution Supplier
Solution Supplier

Hi @Anonymous 

 

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
Solution Supplier
Solution Supplier

Hi @Anonymous 

 

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.