Cannot update Google BigQuery data source credentials using the API

afernand0 — Tue, 21 Nov 2023 22:39:57 GMT

I'm trying to update credentials of a BigQuery data source using the sample code from Microsoft that's available in the link below.

I'm using a service account with basic credentials to connect to BigQuery. The username and the password works when I enter from the Power BI website. However, I get an Invalid username and password error when I enter the same credentials to the webapp that the sample python code launches.
I'm using a service principal to authenticate with the Power BI REST API and it is an admin for both gateway and connection. Much appreciated if someone could shed some light on to what's causing the issue.

Sample Code: https://github.com/microsoft/PowerBI-Developer-Samples/tree/master/Python

Error:

{'error': {'code': 'DM_GWPipeline_Gateway_InvalidConnectionCredentials', 'pbi.error': {'code': 'DM_GWPipeline_Gateway_InvalidConnectionCredentials', 'parameters': {}, 'details': [ {'code': 'DM_ErrorDetailNameCode_UnderlyingErrorCode', 'detail': {'type': 1, 'value': '-2147467259' } }, {'code': 'DM_ErrorDetailNameCode_UnderlyingErrorMessage', 'detail': {'type': 1, 'value': 'The credentials provided for the GoogleBigQuery source are invalid. (Source at GoogleBigQuery.)' } }, {'code': 'DM_ErrorDetailNameCode_UnderlyingHResult', 'detail': {'type': 1, 'value': '-2147467259' } }, {'code': 'Microsoft.Data.Mashup.CredentialError.DataSourceKind', 'detail': {'type': 1, 'value': 'GoogleBigQuery' } }, {'code': 'Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind', 'detail': {'type': 1, 'value': 'GoogleBigQuery' } }, {'code': 'Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath', 'detail': {'type': 1, 'value': 'GoogleBigQuery' } }, {'code': 'Microsoft.Data.Mashup.CredentialError.DataSourcePath', 'detail': {'type': 1, 'value': 'GoogleBigQuery' } }, {'code': 'Microsoft.Data.Mashup.CredentialError.Reason', 'detail': {'type': 1, 'value': 'AccessUnauthorized' } }, {'code': 'Microsoft.Data.Mashup.MashupSecurityException.DataSources', 'detail': {'type': 1, 'value': '[ { "kind": "GoogleBigQuery", "path": "GoogleBigQuery" } ]' } }, {'code': 'Microsoft.Data.Mashup.MashupSecurityException.Reason', 'detail': {'type': 1, 'value': 'AccessUnauthorized' } } ], 'exceptionCulprit': 1 } } }

Re: Cannot update Google BigQuery data source credentials using the API

marconiqavi — Sun, 01 Sep 2024 20:13:33 GMT

Did you fix it?

Re: Cannot update Google BigQuery data source credentials using the API

afernand0 — Mon, 02 Sep 2024 11:42:55 GMT

Yes, the sample code sends the JSON key as an f string which formats the key. Changing that to a raw string fixed the problem.

topic Re: Cannot update Google BigQuery data source credentials using the API in Developer

Cannot update Google BigQuery data source credentials using the API

Re: Cannot update Google BigQuery data source credentials using the API

Re: Cannot update Google BigQuery data source credentials using the API