Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when you’re a consultant and your client can’t create a new user in their own tenant, so they add the account of your own company as a guest instead. If you’re not a consultant, it can also happen after a merger or acquisition and you’re suddenly stuck with multiple tenants.
Having multiple tenants usually isn’t an issue. In the Azure Portal, it’s easy to switch between multiple organizations (or directories as they’re sometimes called):
You get a list of all organizations you’re account has been added into, and you switch to the one you need.
In Azure Data Factory, you can do the same thing.
However, such an easy switch is not available in Power BI, unfortunately. When you go to https://app.powerbi.com and you log into your account, you will always go to the Power BI service of your own home tenant. So, how do you go to another tenant with your own account? You use this straight-forward, user-friendly (ahem) trick: you add the tenant-ID in the URL. Because every regular user knows their tenant ID, right? Anyway, if you do know it, you just add it to the URL like this:
https://app.powerbi.com/home?ctid=yourtenantID&experience=power-bi
You can find your tenant ID in the Azure Portal on the overview page of Entra ID:
But what about Power BI Desktop? There’s no URL where you can put a tenant ID, and there certainly isn’t an easy button to switch tenant. By default, Power BI Desktop will also connect to your home tenant (especially if you’ve logged in before). To connect to another tenant, you need to follow these steps:
If you think this is quite cumbersome and not that user-friendly, please upvote the following idea: Switch accounts and tenants in the portal in the same way as Azure.
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…
I wrote a piece of SQL that had some new T-SQL syntax in it: IS…
I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in Fabric,…
I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL…
I came across a bit of a weird error when I was trying to connect…