Error in Power BI Service when using a service account to connect to Google BigQuery

[robertobrsp]

Good morning everyone,

I'm encountering an issue while attempting to establish a connection to Google BigQuery in Power BI Services. I have a Google BigQuery account with a service account and its JSON key. When in the Desktop environment, I can configure the connection seamlessly by inputting the account and the JSON key. However, when I try to configure the same connection in Power BI Services to enable scheduled updates, I encounter an error. It appears that Power BI Services might not support service accounts for Google BigQuery. Has anyone else faced this situation and could offer assistance?

Thank you very much

Erro de fonte de dados: [ValidateMarkupTags][ccon]Expression.Error: The key does not match any rows in the table.. Key = [ccon][Name = "dataledge"][/ccon]. Tabela = [ccon]#table({"Nome", "Descrição", "Dados", "Tipo", "NomeDisplay"}, {})[/ccon]. [/ccon];[ccon]A chave não corresponde a nenhuma linha da tabela.[/ccon]. A exceção foi gerada pela interface IDbCommand. Tabela: nfse_v1.
URI do cluster: WABI-BRAZIL-SOUTH-redirect.análise.windows.net
ID da atividade: 40d100a1-a864-4385-b6ed-40791d049b65
Solicitar ID: 7640aeba-1717-a769-adc2-25a8fcd9b733
Hora: 16/10/2023 11: 52:07Z

[Pover]

Hello, I'm having the same issue. Did the tenant setting fix the issue or was it something else?

Thanks, Karl

[v-tianyich-msft]

Hi @robertobrsp ,

Based on your description, I'm wondering that you don't have the feature turned on within your tenant:

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[robertobrsp]

Hello, thank you very much for getting back to me. How can I activate this feature?

[SaiTejaTalasila]

Hi @robertobrsp ,

You need to enable it in Admin portal section of power bi service.If you are normal user then you can check with your tenant admin.

https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery-aad

Thanks,

Sai Teja