SharePoint Data Source Connection Problem in PowerBI (Service)

[kenleedom]

Access to users is controlled via groups for the data source hosted at SharePoint.com

When I go to the URL (using personal credentials), it requires OKTA verification. The Power BI Service doesn't allow for OKTA and provides the message:

Unable to start OAuth login for this data source. OAuth login through the data gateway was unsuccessful due to user. Specific error details available below and in the gateway logs.

Details: Dedicated Gateway <Gateway Id>: We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type. <server in gateway cluster>: We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type. Please have this information handy if you choose to create a support ticket. Session Id: 5139a4a3-641e-4570-b834-8e9a6bd512ff RequestId: e69738c7-2f30-4c6a-a1cb-69749a0bd130 Cluster URI: XXXXX Status code: 400 Time: Mon Feb 10 2025 14:35:28 GMT-0500 (Eastern Standard Time)

I have a service account (<service account email>) that has been added to a SharePoint group with Owner access. In an InPrivate Window,  it goes through OKTA. But using PowerBI Windows option will not allow it to connect. Yes, I validated the creds

Unable to create connection for the following reason: Invalid connection credentials.
Details: Dedicated Gateway <Gateway Id>: The credentials provided for the SharePoint source are invalid. (<SharePoint source URL>) <server in gateway cluster>: The credentials provided for the SharePoint source are invalid. (<Source URL>) Please have this information handy if you choose to create a support ticket. Session Id: 5139a4a3-641e-4570-b834-8e9a6bd512ff RequestId: 8a66fc37-b7f6-43a6-96ed-505d4490cf10 Cluster URI: XXXXX  Status code: 400 Time: Mon Feb 10 2025 14:37:10 GMT-0500 (Eastern Standard Time)

Service Principal still isn't allowed to connect.

Unable to create connection for the following reason: We could not access the data source. Please make sure you have permission to access the data source and that your credentials are correct.

Details: Dedicated Gateway <Gateway Id>: Received error payload from gateway service with ID 47540: An exception encountered while accessing the target data source. <server in gateway cluster>: Received error payload from gateway service with ID 169373: An exception encountered while accessing the target data source. Please have this information handy if you choose to create a support ticket. Session Id: 5139a4a3-641e-4570-b834-8e9a6bd512ff RequestId: 852a8d0a-2c08-4dfc-9c11-42a225bc14bf Cluster URI: XXXXX Status code: 400 Time: Mon Feb 10 2025 14:40:03 GMT-0500 (Eastern Standard Time)

As a last ditch effort, I tried anonymous for s**** and giggles to the same result

Does anyone have any suggestions before I start a support ticket???

[v-saisrao-msft · Accepted solution]

Hi @kenleedom,

Thank you for Reaching out to the Microsoft Forum Community.

I have reviewed the information provided and conducted an investigation. To ensure a thorough resolution, I recommend raising a support ticket. This will allow a dedicated team to further investigate the issue and provide a solution.

Please find the link below to submit a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query. 

Thank you.

[kenleedom]

The problem ended up being the Sharepoint url.   Characters outside of the standard naming config had to be removed

https://example.sharepoint.com/:l:/r/sites/asfmd/

[nilendraFabric]

Hello @kenleedom 

not sure it will work, but worth trying 

In Power BI Desktop, go to `File > Options and settings > Options > Security`, and enable the option “Use my default web browser” for authentication. This forces Power BI to use your default browser (which supports OKTA SSO) for logging in.

• After successfully connecting and publishing the dataset from Power BI Desktop, reconfigure the credentials in Power BI Service.

https://community.fabric.microsoft.com/t5/Desktop/Credential-issues-in-Power-BI-connecting-to-ShareP...