Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
When I log into Power BI desktop it automatically defaults to the tenant associated with my account. My account is a guest account on other tenants using guest B2B access but I don't know how to log into those tenants with Power BI desktop. Is it possible?
There is a way to do this (which I am currently using). Details in this video (Guy in a Cube, who else? 🙂 ).
https://www.youtube.com/watch?v=x1xMxRXQ2So
Thanks for sharing this video. This works great!
There are a few ideas posted to change this so that users do not have to know the URL to switch a tenant. Please consider upvoting this idea:
Hi All,
These comments are all really useful, this is something that I'm looking into currently. I was wondering if there was any recent updates to the issue around logging into another tenant from Power BI desktop, or is this still not possible?
Many thanks
Vicky
Well PowerBI Desktop doesn't support at this time B2B (account switcher).
Same goes for the web app (as of Martch 2021). If you use B2B, no tenant switch. Yet a tips for future reference: a very convinient way is to actually use MS Teams Power BI App. The new Teams Account switcher will allow you to switch tenant and the integrated Teams authentication will works its magic 😉
This is the first result on a web search, so I wanted to add some more useful info I found.
You can access other organisations Power BI tenants by using the Azure AD B2B Guest functionality. You are limited to doing everything in the Online service. This means you can't use Power BI Desktop but can connect data and build reports directly on the website.
The key to accessing (or switching tenants) is to find out what the tenant URL is. You can't easily guess it, so ask someone in the home tenant to find it out for you (very easy to do). Instructions and more info on the limitations (pasted below) are here in this Microsoft blog post from March 2019: https://powerbi.microsoft.com/en-us/blog/azure-ad-b2b-guest-users-can-now-edit-and-manage-content-in...
To upload or update Power BI Desktop authored reports (PBIX files), guest users must use the Get Data experience in the Power BI Service. They can select Files and then upload the file to the service.
While most experiences are available to these Guest users, there are some that are not supported, specifically:
More detailed info is on this Docs page: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-azure-ad-b2b
Hi @TimOConnell
As tested,
if i use a power bi pro trail(free for 30 days) acount, then this account is added as a tenant's guest user,
i can sign in Power bi desktop with my pro trail account and password.
If the account is created by the tenant admin and it is a guset user in his tenant, you could ask the tenant what the password the account has.
then use the account and password, you could log in power bi desktop.
To see the reports/dashboards which the users in that tenant share with you, please sign in power bi service->shared.
if the power bi desktop log in with a account by default once you open the app, you could click the name then switch account.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie,
Thank you for the reply but I haven't been able to resolve the problem.
Here is further explanation:
Tenant 1
Domain: northwind.com
User email = tim@northwind.com
User type = normal AAD account
Tenant 2
Domain: cars.com
User email: tim@northwind.com
User type = Guest AAD account
When I log into Power BI desktop with the account tim@northwind.com I have no way of logging in to the Power BI tenant assocaited with the domain cars.com
Regards,
Tim
Hi @TimOConnell
As tested, it seems logging in Power BI Desktop as another tenant is impossible.
If you want to access the workspaces and content for that tenant, even contribute content to workspaces,
once you have permission as below, you could log in Power BI Desktop with your account, then do the normal steps as default.
When using the Allow external guest users to edit and manage content in the organization feature, the specified guest users get access to your organization's Power BI. They can see any content to which they have permission. They can access Home, browse workspaces, install apps, see where they are on the access list, and contribute content to workspaces. They can create or be an Admin of workspaces that use the new workspace experience.
Some limitations apply. The Considerations and Limitations section list those restrictions.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, Maggie
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |