Power Bi Data Source Credentials Greyed Out: 4 Simple Fixes

Explore these expert-recommended methods to resolve the issue

by Loredana Harsana
Loredana Harsana
Loredana Harsana
Managing Editor
Loredana is a passionate writer with a keen interest in PC software and technology. She started off writing about mobile phones back when Samsung Galaxy S II was... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • Data source credentials are disabled by default to prevent users from sharing information when publishing reports.
  • If you want to enable it, follow the step-by-step process mentioned in the guide.
Power Bi Data Source Credentials Greyed Out [SOLVED]

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

Power BI is a powerful data visualization tool that allows users to connect to various data sources and create dynamic, interactive reports and dashboards. However, users may encounter issues from time to time.

One of the most common ones is data source credentials greyed out on Power BI. It occurs if you don’t have permission to edit them or if there is an issue with the connection to the data source. Here, in this guide, we will discuss steps to enable data source credentials.

Why are the data source credentials disabled in Power BI?

There could be various reasons why data source credentials are greyed out; some of the popular ones are 

  • Wrong data source selected – When the data source is set to use Windows or Organizational authentication, you might face this problem.
  • Incorrect permissions – If a user accessing the data source doesn’t have enough permissions, then you might see the credentials greyed out.
  • Misconfigured settings – If the data source is set to Import mode instead of Live mode, as in Import mode, the data is imported and saved in the Power BI report, and credentials are not needed.
  • Accessing the published dataset – If the data source you are accessing is a published dataset in Power BI and can only be edited by the dataset owner or an administrator. Hence the issue.
  • Outdated version of Power BI – If you have an older version of Power BI, then you might face all kinds of errors, including data source credentials greyed out.

How do I enable data source credentials in Power BI?

To enable data source credentials, you need to follow these steps:

  1. Go to the Home tab.
  2. In the Queries pane, click Transform Data, and from the drop-down select Data source settings.click Transform Data
  3. Select the data source for which you want to enable credentials.
  4. Select Edit permissions.
  5. Under Credentials, select Edit.
  6. Choose the appropriate credentials type, and enter the necessary information. Select OK.

How can I fix data source credentials greyed out issues in Power BI?

1. Switch to Database authentication 

  1. Launch Power BI. Now go to the File tab.
  2. Click Options and Settings, then click Data source settings.Data source settings -power bi data source credentials greyed out
  3. In the Data source settings window, select the file and click Edit Permissions.Edit permissions
  4. From here, change the Privacy Level to None.Privacy Level
  5. Click OK and close the Options window. Now check if the issue is resolved.

2. Check your Power BI settings

  1. Launch Power BI, and go to the File menu.
  2. Click Options and Settings, and now click Options.Options and settings
  3. From the Options window, check all the settings in Power BI match the settings in the data source.DatA LOAD
  4. If not, then make the necessary changes and check if the issue is resolved.

3. Ensure Power BI is up to date

  1. Go to the File menu.File menu -power bi data source credentials greyed out
  2. Click Options and Settings, then click Options.Options and settings
  3. Now click Updates.updates -power bi data source credentials greyed out
  4. Place a checkmark next to Display update notifications for Power BI Desktop.
  5. Install updates if available.

4. Use a service account 

If nothing has worked for you from the above steps, you need to create a service account with the necessary permissions to access the data source. Use this account to connect to the data source. 

So, these are the fixes that you need to try to fix Power BI data credentials being grayed out and gain access to the data source. If you have any questions or concerns about Power BI, you can reach out to us in the comments below. We will be happy to help.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: