How to Switch Tenant in Power BI Desktop

Working on projects for different clients or managing data across various company departments means you're likely juggling multiple Power BI tenants. Knowing how to switch between them smoothly is crucial for keeping your work organized and secure. This article walks you through the exact steps for changing tenants in both the Power BI service online and in Power BI Desktop.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Would You Need to Switch Tenants in Power BI?

First, let's clarify what a "tenant" is. In the Microsoft ecosystem, a tenant is a dedicated instance of Microsoft Entra ID (formerly Azure Active Directory) that your organization receives when it signs up for a cloud service like Microsoft 365 or Azure. For Power BI, your tenant is your organization's private and secure space. All your company’s datasets, reports, dashboards, and users live inside this container.

There are several common reasons why you might need to access and work in more than one Power BI tenant:

• Consulting and Freelancing: If you're a consultant or freelancer, you almost certainly work with multiple clients. Each client will have their own Power BI tenant, and they'll grant you guest access so you can build reports using their data without it ever leaving their secure environment.
• Large, Siloed Organizations: Big corporations often have separate business units, subsidiaries, or regional divisions that operate under different tenants for administrative or legal reasons. An analyst at the parent company might need to switch between the North American tenant and the European tenant to compare performance.
• Development and Testing: Many companies maintain separate tenants for development, testing, and production environments. A Power BI developer needs to switch to the development tenant to build and test new reports before deploying them to the live production environment that business users access.
• External Collaboration: You might be working on a joint project with a partner company. To collaborate on a shared dashboard, you would be invited into their Power BI tenant as a guest user.

The Prerequisite: Getting Guest Access

Before you can switch to another tenant, you must be invited. You can't just decide to hop into another company's Power BI environment. An administrator from the target tenant needs to add your primary email address as a guest user in their Microsoft Entra ID. Once they do, you'll typically receive an email invitation that you must accept.

After you're successfully added as a guest, your account is associated with both your home tenant and the guest tenant, setting the stage for you to switch between them.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Switching Tenants in the Power BI Service (Online)

The most straightforward way to change tenants is within your web browser in the Power BI service. This is ideal for when you're viewing existing reports, managing content, or using web-based authoring features.

1. Log in to the Power BI Service by navigating to app.powerbi.com.
2. In the top right corner of the screen, you will see your profile icon. Click on it to open a dropdown menu.
3. In this menu, click on the "Switch organization" option. In some versions, it might appear next to your accounts.
4. A new pane will appear on the right side of the screen, listing all the organizations (tenants) you have access to. Your current tenant will have a checkmark next to it.
5. Simply click on the name of the tenant you want to switch to.

The page will completely refresh, and the Power BI service interface will now show you the data, workspaces, and reports from the new tenant. You can confirm you're in the right place by checking your profile icon again, the organization name underneath your email address will have changed.

Method 2: Signing Out and Signing Back In (Power BI Desktop)

Unlike the web service, Power BI Desktop does not have a direct "switch tenant" button. The identity of the active tenant is tied to the account you are currently signed in with. Therefore, the official way to switch tenants is to sign out and then sign back in.

Step 1: Sign Out of Your Current Account

• Open Power BI Desktop.
• Look at the top right corner of the application window. You will see your name and profile picture, indicating you are signed in.
• Click on your name to reveal a dropdown menu.
• Select "Sign out."

After signing out, you will notice that the space where your name was now says "Sign in." The application is now disconnected from any particular tenant.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Sign In with the Same Account

• Click the "Sign in" button in the top right corner.
• A Microsoft sign-in window will appear. Enter your primary email address (the same one you just signed out with). This is the account that has been granted guest access to the other tenant.
• After entering your email and password, if your account has access to multiple directories (tenants), Microsoft may prompt you to select the organization you want to work with. You'll see a list of available tenants.
• Select the desired tenant from the list and complete the sign-in process.

Power BI Desktop will now be operating within the context of the new tenant you selected. When you publish a report, it will be published to a workspace within that tenant. When you try to access Power BI datasets, you will see the datasets available in that tenant.

Method 3: Clearing Permissions for Data Sources

Sometimes, Power BI Desktop caches credentials and permissions for data sources, which can cause confusion when switching tenants. If you've switched your account but are still having trouble connecting to the correct data source, you may need to clear your stored permissions.

1. In Power BI Desktop, go to File > Options and settings > Data source settings.
2. This will open the Data source settings dialog, showing you all the data connections you've made.
3. You have two main options here:
4. After clearing the permissions, click "Close."
5. Now, refresh your data or try connecting again. Power BI will prompt you to sign in for that data source, ensuring you use credentials that are valid for the currently active tenant.

Method 4: Using Different Browser Profiles (A Huge Time-Saver)

For consultants or analysts who work with multiple clients daily, the process of signing out and back in constantly becomes a major productivity drag. A much more efficient approach is to use separate browser profiles in Microsoft Edge or Google Chrome. This technique isn't an official PowerShell one, but it's wildly popular with people in the field.

Each browser supports an isolated Profile. Inside each Profile, we can use our Web Browsers as if each one was a totally separate person from the other, it saves your logged-in sessions. By setting up various browser profiles for each tenant, this gives us the ability to flip rapidly between all Tenants with one simple window click, avoiding a login/logout cycle.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Steps for Setting Up a New Profile (in Chrome or Edge)

1. Open your browser (Edge or Chrome).
2. Click on your profile picture in the top-right corner of the browser window.
3. In the menu that appears, click the "Add" button to create a new profile.
4. Give the new profile a specific name (e.g., "Client X Tenant" or "Project ABC"). It's helpful to pick a distinct color scheme or icon as well.
5. A brand new browser window will open under this new profile. It's totally separate from your default window.
6. In this new profile window, go to app.powerbi.com and sign in with your credentials, making sure to select the correct client tenant when prompted.

You can repeat this process for any other client who grants you guest access to their Tenant. Once set up, you have an entire individual browser window per tenant. To switch back and forth between tenants, simply click its specified browser profile's icon on the Taskbar, which switches instantly.

A Final Tip: What to Do If You're Not Prompted to Choose a Tenant

Occasionally, during the sign-in process, Power BI Desktop might automatically connect you to your 'home' tenant without asking you to choose. This can be frustrating. So as a last resort, in such cases, attempt these workarounds:

• Use a clean sign-in: During the login prompt, instead of just entering your email, try clicking on "Sign-in options" if available, or choose to sign in as "Use another account" even if you're using the same email. This can sometimes trigger the directory selection dialogue.
• Tenant-Specific Login URL: In your browser, instead of going to app.powerbi.com, you can use what we call "tenant-specific URLs." By doing that, log into your Tenant instance by using https://app.powerbi.com?ctid=YOUR_TENANT_ID. This forces your authentication into Power BI right to this Tenant's directory only.

An Admin for a tenant can provide theirs. If you cannot access specific details, go to Microsoft's Entra ID portal to check on any Tenant details in question.

Final Thoughts

Learning your way across tenants within Power BI is important for roles that deal with multiple clients or separate corporate work areas. Using simple browser tenancy switches, desktop log/sign out, and advanced techniques like browser profiles, ensure you're always in the correct place, with rights and permissions in place.

Manual analysis or reporting across different data sets can quickly consume time, even when switching Tenant becomes second nature. We created Graphed to help solve these challenges. Using Graphed helps hook multiple source data like Google Analytics for clients, making managing data easier without constant logging in and out. With it, you will get a clear, real-time data view for all that needs managing.