Powerbi-docs: How to add service principal to workspace with the Power BI service?

Created on 28 Mar 2019  Â·  14Comments  Â·  Source: MicrosoftDocs/powerbi-docs

The page states "Add the service principal as an admin to the new workspace you created. You can manage this task through the APIs or with the Power BI service.". How to add the service principal as an admin to the workspace with the Power BI service (rather than API)? The access management pane only supports entering named users, not service principals.


Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

assigned-to-author needs-more-info pri1

Most helpful comment

It works in GUI, but only via the "Workspace access" interface not "Access" tab in Admin portal
Go to Power BI Admin portal and add admin account to Workspace with Admin access.
Go to Workspaces -> ... -> Workspace access -> type the application name (AppID will show up here) -> add as Admin.

This does NOT work via the Admin portal -> Workspaces -> Access tab!!!

All 14 comments

It's not super obvious but I was able to select my service principal by typing the first few letters of its name into the access management pane.

Hi, @algattik -- thanks for your question! And thanks, @tobyndockerill, for your comment! I'm referring this to the author to see if he needs to update the article.

Thanks a lot! I see indeed that you can add a service principal, and even a security group.
It would be great to:

  • Update the article to explain this
  • Update "Enter email addresses" in the UI
    image

@algattik You are correct, you can now add a Security Group (including a service principal) or just the service principal name (application ID) to a workspace.

There is an update coming to this article planned for 2 weeks that will include this info.

Thank you.

We will now proceed to close this thread. If there are further questions regarding this matter, please tag me in your reply. We will gladly continue the discussion, and we will reopen the issue.

It works in GUI, but only via the "Workspace access" interface not "Access" tab in Admin portal
Go to Power BI Admin portal and add admin account to Workspace with Admin access.
Go to Workspaces -> ... -> Workspace access -> type the application name (AppID will show up here) -> add as Admin.

This does NOT work via the Admin portal -> Workspaces -> Access tab!!!

I have tried adding a service principal name but it does not appear in the Workspace Access list when I type the name... The security group appears, but not the SP. What is wrong here?

Thank you

There is an update coming to this article planned for 2 weeks that will include this info.

Did it arrive? There's still no details except some clipped screenshot from unknown page.

I am stuck here...
Have my SP created will permissions to access the Power BI API...
Power BI have a security group setup to access the rest API and the service principal is assigned to it...
Workspace has the security group as ADMIN

Even with all of this I am getting "forbibben" when testing using POSTMAN. What is missing here?

Any update on this?

Even with all of this I am getting "forbibben" when testing using POSTMAN. What is missing here?

Did you use endpoints with group/workspace id? Most of the actions have equivalent ones with id.

Make sure postman is getting the token correctly. If you get the
authorization token using the oauth2 from Postman it does not work since
the client_credentials are not passed using the right parameter.

Em sex, 14 de jun de 2019 às 03:14, Oleksii Bespalov <
[email protected]> escreveu:

Even with all of this I am getting "forbibben" when testing using POSTMAN.
What is missing here?
Did you use endpoints with group/workspace id? Most of the actions have
equivalent ones with id.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/MicrosoftDocs/powerbi-docs/issues/931?email_source=notifications&email_token=ADZ5Q5RNP4DPLBTETMTA6J3P2LIF3A5CNFSM4HB5GKPKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODXVI7XA#issuecomment-501911516,
or mute the thread
https://github.com/notifications/unsubscribe-auth/ADZ5Q5SZBWBKUEGYZEYAZKLP2LIF3ANCNFSM4HB5GKPA
.

>

Melhores Cumprimentos,
Luis Simões

I feel like I'm missing something obvious, but can someone provide a step by step explanation with screenshots, URLs, or navigation paths on how to set up a service principal in Power BI so I can use it to query everything from the REST API using that service principal? I've followed a dozen different pages trying to connect all of the dots, but I can't get there.

I've enabled service principals and specified a group under the developer settings in Power BI. However, I can't seem to make that group an admin anywhere. I saw that I should be able to add a service principal to a workspace as an admin under the Power BI Admin Portal > Workspaces > Access, but I don't have a name/email address for my service principal (that I can find) and the application/object GUIDs fail with a message that it's an invalid email address. I also tried searching with my registered application's name and the group name with no change.

@markingmyname tagging you since you said to above

re-assign @KesemSharabi

Was this page helpful?
0 / 5 - 0 ratings

Related issues

karmamule picture karmamule  Â·  5Comments

yoshihirok picture yoshihirok  Â·  3Comments

ferdsjoseph picture ferdsjoseph  Â·  3Comments

tofu001 picture tofu001  Â·  6Comments

abhi-debuginside picture abhi-debuginside  Â·  3Comments