How to Get to Data Source Settings in Power BI

Knowing how to manage your data source settings in Power BI is one of the most fundamental skills for building reliable reports. It's the central hub for updating file paths, changing credentials, and ensuring your data refreshes correctly. This guide will walk you through exactly where to find and what to do with these settings in both Power BI Desktop and the Power BI Service.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Your Data Source Settings Are So Important

Think of the data source settings panel as the control room for all your data connections. Your beautiful Power BI report is useless if it can't connect to the underlying data. You'll need to access these settings when you need to:

• Update a file path: If you move a source Excel or CSV file from your Downloads folder to a shared drive.
• Change credentials: When a database password expires or a new API key is issued.
• Modify database or server names: If your company migrates its data from a test server to a production server.
• Configure privacy levels: To control how different data sources can interact with each other, preventing accidental data leakage.
• Fix broken connections: It's the first place to look when your report fails to refresh.

Mastering this simple area can save you hours of frustration and is key to maintaining accurate and up-to-date dashboards.

Accessing Data Source Settings in Power BI Desktop

Power BI Desktop is where you build your reports, and it has a dedicated, easy-to-access panel for managing the connections within your current .pbix file. There are two primary ways to get there.

Method 1: Through the Power Query Editor (Most Common)

This is the method most analysts use daily, as it's right where you do all your data transformation work.

1. On the Home tab of the Power BI Desktop ribbon, click the Transform data button. This will open the Power Query Editor in a new window.
2. In the Power Query Editor window, once again on the Home tab, click the Data source settings button.

A dialog box will appear, showing you every data source currently connected to your file. From here, you can manage the connections for the current file or your global connections stored across all your Power BI projects.

Method 2: Through the File Menu (The Shortcut)

If you don't need to open the full Power Query Editor and just want to quickly get to the settings, you can use this shortcut:

1. From the main Power BI Desktop window, click File in the top-left corner.
2. Select Options and settings, then click Data source settings from the dropdown menu.

Both methods will take you to the exact same settings window.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What You Can Do in the Desktop Settings

Once you’re in the Data Source Settings window, you have several powerful options at your disposal. Let’s break down the most important ones.

Change Source

This is easily the most-used feature. Imagine you built a report based on an Excel file named MonthlySales_Jan.xlsx on your desktop. Next month, you need to point it to MonthlySales_Feb.xlsx or perhaps move it to a central SharePoint folder for the whole team to access.

Instead of rebuilding the whole report, you just need to change the source:

1. Select the data source you want to update from the list.
2. Click the Change Source... button.
3. A new window will appear, allowing you to browse to the new file location or enter new server details. For a file, you'd click Browse... and select the new Excel or CSV file. For a SQL database, you would update the server address.
4. Click OK, and Power BI will re-establish the connection. All your existing transformations in Power Query will be reapplied to the new source.

Edit Permissions & Clear Permissions

These settings manage the credentials Power BI uses to access your data sources, like databases, APIs, or secured websites.

• Edit Permissions: Use this when you need to update a stored password or token. For example, if your company's SQL database policy requires you to update your password every 90 days. You would select the source, click Edit Permissions..., and then click Edit... next to the Credentials to enter the new password.
• Clear Permissions: This option makes Power BI "forget" the saved credentials for a specific data source. It’s useful for troubleshooting when a connection is acting strange or if you want to force Power BI to prompt for credentials again on the next refresh.

Managing Global Permissions

In the Data Source Settings screen, you'll see a radio button for "Data sources in current file" and another for "Global permissions." While the first is for the project you're working on, Global permissions is a list of every data source you've ever connected to from your Power BI Desktop. It's a master list kept by the application itself. Cleaning this list periodically by selecting old, unused sources and clicking Delete can be good practice, especially if you deal with many temporary data sources.

Managing Data Sources in the Power BI Service

Once you've published your report to the Power BI Service (app.powerbi.com), managing data sources shifts. The service can't see the files on your local computer or access your internal databases directly. You need to configure this connection in the cloud to enable features like scheduled refreshes.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Finding Your Dataset Settings

In the Power BI service, settings are managed at the Dataset level, not the report level. A single dataset can power multiple reports, so you only have to update the settings in one place.

1. Log in to https://app.powerbi.com.
2. Navigate to the workspace where you published your report using the left-hand navigation pane.
3. Switch from the "All" or "Content" view to the Datasets + dataflows tab to easily locate your dataset.
4. Hover your cursor over your dataset, click the vertical three-dot menu (...), and select Settings from the dropdown menu.

This will take you to the main settings page for that specific dataset.

Key Settings to Configure in the Service

Here are the two most critical sections you'll interact with on this page.

1. Data source credentials

When you published your report from Desktop, your stored credentials were not published with it for security reasons. The Power BI Service needs its own permission to access your data. In this section, you'll see a list of your data sources and a prompt to provide credentials for each.

For cloud services like SharePoint Online or Azure SQL, you’ll typically use an OAuth2 authentication method, which will pop up a sign-in dialog for you to log in securely. For other sources, you may need to enter a username/password (Basic) or an API key.

Until you successfully provide valid credentials here, no scheduled refreshes will work.

2. Gateway connection

This section is crucial if your report connects to any on-premise data sources, such as a SQL Server running inside your company's network or an Excel file on a local file share.

The Power BI service, being a cloud application, cannot reach into your private network. An On-premises data gateway is a small, secure application you install on a server within your network to act as a bridge. It securely funnels data requests from the Power BI Service to your local data source and sends the refreshed data back up.

After installing and configuring a gateway, you would come to this section in your dataset's settings to map your on-premise data source to the corresponding data source "on" the gateway. If this mapping is green and showing a successful connection, you're good to go.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Configuring Scheduled Refresh

Once your credentials and gateway (if needed) are configured correctly, you can expand the Scheduled refresh section. Here, you can toggle the refresh on, set the frequency (e.g., daily, weekly), select your time zone, and specify the time you'd like the refresh to run. Power BI will then be able to automatically keep your report's data up-to-date without any manual intervention.

Common Problems & Quick Fixes

• Error: "The file path could not be found." Fix: The source file was moved, renamed, or deleted. In Power BI Desktop, go to Data source settings and use Change Source to point it to the new location.
• Error: "Scheduled refresh failed due to invalid credentials." Fix: Log in to the Power BI Service, go to the Dataset settings, and under Data source credentials, click Edit credentials to re-enter your password or re-authenticate via OAuth2. This often happens after a password change.
• Error: "This query references other queries, and this is not supported." Fix: This is a privacy level issue. Go to Data source settings in Desktop and check that your different sources aren't configured in a way that prevents them from being combined (e.g., trying to combine a 'Private' source with a 'Public' one). Adjust the levels as needed and try again.

Final Thoughts

Whether you're fixing a broken path, updating a password, or setting up a daily refresh, knowing your way around the data source settings is critical for any Power BI user. It's the central command for ensuring the data flowing into your reports is accurate, timely, and accessible. Getting comfortable in these menus in both Desktop and Service will move you from being a beginner to a truly confident report-builder.

While mastering Power BI settings is a powerful skill, sometimes the goal is just to connect data and get insights without managing the complex plumbing. At our company, we experienced the headaches of manual setup, troubleshooting credentials, and setting up gateways. This is precisely why we created Graphed. We automate data connections to your favorite marketing and sales platforms, so you can just ask a question like "show me last month's ad spend versus revenue by campaign," and instantly get a live, interactive dashboard - no setup required.