Power BI We cannot connect because this resource does not support this credential type

When trying to connect Power BI to SharePoint, you may encounter an error that the type of credentials provided is not supported for a specific resource. This has an impact on workflow and needs to be addressed promptly. This article will explore how to deal with Power BI prompting that it cannot connect because the resource does not support the credential type.

Power BI We cannot connect because this credential type is not supported for this resource

If Power BI shows "We cannot connect because this resource does not support this credential type", then follow the solutions mentioned below.

Permission to edit data sources

Clear cache and/or change permissions

Change default browser

Clear data source

Use OData Feed

Contact Power BI Support

Let’s talk about it in detail.

1]Permission to edit data sources

Our first solution requires Edit Data Source permissions, including Microsoft account credentials. This will help you do this. Follow the steps listed below to do the same.

Go to Options and Settings and click Data Source Settings.

From the given list, you need to select the Sharepoint you want to edit.

Now, go to Edit Permissions >Edit.

Enter your Microsoft account credentials and click OK.

Finally, check whether the problem is solved.

2]Clear cache and/or change password

It is obvious from the error message that the problem mainly stems from the certificate issue. One of the best solutions is to clear Power BI's cache and ask your IT administrator to change the password. This has been proven effective by many users. To clear Power BI Desktop’s cache, you can follow the steps below.

Open the Power BI Desktop application.

Now, go to the file.

Navigate to Options & Settings > Options.

In the Global section, click the Data Loading tab.

Finally, from the Data Cache Management options, click Clear Cache.

After clearing the cache, verify whether the problem has disappeared. If the problem persists, be sure to contact the administrator and request a change of account password.

3]Change default browser

Sometimes, the connection between Power BI and SharePoint or data source may fail if the default browser is not used for authentication. To make sure the connection is working properly, we need to check the authentication browser and set it as the default browser. You can make the necessary changes by following the instructions provided.

In Power BI desktop, go to File.

Then, navigate to Options and Settings.

From Global, search for Security and select it.

Go to the Authentication browser section, select Use my default browser, and click OK.

This will do the trick for you.

4]Clear data source

It is not uncommon for a data set to become corrupted and need to be refreshed. If they are corrupted, users can be restricted from accessing the resources. In this case we can easily clear the permissions and enter the credentials again to make it work. Follow the steps mentioned below to perform the same.

In Power BI desktop, click File > Options & Settings.

Go to Data Source Settings > Global Permissions.

Select the listed SharePoint and click Clear Permissions.

Finally, close the window.

You can now enter your credentials again and it will do it for you.

5]Connect to SharePoint using OData Feed

If you are unable to connect to the SharePoint list, try doing the same using an OData feed. It's simple: press Get Data Reed From Home, then go to Odata Feed. Enter the SHAREPOINT list URL feed in the text box, in the following format: http://URL/Location/DataListicles.svc. Then, select an authentication method for the SharePoint list data source. Finally, click the Connect button.

6]Contact Power BI Support

If all else fails, we must contact the Power BI support team, create a ticket, and let them resolve the issue. To do this, please visit support.Fabric.microsoft.com and they will work with you to fix the issue.

Hope you can solve the problem using the previously mentioned solutions.

The above is the detailed content of Power BI We cannot connect because this resource does not support this credential type. For more information, please follow other related articles on the PHP Chinese website!