What is a Featured Table in Power BI?

Getting your official Power BI data into the ad-hoc world of Excel can feel like more work than it should. You might find yourself exporting CSV files, copying and pasting tables, and hoping the numbers stay correct. But there's a much more direct and powerful way to bridge this gap: the Power BI Featured Table. This article will show you exactly what Featured Tables are, how to set them up, and why they’re a game-changer for your team’s data workflows.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Power BI Featured Table?

In simple terms, a Featured Table is a special designation you apply to a table within your Power BI data model. By flagging a table as "featured," you're essentially telling Power BI, "Hey, this table is important and ready to be used as a special 'data type' in Microsoft Excel."

Think of it like this: your Power BI dataset is a well-organized library of business information. A Featured Table is like putting a "Staff Pick" sticker on a specific book (your data table). When your colleagues browse the library from Excel, that book is highlighted, easy to find, and comes with a clear summary of what it's about.

When someone in Excel links to this table, they don’t just get a static grid of numbers. Instead, they get an interactive, rich data type. For example, if you have a "Products" table, an Excel user could type in a product name like "Deluxe Widget," convert it to a "Product" data type, and instantly pull in related data like its SKU, price, inventory level, or category - all directly from your trusted Power BI dataset.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why You Should Use Featured Tables

Setting up Featured Tables isn't just a neat technical trick, it solves some of the most common headaches associated with data analysis and reporting in large organizations. It closes the loop between the formal, structured environment of business intelligence and the flexible, sandbox environment that Excel provides.

Key Benefits of Featured Tables:

• Create a Single Source of Truth: One of the biggest challenges in data management is dealing with multiple versions of the "truth." When team members export their own CSVs, you end up with outdated or slightly different datasets. Featured Tables ensure that everyone in Excel is pulling from the exact same governed, up-to-date Power BI model.
• Seamless Excel Integration: For many finance, sales, and operations professionals, Excel is home base. Instead of forcing them to become Power BI experts, Featured Tables bring the power of your BI model directly into the tool they already use every day.
• Democratize Your Data: You no longer need to be a Power BI pro to access curated company data. Anyone with Excel can easily find and connect to key datasets like "Customers," "Products," or "Sales Reps" without needing to navigate the Power BI service or understand the complexities of the data model.
• Keep Data Live and Refreshable: Unlike a static CSV export that's outdated the moment you download it, information pulled through a Featured Table can be refreshed in Excel. This means analyses and reports built in spreadsheets can stay current with the latest data from Power BI.

Setting Up Your First Featured Table: A Step-by-Step Guide

Creating a Featured Table is a straightforward process that you do within Power BI Desktop before publishing your report to the Power BI service. Let's walk through it using an example of a "Products" table.

Here’s what you need to do:

1. Open Your Data Model in Power BI Desktop

Start by opening the PBIX file that contains the data model you want to work with. You need to be in Power BI Desktop to make changes to the model structure.

2. Switch to the Model View

On the left-hand side of the Power BI Desktop interface, click on the "Model" icon. This will show you the tables in your model and the relationships between them.

3. Select the Table to Feature

Find and click on the table you want to designate as featured. In our example, we'll click on the Products table. This will bring up the "Properties" pane on the right-hand side.

4. Enable "Is featured table"

In the "Properties" pane, scroll down until you see the toggle switch labeled "Is featured table." Click it to set it to "On." This single action tells Power BI that you want this table to be discoverable in Excel.

Graphed

Still Building Reports Manually?

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

Watch the Demo

5. Configure the Featured Table Properties

Once you enable the featured table, Power BI will prompt you to provide a few key pieces of information. This is the most important part of the setup, as it determines how the data will appear and function in Excel.

Description

This is a plain-language description of your table. Write a clear, concise sentence that helps your users understand what this data represents (e.g., "Contains a list of all official company products, including their SKUs, prices, and categories.").

Row Label

The Row Label is what Excel users will use to identify specific rows of data. It should be the most recognizable, human-readable column in your table. For a Products table, the perfect Row Label would be the Product Name column, not the Product ID. For a Customers table, it would be the Customer Name.

Pro Tip: Think about what a user would naturally type into a cell in Excel to look something up. That’s probably your best choice for a Row Label.

Key Column

The Key Column must contain completely unique values for each row. It's the unique identifier that Power BI and Excel use behind the scenes to make sure they are linking to the correct row of data. For our Products table, this would be a column like ProductID or SKU, as long as every product has a unique one. The Product Name (our Row Label) might not be unique, but the ProductID absolutely must be.

Crucially, you cannot have duplicates in your Key Column. If you do, Power BI will not allow you to set it as a featured table.

6. Save and Publish Your Work

Once you've configured the description, Row Label, and Key Column, click "Save." Then, publish your Power BI report and dataset to the Power BI service. The featured table is now live and ready to be discovered in Excel by anyone who has permission to view the dataset.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Finding and Using Your Featured Table in Excel

Now for the payoff. Here’s how a user would access the Products table we just created:

1. Open Excel: Open a new or existing workbook.
2. Go to the Data Tab: In the Excel ribbon, click on the Data tab.
3. Access "Data Types": In the "Data Types" section, you will see icons for Stocks, Geography, and more. Look for an icon representing your organization. Clicking it will reveal a gallery of available data types from Power BI, including the "Products" table you just published.

From here, users can type a product name into a cell, select it, click on the "Products" data type, and instantly link that cell to the rich data from your featured table. They can then use the small card icon that appears to insert related columns of data, like price or inventory, directly into their spreadsheet.

Best Practices for Creating Useful Featured Tables

To make your featured tables truly valuable for your team, keep these simple best practices in mind:

• Choose Meaningful Tables: Don't just feature every table in your model. Focus on the core business entities that people look up constantly, like Products, Customers, Employees, Stores, or Projects. These are what Power BI calls "dimensional tables."
• Pick User-Friendly Row Labels: Re-emphasizing this point because it's vital for user experience. The Row Label should be what feels natural for someone to search for, not a database ID.
• Keep Your Model Clean: A featured table is only as good as the underlying data model. Ensure the table is clean, the columns are well-named, and the data is reliable. A messy source table leads to a confusing experience in Excel.
• Document and Announce: When you publish a new featured table, let your team know! A quick email or chat message saying, "You can now pull live product data directly into Excel from our official Power BI dataset" can dramatically improve adoption.

Final Thoughts

Power BI Featured Tables are a simple yet incredibly effective way to break down the walls between formal BI and everyday analysis in Excel. By carefully curating and "featuring" your most important data tables, you empower your entire team to work with trusted, refreshable data inside the tool they know and love, fostering a more data-driven culture with less friction.

While this process is a huge improvement over manual exports, it does highlight a common challenge: getting actionable insights often means dealing with complex setup in tools like Power BI. This is precisely why we created Graphed. We believe you shouldn't have to navigate property panes and model views just to get answers. With our platform, you simply connect your data sources – like Salesforce, Google Analytics, or Shopify – and ask questions in plain English. Graphed instantly builds live, interactive dashboards for you, turning hours of tedious setup into a simple 30-second conversation.