Adding external users to your Power BI workspace — Update

Erik Hamoen
2 min readSep 7, 2022

--

Photo by ANIRUDH on Unsplash

In one of my first blogs, I describe a method of how to add external people to your Power BI workspace. You can read that one here. Now there is a problem with that. Before, you got an e-mail with a link to that specific workspace and could access the content. When you click on the home button, there was no way to come back, unless you had the link to that specific workspace.

Recently, I needed access to an external workspace of a client, but I didn’t receive any e-mail. By copying the link to the workspace, I got this message:

Error message, no access to the report

So what to do now? I was added to the AAD B2B, and that account was also added to the workspace (as described in my first post). The problem is that Power BI needs extra information about the tenant. By adding the following parameter to the URL you will be able to access it:

?ctid=[yourtenantIDhere]

So the complete URL would be: https://app.powerbi.com/groups/GroupId/list?ctid=yourtenantIDhere

Now, where to find your tenant ID? In the top menu select the question mark and go to About Power BI:

About Power BI Settings in the menu

Then this screen will pop up with the following information:

All your Power BI information

Now the amazing part about this: If you just copy this link and give it to the external users, they will see all the workspaces they have access to! They can just sign in to your tenant!

Adam Saxton from Guy in a Cube made a great video on how to use Power BI Desktop to deploy your reports to the Power BI service of this external party. If you haven’t watched it, go check it out!

--

--