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:

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

1. Switch to Database authentication 

2. Check your Power BI settings

3. Ensure Power BI is up to date

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.

SPONSORED Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ