Error connecting PowerBi with big Query

[Anonymous]

can someone help me with this error

DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied: Project df-data-exploring-crd-prd: User does not have bigquery.jobs.create permission in project df-data-exploring-crd-prd.. DataSourceKind = GoogleBigQuery. DataSourcePath = GoogleBigQuery. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface.

[Anonymous]

Hi  @Anonymous ,

It sounds like you are encountering an error message in Power BI related to permissions for creating jobs in BigQuery. This error message suggests that the user account you are using to connect to BigQuery does not have the necessary permissions to create jobs in the project you are trying to access.

To resolve this issue, you will need to ensure that the user account has the necessary permissions. You can do this by following these steps:

1. Go to the Google Cloud Console and navigate to the project in question.
2. Click on the "IAM & Admin" tab in the left-hand navigation menu.
3. Find the user account that you are using to connect to BigQuery and click on it.
4. Ensure that the user account has the "BigQuery Job User" role assigned to it. If it does not, click the "Add" button and select the "BigQuery Job User" role from the list of available roles.

Once you have assigned the "BigQuery Job User" role to the user account, you should be able to connect to BigQuery from Power BI without encountering the "User does not have bigquery.jobs.create permission in project" error message.

Best regards.
Community Support Team_Caitlyn

[Anonymous]

Muchas gracias ya lo solucione!!

[Anonymous]

Me alegro de que hayas resuelto el problema y muchas gracias por tu comentario.