How to Connect Power BI to Dataverse

Connecting Power BI directly to Microsoft Dataverse opens up a powerful way to visualize and analyze the data driving your business applications. If you're using Dynamics 365 or custom Power Apps, this connection lets you build rich, interactive reports without complicated data migrations. This article provides a step-by-step guide on how to connect Power BI to Dataverse and offers some practical tips to get you started.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is Dataverse and Why Connect It to Power BI?

Think of Microsoft Dataverse as the smart, secure data foundation that underpins many Microsoft business applications, including the entire Dynamics 365 suite (Sales, Customer Service, Field Service) and custom applications built with Power Apps. It’s more than just a database, it stores your data in a standardized set of tables and includes business logic, security, and integration capabilities right out of the box.

While the reporting tools within Power Apps and Dynamics 365 are useful for day-to-day operations, Power BI takes your analytics to an entirely new level. Connecting the two gives you several key advantages:

• Advanced Visualizations: Power BI offers a massive library of charts, graphs, maps, and custom visuals that go far beyond what’s available in the native apps.
• Data Mashups: You can combine your Dataverse data with information from hundreds of other sources - like Google Analytics, Salesforce, spreadsheets, or SQL databases - to get a complete picture of your business. For example, you could merge your sales data from Dataverse with marketing campaign data from a spreadsheet to calculate ROI.
• Rich Data Modeling: Power BI’s Power Query Editor allows you to clean, transform, and shape your data precisely as you need it before building your reports.
• Wider Sharing & Collaboration: Securely share interactive dashboards with stakeholders across your organization, even with those who don't have access to the underlying Dynamics 365 or Power Apps environment.

Prerequisites for Making the Connection

Before you get started, make sure you have everything you need. The setup is straightforward, but you'll have a smoother experience with the right tools and permissions in place.

• Power BI Desktop: You'll need the latest version of Power BI Desktop installed on your computer. It's a free application from Microsoft.
• Dataverse Environment Access: You must have access to a Power Apps or Dynamics 365 environment.
• Proper Permissions: Your account needs a security role with read permissions for the specific tables you want to access in Dataverse. Typically, a "System Customizer" or "System Administrator" role is sufficient, but a custom role can also work.
• Your Environment URL: You need to know the specific URL of your Dataverse environment. If you don't have it handy, you can find it by logging into the Power Apps portal, selecting the correct environment in the top-right corner, clicking the settings gear icon, and opening "Session details." The "Instance URL" is what you're looking for.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide: How to Connect Power BI to Dataverse

Connecting Power BI to your Dataverse environment is handled through a dedicated connector. The process only takes a few minutes.

Step 1: Open Power BI Desktop

Launch Power BI Desktop. You can start with a new, blank report or open an existing one you'd like to add Dataverse data to.

Step 2: Start the "Get Data" Process

On the Home ribbon, click on the Get Data button. This will open a dropdown menu. Select More... at the bottom to open the full list of available data connectors.

Step 3: Select the Dataverse Connector

In the Get Data window, select Power Platform from the list of categories on the left. In the list of connectors that appears, you will find Dataverse. Select it and click Connect.

Step 4: Enter Your Environment URL and Connectivity Mode

A dialog box will appear asking for two key pieces of information:

1. Environment Domain: Paste the Instance URL of your Dataverse environment that you copied earlier here. Make sure to remove the https:// prefix and any trailing /. For example, if your URL is https://yourorg.crm.dynamics.com/, you would enter yourorg.crm.dynamics.com.
2. Data Connectivity mode: You have to choose between Import and DirectQuery. This is an important choice that affects your report’s performance and data freshness.

Understanding Import vs. DirectQuery

This setting determines how Power BI interacts with your Dataverse data.

• Import: This mode copies the tables you select and loads them into your Power BI file. Reports are very fast because all data is stored locally within Power BI's high-performance engine. However, the data is only as fresh as your last refresh. This is an excellent choice for smaller datasets or for reports where near-real-time data isn't a strict requirement.
• DirectQuery: This mode creates a live connection to your Dataverse data. Nothing is copied. When a user interacts with a report (e.g., changing a filter), Power BI sends queries directly to Dataverse and shows the current results. The data is always up-to-date. This option is ideal for very large datasets that won't fit into memory or for reports where real-time analysis is critical. Be aware that report performance will depend on the responsiveness of your Dataverse environment.

For most general business reporting, starting with Import mode is a safe bet. Click OK when you're ready.

Step 5: Authenticate Your Account

Power BI will now prompt you to sign in. Since both Power BI and Dataverse are part of the Microsoft ecosystem, this is a simple process. Click the Sign in button and use your organizational account (the same one you use for Power Apps or Dynamics 365).

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 6: Navigate and Select Your Dataverse Tables

After you successfully sign in, the Navigator window will appear. This window shows you an organized list of all the tables available in your Dataverse environment. Tables are neatly organized into folders. The "Tables" folder contains the standard entities like Account, Contact, Lead, and Opportunity, as well as any custom tables you've created.

Check the box next to each table you want to bring into your report. As you select a table, a preview of its data will appear on the right side of the window, helping you confirm you've chosen the correct one. A great practice is to only select the tables you actually need for your report to keep your data model clean and efficient.

Step 7: Load or Transform Your Data

At the bottom of the Navigator window, you'll see two options:

• Load: This will load the selected tables directly into your Power BI data model as they are. Power BI will do its best to automatically detect relationships between the tables (e.g., the link between Accounts and Contacts).
• Transform Data: This is often the recommended path. It opens the Power Query Editor, an incredibly powerful tool for data preparation. Here you can clean, shape, and prepare your data before loading it into your report model. You can remove unneeded columns, rename columns for clarity, filter out irrelevant rows, and merge data from different tables.

After clicking Transform Data and making any necessary changes in Power Query, click Close & Apply on the top-left to load your final, clean data into the reporting canvas. You are now ready to start building visuals with your Dataverse data!

Graphed

Still Building Reports Manually?

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

Watch the Demo

Advanced Method: Connecting Using the TDS Endpoint

For users who need to use DirectQuery and are focused on optimal performance, Microsoft provides an alternative method to connect: the Tabular Data Stream (TDS) endpoint. This makes Dataverse look and act like a SQL Server database, which Power BI is highly optimized to query.

To use this method, you first need to enable the feature in the Power Platform admin center:

1. Navigate to the Power Platform Admin Center
2. Select your environment, then go to Settings > Product > Features
3. Find the Enable TDS endpoint setting and turn it on.

Once enabled, you can connect in Power BI like this:

1. In Power BI Desktop, choose Get Data and select the SQL Server connector.
2. For the Server, enter your environment URL and add the port number 5558. It should look like this: yourorg.crm.dynamics.com,5558
3. Select DirectQuery as the Data Connectivity mode.
4. When prompted to sign in, use your organizational account with the Microsoft account option.

This TDS endpoint method provides a highly efficient and performant way to build real-time reports directly on top of your Dataverse data.

Tips for Success

Connecting is just the first step. Here are a few tips to make your reporting experience smoother:

• Manage Relationships: While Power BI is good at auto-detecting relationships, always double-check them in the Model view (the third icon on the left-hand pane). Correct relationships are the foundation of any accurate report that involves multiple tables.
• Use Display Names: Dataverse has both logical names (like statecode) and display names ("Status"). When you're in the Power Query Editor, make sure you're using the display names in your final report to make it readable for your audience.
• Handle "Choice" Columns Correctly: Columns that represent a set of options (known as "Choice" or "Option Set" columns) often import with both the numeric value and the text label. You can easily remove the value column in Power Query to keep your model clean, leaving only the user-friendly labels.
• Filter Before Loading: When working with large tables like "Activity" or "Audit," filter out unnecessary data in Power Query before loading it. For example, if you only need data from the last two years, apply a date filter. This can significantly speed up your data refresh times and improve report performance.

Final Thoughts

By connecting Power BI to Dataverse, you can unlock a new level of insight into your customer data, sales processes, and operational metrics. This integration transforms your raw business application data into a strategic asset, enabling you to build comprehensive, interactive dashboards that drive smarter, data-informed decisions.

If you find that your data story lives across many different platforms - not just Dataverse but also Google Analytics, Shopify, Facebook Ads, and various spreadsheets - the manual work of stitching it all together can be overwhelming. We built Graphed to solve this exact problem. It's an AI data analyst that connects to all your marketing and sales tools and lets you build real-time dashboards and reports simply by describing what you need in plain English. For teams who need answers quickly without extensive setup or technical expertise, it streamlines the entire reporting process from hours down to seconds.