Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I need help on how to set up a Power BI OAuth/CRM Data Source in Power BI Service.
At the moment when we attempt to create the data source we get the below error.
Can anyone point me in the right direction to resolve this?
Unable to connect: We encountered an error while trying to connect to https://XXX.api.crm6.dynamics.com/api/data/v8.2/. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: | 8e9a0c29-027f-61b5-4952-f3970a5252d6 |
Request ID: | 97acd10f-56cd-38cf-8703-a036591e5f3e |
Cluster URI: | https://wabi-australia-southeast-redirect.analysis.windows.net |
Status code: | 400 |
Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
Time: | Thu Feb 01 2018 15:42:29 GMT+0800 (W. Australia Standard Time) |
Version: | 13.0.4063.181 |
XXXSQLBI02_PBIGateway: | Invalid connection credentials. |
Underlying error code: | -2147467259 |
Underlying error message: | The credentials provided for the OData source are invalid. (Source at https://XXX.api.crm6.dynamics.com/api/data/v8.2.) |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.CredentialError.DataSourceKind: | OData |
Microsoft.Data.Mashup.CredentialError.DataSourcePath: | |
Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"OData","path":"https://XXX.api.crm6.dynamics.com/api/data/v8.2/"}] |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
Hi @dd1234,
Which type of datasource you used?(online or on-premise) if you means online datasource with odata connection, you can use 'connection directly' mode to link datasource without setting gateway.
Please share more detail contents to help us clarify your scenario.
Troubleshooting the on-premises data gateway
In addition, please also share us detail information about datasource and credentials settings.
Regards,
Xiaoxin Sheng
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
29 | |
28 | |
23 | |
22 | |
19 |
User | Count |
---|---|
53 | |
36 | |
28 | |
24 | |
21 |