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

How to register SSRS 2016 report server with Power Bi

I'm trying to intergrate SSRS 2016 report server with Power BI such that i be able to pin SSRS reort items to a Power Bi dashboard as explained here https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/power-bi-report-server-integ...

 

In SQL Server 2016 reporting services configuration manager, i can to the "Power BI Intergration" screen and click the "Register with power BI" button. This takes my to the Microsoft login page where i enter my organisation email. After detecting my domain from the email, am taken to my organisation login page and then the registration is initiated but it fails with the following error

failed to register power BI client application. You may not have permissions to register an app with azure active directory

Has any one ever encountered this error

2 REPLIES 2
v-huizhn-msft Super Contributor
Super Contributor

Re: How to register SSRS 2016 report server with Power Bi

Hi @kadingo,

 

For Requirements of Power BI Report Server Integration, your organization must use Azure Active Directory, which provides directory and identity management for Azure services and web applications said in the article. The error messages means you don'y have permission  to register an app with azure active directory, please connect your company IT admin and double check it.

Best Regards,
Angelia

 

kadingo Frequent Visitor
Frequent Visitor

Re: How to register SSRS 2016 report server with Power Bi

Hi @v-huizhn-msft ,

 

Thank you very much the info above and as per the requirements, i can confirm the below:

 

1. My organization is already using Azure Active Directory because from the results panel in "Reporting Services Configuration Manager", Singinging in to the Azure Active Directory shows success.

 

The problem is, i work in a very big organisation with dozens of AD domains under a parent domain managed at head quators. So i believe the Azure AD intergration is being managed at head quators because the admins of the child domain i belong to seem not to be having an idea of how Azure AD intergration came about. 

 

So if i have to talk to the admins at head quators, i will need to be specific on what exact permissions i want.

So do you know of any microsoft offical documetation that mentions exactly what permissions i need to be able to  register an app with azure active directory?

 

Do you know of a ste-by-step article on how to grant permissions in azure active directory?

 

On further research, i have come across this link https://docs.microsoft.com/en-us/azure/active-directory/active-directory-apps-permissions-consent  and the is a screen, with the "User Settings" link link highlighted which gives you an option to enable the "Users can register applications" setting. In my case all the optiions on that "User Settings" screen are disabled / readonly so i cannot click to enable them. Can i take it this is what the admins have to do to over come the error am getting?