How to Change Owner of Power BI Report

Switching the owner of a Power BI report seems like it should be an easy, one-click task, but the process is a bit more involved. Because a report is connected to a dataset, credentials, and a specific workspace, transferring ownership requires updating a few different settings. This guide will walk you through the correct ways to change a report owner depending on your situation, from simple handoffs to dealing with a previous owner who has already left the company.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Understanding "Ownership" in Power BI

Before diving into the steps, it’s important to understand what "ownership" means in Power BI. It’s not just about who has the original .PBIX file on their computer. Ownership is a combination of three key roles:

• Report Creator: The person who originally designed and published the report.
• Dataset Owner: The person whose credentials are used to refresh the data from its source (like a SQL database, SharePoint list, etc.). This is the most critical component. If this person leaves, the data refresh will fail.
• Workspace Admin: A user who has administrative rights over the workspace where the report is published. Admins can manage all content and permissions within that space.

The "owner" is often the person who is both the creator and the dataset owner. When they leave or change roles, you need a plan to transfer these responsibilities to someone else to keep the report running smoothly.

My Workspace vs. App Workspaces

The method you use also heavily depends on where the report is located.

• My Workspace: This is a user's private, personal sandbox. Reports published here are owned by that individual and aren't designed for team collaboration. Transferring ownership from here is cumbersome.
• App Workspaces: These are collaborative spaces where teams can work on dashboards, reports, and datasets together. This is the best place for any report that needs to be shared or maintained by more than one person. Ownership is more flexible here because multiple people can have administrative access.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Why You Might Need to Change Ownership

There are a few common scenarios that require an ownership change:

• An employee leaves the company: This is the most critical reason. If their account is deactivated, any reports they own — especially the datasets — will stop refreshing.
• A team re-organization: Responsibilities shift, and a different team or individual may become the new point person for a set of reports.
• Project handoffs: When a project is completed, ownership of the related reporting may transfer from the project team to an operational team.
• Standardizing with a Service Account: Many organizations prefer to run their scheduled data refreshes using a dedicated service account instead of an individual's account to avoid disruptions.

How to Change Report Ownership: Step-by-Step Methods

Let's walk through the right way to transfer ownership based on different scenarios. The best and most common method involves using a shared App Workspace.

Method 1: Transferring Ownership within an App Workspace (The Best Way)

If the report is already in an App Workspace, you have the most flexibility. The goal here is usually to change the dataset owner so the scheduled refresh continues working.

Scenario A: The Original Owner is Still Available

The easiest handoff happens when you can coordinate with the current owner.

Step 1: Grant Admin Access to the New Owner

The current Workspace Admin needs to give the new owner ‘Admin’ or ‘Member’ permissions for the workspace. Members can publish and manage content, but only Admins can manage workspace settings and permissions.

1. In the Power BI Service, navigate to the correct App Workspace.
2. Click on Access at the top right.
3. Enter the new owner’s email address and assign them the Admin role. Click Add.

Step 2: Take Over the Dataset

Once the new owner has Admin access, they can take over the underlying dataset.

1. In the workspace, go to the Datasets + dataflows tab.
2. Find the dataset associated with the report. Click the three dots (...) and select Settings.
3. Expand the Data source credentials section. You’ll likely see a warning that the credentials belong to the original owner.
4. Click Edit credentials. Sign in using your own (or a service account’s) credentials for the data source.
5. After signing in, you may see a "Take over" button. Click it.

Once you’ve taken over, all scheduled refreshes will now run using the new credentials. At this point, the operational "ownership" of the report has been successfully transferred.

Scenario B: The Original Owner Has Already Left the Company

If the original owner is gone and their account is deactivated, a Power BI Service Administrator (this role is often held by a Global Admin in Office 365) needs to step in.

1. The Power BI Admin needs to go to the Admin portal (the Gear icon > Admin portal).
2. From the Admin portal, navigate to Workspaces.
3. Find the workspace containing the report. The admin can add themselves (or the new owner) as a Workspace Admin.
4. Once the new Admin has access, they can follow the same steps outlined in "Step 2: Take Over the Dataset" above to update the data source credentials and get the automated refresh working again.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Moving a Report from "My Workspace" to an App Workspace

What if the critical report was published in someone's personal "My Workspace"? This is not ideal, but it’s a fixable problem.

Scenario A: The Owner is Still Available

The original owner simply needs to re-publish the report to the correct shared workspace.

1. The owner opens the .PBIX file in Power BI Desktop.
2. From the Home tab, click Publish.
3. In the destination dialog, they select the shared App Workspace instead of "My Workspace."
4. Once published, a Workspace Admin can configure the dataset credentials and scheduled refresh in the shared workspace settings, taking ownership in the process.

Important Tip: After moving the report, be sure to delete the old version from the original owner’s "My Workspace" to avoid confusion and duplication.

Scenario B: The Owner Has Left the Company

If a user leaves and the report is locked in their "My Workspace," a Power BI Admin must intervene.

1. The Admin goes to the Admin portal > Workspaces.
2. They should see a list of all workspaces, including personal ones. They can search for the former employee's "My Workspace."
3. From here, the Admin can grant themselves (or the intended new owner) access to that personal workspace.
4. Once access is granted, the new person can navigate to the now-accessible "My Workspace," find the report, and download the .PBIX file (Go to File > Download .PBIX file).
5. With the file now saved locally, they can open it in Power BI Desktop and publish it to the proper shared App Workspace.
6. Finally, they can configure the dataset credentials and scheduled refresh in the new workspace.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for Managing Report Ownership

Dealing with ownership changes after the fact can be stressful. Adopting these best practices will save you a lot of future headaches.

• Avoid "My Workspace" for business reports. It should only be used for personal testing and development. All collaborative or business-critical reports should live in a shared App Workspace from day one.
• Use service accounts for data refresh. Whenever possible, set up data gateway credentials and dataset refreshes using a dedicated service account that isn't tied to a specific employee. This is the single most effective way to prevent refresh failures when someone leaves.
• Assign at least two Admins per workspace. This redundancy ensures someone is always available to manage workspace content and permissions.
• Establish a clear governance policy. Document who is responsible for creating, maintaining, and certifying reports. This ensures everyone understands their role and avoids orphaned reports when teams change.
• Leverage SharePoint/OneDrive integration. For an even more robust solution, you can sync your workspace with a SharePoint document library. Storing the .PBIX file there creates a single source of truth that is accessible to all permitted team members, effectively decentralizing the "ownership" of the source file.

Final Thoughts

Changing the owner of a Power BI report is fundamentally about managing access and credentials within a workspace. By focusing on App Workspaces and taking over dataset settings, you can ensure a smooth transition that keeps your reports live and your data fresh. Use the right method based on your scenario, and you'll handle any handoff with confidence.

At the end of the day, managing file ownership, user access, and broken credentials are all symptoms of a manual and disconnected reporting process. At Graphed we felt this pain ourselves, which is why we built a tool to eliminate it entirely. By connecting your marketing and sales platforms to our AI data analyst, you can simply describe the dashboards you need in plain English. Your dashboards are built instantly, update in real-time automatically, and can be securely shared with anyone on your team - no more emailing .PBIX files or worrying about who owns the dataset refresh.