What are Data Source Settings in Power BI?

Managing your data connections in Power BI can feel like a chore, but it's the bedrock of every report you build. Getting your data source settings right is the secret to building reliable, secure, and refreshable dashboards. This guide will walk you through exactly what these settings are, why they are critically important, and how to manage them like a pro.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Are Data Source Settings?

Think of Power BI's data source settings as the central address book for all your data. Every time you connect to a new data source - whether it's an Excel file on your computer, a SQL database on a server, or a web page - Power BI saves the connection information. This saved information is your "data source setting."

These settings store three key pieces of information:

• Connection Details: This is the "address" of your data. For a file, it's the folder path. For a database, it's the server and database name. For a website, it’s the URL.
• Credentials: This is how Power BI proves it has permission to access the data. It could be your Windows username and password, a specific database login, an API key, or simply "Anonymous" for public data.
• Privacy Levels: These are security rules that tell Power BI how to handle data from this source when combining it with others, preventing sensitive information from accidentally being exposed.

By centralizing this information, Power BI saves you from having to enter server names and passwords every single time you want to use a data source you’ve connected to before.

Why These Settings Are So Important

Effectively managing your data sources isn't just a "nice-to-have" skill, it’s fundamental to using Power BI effectively. Here’s why mastering these settings will save you countless headaches.

Efficiency and Consistency

Imagine you have ten different reports all pulling data from the same SQL database. If you had to type in the server name, database name, and your login credentials for each of those ten reports, it would be slow and prone to typos. With centralized settings, you connect once, and Power BI remembers the details. This is especially powerful when using "Global permissions," which store your connections across all of your Power BI files on your machine.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Simplified Maintenance

Business environments change. Servers get upgraded, folders get reorganized, and file names are updated. When your Excel source file moves from a "Test" folder to a "Final" folder, you don't need to rebuild your whole report. You can simply go into the data source settings and point Power BI to the new location. The same is true for databases - if you move from a development server to a production server, you can update the server name in one place, and all your queries will automatically repoint.

Robust Security

Credentials are the keys to your data kingdom. The settings menu provides a secure way for Power BI to store and manage these keys. You can specify different types of authentication (e.g., your Windows login, a specific username/password, or an account key) for each data source. This ensures that only authorized users - or in this case, a user with the right Power BI setup - can access sensitive company data.

Automated Data Refreshes

This is arguably the most critical reason to care about your data source settings. When you publish a report to the Power BI Service (the online version), you can set it up to refresh automatically on a schedule. For this to work, the Power BI Service needs to have the correct, stored credentials to access the original data sources. If the password has changed or wasn't entered correctly in the service, the refresh will fail every time. Getting the credentials right is step one to reliable, automated reporting.

How to Access and Manage Settings in Power BI Desktop

Navigating the data source settings menu is straightforward once you know where to look. Let’s walk through the exact steps.

Inside Power BI Desktop, you can find your settings by going to File > Options and settings > Data source settings.

This opens a new window with two key views at the top:

• Data sources in current file: This shows a list of every single data source being used only in the report you currently have open.
• Global permissions: This shows a complete list of every data source you have ever connected to from your machine using Power BI Desktop, across all your report files. It’s your master list of connections.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Common Actions in Data Source Settings

Here’s how to perform the most common management tasks:

1. Changing the Data Source

Let's say you built a report using an Excel file located in C:\Users\You\Desktop\Sales_Data_Q1.xlsx. Now, the financial team has moved the official file to a shared drive. Here's how to fix it without starting over:

1. Select the data source in the list.
2. Click the Change Source... button.
3. A dialog box will appear. Here, you can click Browse... to navigate to the new file path. If it were a SQL database, this is where you would update the server or database name.
4. Click OK, and Power BI will now pull data from the new location.

2. Editing Credentials (Permissions)

Imagine your password for a company database has just expired and you’ve updated it. Your Power BI report will fail to refresh until you give it the new password.

1. Select the data source whose credentials you need to update.
2. Click the Edit Permissions... button.
3. In the new window that appears, click the Edit button under the "Credentials" section.
4. Here you can update the username and password (for Basic authentication) or sign in again using your organizational account.
5. Once updated, click OK. Power BI now has the new key to access the data.

Pro Tip: When troubleshooting errors, clearing permissions and re-entering credentials from scratch often solves stubborn connection problems.

3. Clearing Permissions

If you want Power BI to completely forget a connection and its associated credentials, you can use Clear Permissions. This is useful for security purposes or when you want a fresh start to troubleshoot a connection.

• Clear Permissions: This removes the saved credentials but keeps the data source in the list. The next time you refresh, Power BI will prompt you to enter credentials again.
• Delete: This option only appears under Global Permissions. It completely removes the data source itself from your global list.

Understanding Data Privacy Levels

When you edit permissions for a data source, you'll see a "Privacy Level" dropdown. This setting is more important than it looks and is designed to prevent you from accidentally sending sensitive data to less-secure data sources.

Here’s what the different levels mean:

• Private: This is for extremely sensitive data, such as employee salaries or personal financial records. A Private data source cannot share information with any other data source, ever.
• Organizational: This is the default for most business data. It’s considered confidential to the company. Data from organizational sources can be combined with data from other organizational sources or public sources.
• Public: This is for data with no security concerns, like data from Wikipedia or a government census website. Public data can be freely combined with any other source.

Why do these settings matter? Power BI sometimes tries to improve performance by sending a query from one source to another source to process the data (a technique called "query folding"). But if you were combining employee salary data (Private) with a public web source, you wouldn't want the salary info sent to that external source. By setting the salary data to Private, you tell Power BI not to do this, protecting your data at the cost of some performance optimization.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Settings in the Power BI Service

Once you’ve published your report, you also have to manage the data sources online in the Power BI Service, especially for automated refreshes.

Let's say your report uses an on-premise SQL server (a server physically located in your office). The Power BI Service is in the cloud, so it can't directly access it. To bridge this gap, you use an On-premises data gateway - a secure piece of software you install inside your network.

To ensure refreshed data flows correctly, you must provide credentials both to the gateway and to the dataset in the cloud. You can find this by navigating to:

1. Your Workspace in the Power BI Service.
2. Find your dataset (it has the same name as your report), click the ellipsis (...) and select Settings.
3. Expand the Data source credentials section.
4. Here, you’ll see your data sources listed. Click Edit credentials and enter the user and password information.

If these credentials aren't configured correctly or expire, your scheduled refresh will fail. The “Scheduled refresh” section will even show you an error and send you an email notification to alert you of the problem.

Common Problems and Troubleshooting

Here are some of the most common errors related to data source settings and how to fix them quickly:

• Error: "The credentials provided are invalid."
• Error: "We couldn't find the file..."
• Error: "Formula.Firewall: Query ... is accessing data sources with privacy levels that can’t be used together."
• Error: Scheduled Refresh fails in the Power BI Service.

Final Thoughts

Getting comfortable with the Data source settings menu transforms Power BI from a simple visualization tool into a robust and manageable reporting system. Taking the time to understand how to change sources, update credentials, and configure privacy levels will save you hours of frustration and ensure your dashboards are always accurate and up-to-date.

While mastering Power BI's technical details is a great skill, sometimes you just need to get answers from all your scattered data sources without friction. At Graphed, we simplified this process entirely. You connect your marketing and sales data sources in seconds, and our AI helps you build dashboards and reports using simple, natural language. It allows you to get valuable insights right away, skipping the long setup and focusing directly on what the data means for your business.