What is OneLake Datahub in Power BI?

If you're using Power BI, you may have noticed the "OneLake data hub" appearing in your workspace. It's more than just a new name for the old Datasets hub, it represents a significant shift in how Microsoft handles data analytics. This article will explain exactly what the OneLake Data Hub is, how it works, and how you can use it to build better, more reliable reports.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is OneLake? The "OneDrive for Data"

Before jumping into the data hub itself, it helps to understand its foundation: Microsoft OneLake. Think of it as OneDrive, but instead of for your documents, it’s for all your company's analytical data.

Historically, businesses kept data in separate, disconnected systems. The sales team's data lived in a CRM data mart, marketing's data was in another analytics tool, and finance data was stored in yet another database. Each system required its own connections, security rules, and pipelines. Moving data between them to create a unified report was a slow and complex process, often leading to multiple, conflicting versions of the same file.

OneLake, which is the foundational data lake for Microsoft Fabric, aims to solve this problem. It provides a single, unified storage location for all of an organization’s data. This means there’s only one copy of your data, but multiple tools - like Power BI for reporting, Spark for data engineering, or Synapse for data warehousing - can all access and use it simultaneously without moving or duplicating it. This unified approach is the core idea behind the entire Microsoft Fabric platform.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The OneLake Data Hub: Your Data's Front Door

So, if OneLake is the giant, centralized storage system for your data, the OneLake Data Hub is the user-friendly interface or "front door" you use to find, manage, and connect to that data from within Power BI and other Fabric applications.

It's essentially a catalog or marketplace for all the data assets your organization has. It’s where data analysts, report creators, and business users can go to discover what data is available, check its quality, and easily connect to it for their own analyses. It centralizes not just traditional Power BI datasets and dataflows, but also Fabric items like Lakehouses, KQL databases, and Warehouses. This gives you a complete view of all available data, not just the pieces specific to Power BI.

Key Features of the OneLake Data Hub

The data hub isn't just a list of files, it equips you with tools that promote efficiency, trust, and good data governance.

1. Centralized Data Discovery

The most immediate benefit is being able to find the data you need quickly. Instead of asking colleagues or digging through dozens of workspaces, you can use the data hub’s search and filtering capabilities.

• Search Bar: A powerful search function lets you search for data items by name, owner, or other metadata.
• Filtering: You can easily filter the view by data type (e.g., show only datasets or warehouses), workspace, or owner.
• "Recommended for You": Power BI uses its AI capabilities to suggest data items that might be relevant to your work, saving you time.

2. Data Reusability and the Single Source of Truth

The hub’s biggest strategic advantage is driving data reusability. In many organizations, when a marketer needs a sales report, they export raw sales data and build a new dataset from scratch. A week later, another marketer does the same thing. Soon, you have five different "Sales" datasets, each with slightly different calculations or filters.

The OneLake data hub prevents this. A data expert can create a single, master "Certified Sales Dataset." Now, whenever anyone needs sales data, they can simply discover and connect to this trusted dataset in the hub. This ensures everyone is working from the same numbers and business logic, establishing a reliable "single source of truth."

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Endorsement and Promotion for Data Governance

Not all data is created equal. Some datasets are official and vetted, while others might be temporary or experimental. The OneLake data hub provides an endorsement system to help users distinguish between them.

• Promoted: This status can be assigned by dataset owners to signal that the data is ready for wider use. It’s like saying, “This is high-quality work that others can benefit from.”
• Certified: This is the highest level of endorsement and can typically only be granted by designated administrators. A certified dataset means it's an official, authoritative source of data for the organization. This seal of approval builds immense trust and encourages reuse.

When you're browsing the hub, you can filter for only "Certified" and "Promoted" items, instantly honing in on the most trustworthy data available.

4. Data Lineage and Impact Analysis

Understanding where data comes from and how it's being used is incredibly important. The data hub offers a visual lineage view.

• Data Lineage View: This feature allows you to trace a data item’s journey from its original source (like a SQL database or a cloud storage account) all the way to the reports and dashboards that use it.
• Impact Analysis: Let's say you need to change a column in a core dataset. How do you know what will break? The hub’s lineage view shows you exactly which reports, dashboards, and other datasets depend on it. This lets you notify owners and plan for changes, preventing unexpected errors.

A Practical Walkthrough: Using the OneLake Data Hub

Seeing how it works in practice makes the concepts much clearer. Let's walk through a common workflow for a report builder.

Step 1: Discovering Data in the Power BI Service

First, log in to your Power BI account online. In the navigation pane on the left, you'll see "OneLake data hub." Clicking this takes you to the main catalog.

Imagine you need to build a report on quarterly marketing performance. You can use the search bar to look for "Marketing." The hub will return all related data items. To narrow it down, you can apply a filter to see only "Certified" datasets, ensuring you use the official source your team has approved.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Exploring Data Item Details

Once you find a promising dataset named something like "Marketing Campaign Performance QTR," click on it. This opens a details page where you can get more information:

• Owner: See who created and maintains the dataset.
• Refresh Schedule: Check how often the data is updated.
• Related Reports: Look at existing reports built on this dataset to get inspiration or see if your desired report already exists.
• Lineage: View the data's lineage to understand its source.

Step 3: Connecting from Power BI Desktop

After confirming this is the right dataset, it's time to build your report. Open Power BI Desktop.

1. Navigate to the "Home" ribbon.
2. Click on the Get Data dropdown and select OneLake data hub. (This button might also appear as "Power BI datasets" depending on your version).
3. A window will open showing the exact same data hub view you saw in the Power BI service.
4. Since you've already identified the certified marketing dataset, you can find it quickly, select it, and click "Connect."

Power BI Desktop will now establish a live connection to that dataset. You haven't imported any raw data, you've simply connected to the existing, governed model. All the predefined measures, column names, and relationships are ready for you to use. You can now build your visuals with the confidence that you're using vetted, consistent company data.

Final Thoughts

What used to be a frustrating hunt for reliable information across scattered folders and workspaces is now a centralized discovery experience. The OneLake Data Hub in Power BI serves as your organization’s structured library for analytical data, making it easy to find, trust, and reuse valuable assets to make smarter, more consistent business decisions.

This challenge of centralized data is something we think about constantly. Many teams find their critical sales and marketing data is locked away not just in different workspaces but in completely different apps like Google Analytics, Shopify, Facebook Ads, or Salesforce. At Graphed, we help you overcome this by connecting all of these sources in one place. You can then use simple, natural language - like "compare Facebook Ads spend vs. revenue by campaign" - to instantly build the dashboards and reports you need, getting you from scattered data to powerful insights in seconds.