How to Use Power BI Dataset in Power BI Report Builder

Power BI is an incredible tool for creating interactive dashboards, but when you need a perfectly formatted, multi-page report that you can print or export as a PDF, Power BI Report Builder is the way to go. The best part? You don't have to start from scratch. You can connect Report Builder directly to the datasets you've already created in Power BI. This article will show you exactly how to use a Power BI dataset as the foundation for your paginated reports, giving you the best of both worlds.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Use a Power BI Dataset in Report Builder?

Connecting Report Builder to an existing Power BI dataset might seem like an extra step, but it's a game-changer for data consistency and efficiency. Think of your Power BI dataset as your team's "single source of truth." It's a curated data model where all the complex relationships have been defined, calculations have been written in DAX, and key performance indicators (KPIs) have been standardized.

When you build your paginated reports on top of this dataset, you gain several key advantages:

• Consistency is King: Everyone in your organization uses the same underlying data, relationships, and business logic. A "Total Sales" measure will mean the same thing in a dashboard as it does in a printed invoice or a detailed monthly summary.
• Save Time and Effort: Why reinvent the wheel? All the work you put into cleaning data, building relationships, and writing complex DAX measures in Power BI Desktop is instantly reusable in Report Builder. You don't need to rebuild any of it.
• Centralized Management: If a business rule changes or a calculation needs updating, you only have to change it in one place: the central Power BI dataset. Once you refresh it, all connected dashboards and paginated reports will update automatically.
• Leverage the Power of DAX: You can use the powerful DAX (Data Analysis Expressions) queries to pull precisely the data you need for your report, without having to write complex SQL.

Essentially, Power BI interactive reports and Report Builder paginated reports become two different outputs from the same rock-solid data foundation. One is for exploration and visual analysis, while the other is for controlled, operational reporting.

Prerequisites: What You’ll Need

Before you get started, let's make sure you have everything you need in place. The setup is straightforward, but you’ll want to check these boxes first:

• A Power BI Pro or Premium Per User (PPU) License: Connecting to Power BI datasets from external applications is a premium feature, so you'll need one of these license types. You'll also need edit permissions for the workspace where your chosen dataset is located.
• Power BI Report Builder Installed: This is a separate desktop application from Power BI Desktop. The good news is that it’s a free download from Microsoft. If you don't have it yet, you can easily find and install it from the Microsoft website.
• An Existing Power BI Dataset: You'll need a prepared dataset already published to a workspace in the Power BI service. This will be the data source for your new report.

Connecting to a Power BI Dataset: A Step-by-Step Guide

With the essentials out of the way, let's walk through the process of linking Report Builder to your Power BI data. It only takes a minute.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Open Power BI Report Builder

Fire up the Power BI Report Builder application on your computer. You’ll be greeted with a startup screen. You can close this and start with a blank canvas.

Step 2: Add a New Data Source

Look for the "Report Data" pane, which is typically on the left side of your screen. This is where you'll manage all the data connections and datasets for your report.

Right-click on the Data Sources folder and select "Add Power BI Dataset Connection" from the context menu.

Step 3: Sign In and Select Your Workspace

A sign-in window will pop up asking for your Power BI credentials. Go ahead and log in with your work account. After authenticating, a new window will appear that allows you to browse all of the Power BI workspaces you have access to. Navigate to and select the workspace where your target dataset is published.

Step 4: Choose Your Dataset

Once you’ve selected a workspace, Report Builder will display a list of all the datasets available within it. Find the dataset you want to use for this report, select it, and then click the "Select" button.

That's it! In the Report Data pane, you'll now see a new item under the "Data Sources" folder, likely named something like PowerBI-Dataset-YourDatasetName. Your report is now officially connected to your centralized data model.

Building a Dataset Query in Report Builder

You've connected to the data source, but now you need to tell Report Builder exactly which pieces of data you want to pull for your report. You accomplish this by creating a dataset in Report Builder that is powered by a DAX query.

Step 1: Create a Report Dataset

Back in the "Report Data" pane on the left, right-click on the Datasets folder and choose "Add Dataset...".

This opens the "Dataset Properties" window. The first thing you should do is give your dataset a descriptive name - for example, "SalesByCategory" or "MonthlyRevenue" - and ensure that the "Data source" dropdown points to the Power BI connection you just created.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Using the Graphical Query Designer (The Easy Way)

For most reports, the built-in query designer is the simplest way to build your query without writing any code.

Click the "Query Designer..." button to launch the interface. This designer has a layout that will feel familiar to anyone who has used a pivot table:

• On the right, you’ll see all available fields from your Power BI model, with measures (like [Total Sales]) at the top and tables with columns (like Product[Category]) at the bottom.
• The main central area is where you drag the fields you want in your report.
• On the top right, there is a "Filters" pane where you can drag columns to pre-filter your data. For example, you could drag the Date[Year] column here and set it to only show data for "2023".

To build your query, simply drag the measures and columns you need from the right pane into the central area. As you do this, Report Builder writes the corresponding DAX query for you in the background. Once you're happy with your selection, click "OK" to save it.

Step 3: Writing a DAX Query Manually (The Pro Way)

Sometimes you need more control than the graphical designer offers. For advanced scenarios, you can write your own DAX query.

In the "Dataset Properties" window, instead of clicking the Query Designer button, look for an option to switch to text mode. You can then type or paste your DAX query directly into the textbox. This is perfect for more complex logic or for using DAX functions that aren't exposed in the graphical UI.

A simple manual query might look like this:

EVALUATE
SUMMARIZECOLUMNS(
    'Date'[Year],
    'Product'[Category],
    "Sales", [Total Revenue]
)

This query gets the total revenue for each product category, grouped by year. It gives you precise control over the output. When you're done, click "OK."

Designing and Publishing Your Report

Now comes the fun part: designing the actual layout. Under "Dataset" in the Report Data pane, you'll see all the fields you selected in your query.

Add a Table or Matrix

Go to the Insert tab on the top ribbon and select Table. A small table will appear on your design canvas. You can click on the data cells and drag fields from your dataset into them. For example, drag 'Category' and 'Year' to the first columns and drag 'Sales' to the data column. You can easily add more columns, group data, and add totals.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Run and Test Locally

At any time, you can see how your report will look by clicking the Run button on the Home ribbon. This generates a preview of the report with live data fetched from your Power BI dataset. You can switch back to "Design" view to continue making changes.

Publish to the Power BI Service

Once your report is complete, click Publish on the Home ribbon. You’ll be asked to select a destination workspace in the Power BI service. Choose the same workspace where your dataset lives (or another one if you prefer). Give the report a name and publish it.

You can now navigate to that workspace in your web browser, and you’ll see your new paginated report icon. Clicking it will run the report live in the Power BI service, ready to be viewed, printed, or exported.

Final Thoughts

Connecting Power BI Report Builder to your existing Power BI datasets is a powerful way to enhance your company's reporting capabilities. It combines the analytical strength of a centralized data model with the pixel-perfect layout control needed for operational reports, ensuring consistency and saving you a tremendous amount of repetitive work.

As you build out more complex reporting, we know that hopping between platforms and wrangling data can still feel frustrating. That’s why we built Graphed to be the simplest way to connect all your data sources - from Google Analytics and Salesforce to your Google Sheets - and turn them into insights. Instead of learning DAX or clicking through complex B.I. tools, you can just ask questions in plain English to build real-time dashboards and get answers in seconds. It allows anyone on your team to make better, data-driven decisions without waiting on analysts or building reports manually.