ISSUE WITH BIGQUERY PERMISSIONS FOR UNKNOWN AND NOT IN USE DATASET

[rodsbertuzzi]

Hello there, we're experiencing an issue with Google BogQuery when updating our own data. As you can see bellow, the error message is "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied: Project sys-30023166621631391667486733: User does not have bigquery.jobs.create permission in project sys-30023166621631391667486733.. '."

We doesn't know what are the projects initiated to "sys-..." and we doesn't use that table on our pbi project.

Anyone has a clue?

[v-mengzhu-msft]

Hi @rodsbertuzzi ,

From the error message you provided, the problem should be that there is a problem with the item I drew the line for, and it looks as if it doesn't have permission. You need to make sure that you have sufficient access to it.

In addition, I found a post with a similar question, I hope it can help you further with your question.

Access Denied: User does not have bigquery.jobs.create permission - Stack Overflow

Solved: Failed to save modifications to the server. Error ... - Microsoft Power BI Community

Best regards,

Community Support Team Selina zhu