How to Get Data from PowerApps to Power BI

Moving your data from a Power App into Power BI is the key to unlocking real business intelligence. While your Power App is great at capturing and managing data, Power BI is where that data comes to life with rich visualizations and deep analysis. This guide will walk you through the process, covering the most common data sources you're likely using.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Visualize Power Apps Data in Power BI?

First, let's quickly cover why this is such a powerful step. Your Power App is an interface - a user-friendly way to interact with data. Power BI is an analytics engine. By connecting them, you can:

• Perform Advanced Analysis: Power BI goes far beyond the basic charts in Power Apps. You can use DAX (Data Analysis Expressions) to create complex calculations, forecast trends, and identify key performance indicators.
• Create a Holistic View: Your Power App data is just one piece of the puzzle. In Power BI, you can merge it with data from marketing platforms, sales CRMs, financial software, and more, all in one dashboard.
• Build Shareable Reports: Stakeholders and executives may not need to use the Power App itself, but they definitely need to see the insights from the data it collects. Power BI reports can be published and shared securely across your organization.
• Track Historical Performance: Easily analyze data over time to spot trends, measure progress against goals, and make informed decisions about the future.

The Most Important Concept: Your Data's True Home

Before anything else, you need to understand one crucial point: Power Apps is almost always a front-end application. The data itself doesn't live inside the app. The app is a window that reads data from, and writes data to, a separate data source.

To get your data into Power BI, you don't connect to the "Power App." You connect directly to the backend data source where the information is actually stored. The most common data sources for Power Apps are:

• Dataverse: Microsoft's powerful, secure, and scalable data platform. It's the standard for building enterprise-grade Power Apps.
• SharePoint Lists: A very popular choice, especially for team-level apps and citizen developers, because it's included with most Microsoft 365 plans.
• Excel Files: Usually stored in OneDrive for Business or SharePoint, often used for simpler apps or initial prototypes.
• SQL Server: A robust, traditional database for more complex data needs.

The method you use depends entirely on which of these (or others) your app is built on. Let's walk through the most common scenarios.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Connecting Power BI Directly to Dataverse

If your Power App uses Microsoft Dataverse, you're in the best-case scenario. The integration is seamless and designed for this purpose. Follow these steps.

1. Find Your Dataverse Environment URL

You'll need a unique URL to tell Power BI which Dataverse environment to connect to. It's easy to find.

1. Go to make.powerapps.com.
2. Make sure you have the correct environment selected in the top right corner.
3. Click the Settings gear icon on the top navigation bar and select Session details.
4. In the Power Apps session details pop-up, you'll see a field called Instance url. Double-click it and copy the entire URL. It will look something like https://org-name.crm.dynamics.com/.

2. Connect from Power BI Desktop

Now, open the Power BI Desktop application and get ready to connect.

1. In the Home ribbon, click on Get data.
2. In the search box, type "Dataverse" and select the Dataverse connector. Click Connect.
3. In the dialog box, paste your Environment URL that you copied earlier into the Environment domain field.
4. Next, choose your Connectivity mode:
5. Click OK. You may be prompted to sign in with your organizational (Microsoft 365) account.
6. The Navigator window will appear, showing you a list of every table available in your Dataverse environment. Find and check the boxes for the main tables and any related tables your Power App uses (e.g., Accounts, Contacts, and your own custom tables).
7. Click Load to pull the data straight into Power BI, or even better, click Transform Data to open the Power Query Editor for cleaning and shaping first.

Connecting Power BI to a SharePoint List

If your Power App's backend is a SharePoint List, the process is just as straightforward but has a few different considerations.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Get Your SharePoint Site URL

Simply navigate to the SharePoint site where your list is located. You just need the main URL for the site, not the full URL to the list itself. For example, if your list is at https://yourcompany.sharepoint.com/sites/Marketing/Lists/CampaignTracker, you only need to copy https://yourcompany.sharepoint.com/sites/Marketing.

2. Connect from Power BI Desktop

1. In Power BI, click Get data.
2. Search for "SharePoint Online list" (make sure you pick this one, not "SharePoint Folder" or "SharePoint List"). Click Connect.
3. Paste the Site URL you copied into the dialog box. You can generally leave the Implementation set to the default (2.0), as it's more efficient.
4. Click OK and sign in with your organizational account if prompted.
5. The Navigator will show all the available lists on that site. Find your list, check the box, and click Transform Data.

A Crucial Tip for SharePoint Data

It is highly recommended to always use Transform Data for SharePoint lists. Complex columns like Choice, Person, or Lookup fields will show up in Power BI as "[Record]" or "[List]".

To get the actual data, you must expand these columns in the Power Query Editor. Simply click the two-way arrow icon in the column header and select the fields you need (e.g., for a 'Created By' Person column, you might expand it to see the person's Title and Email). This step is essential for making sense of your data.

Using Excel in OneDrive or SharePoint as a Data Source

While less robust, using Excel as a backend is common for quick proof-of-concepts. Here’s how to connect it to Power BI.

1. Open Power BI Desktop and click Get data -> Web.
2. Now, in a browser, navigate to your Excel file located in either SharePoint or OneDrive for Business. Do not open the file in the browser version of Excel. Instead, select the file and open the Details pane.
3. In the Details pane, scroll down until you see the Path and click the Copy path icon.
4. This is the trick: You need to remove the text ?web=1 from the very end of the URL you just copied. That part tells the browser to open it in a specific view, which the Power BI connector doesn't like.
5. Paste the newly cleaned URL into the Web connector in Power BI and click OK.
6. After signing in, the Navigator will show you all the available tables and sheets in your Excel workbook. It's a best practice to format your data as a Named Table in Excel, as this makes it much cleaner to import.
7. Select the tables you need and click Load or Transform Data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Best Practices for Your Data Model

Once you've connected to your data source, keep these tips in mind to build an effective report:

• Choose Your Columns: In Power Query ("Transform Data"), use the "Choose Columns" function to remove any columns you don't need for your visuals. A smaller, leaner dataset will result in a faster report.
• Check Data Types: Power Query does a good job of guessing data types (Text, Whole Number, Date, etc.), but it sometimes gets it wrong. Double-check that your key columns have the correct types assigned.
• Create Relationships: Once your data is loaded into Power BI, go to the Model view. If you loaded multiple related tables (e.g., Projects and Tasks), drag the unique ID field from one table to the matching ID field in the other to create a relationship. This is the foundation of powerful data modeling in Power BI.

Final Thoughts

Connecting your Power App data to Power BI is all about identifying and plugging into the right backend data source, not the app itself. By following the steps for Dataverse, SharePoint, or Excel, you can successfully bring your operational app data into a powerful analytical environment and start uncovering meaningful business insights.

Connecting all of these different sources, cleaning the data, and building dashboards from scratch can be a time-consuming, manual process. At Graphed, we've focused on automating away this exact type of data work. By connecting your tools, we enable you to instantly create dashboards and get insights simply by asking questions in plain English. No need to learn new interfaces or spend hours clicking around. If you want to spend less time building reports and more time acting on them, see how we can build your next dashboard in seconds with Graphed.