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

[dustinvu_0320]

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!

[nitishsh91 · Accepted solution]

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.