Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

BigQuery Connector Error: Restricted datasets causes connection failure (REST API: access denied)

When trying to connect to our BigQuery project, I am running into this problem:  DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied: Dataset p...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous

If these datasets are in a single project, you would need to grant permission on the list which is mentioned in error message.

 

We do not grant project-wide permissions to certain users; we give it on a per-dataset. We are using Google BigQuery's "Share Dataset" to help us do access control of our data. https://cloud.google.com/bigquery/docs/datasets (under "Controlling access to dataset")

 

Is it not possible to use Google BigQuery's per-dataset permission model with Power BI? Can Power BI's BigQuery connector not just ignore the datasets which you don't have permission to access?

 

 

Also I've tried your other suggestion. It seems by Table, you mean BigQuery Dataset.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

I am afraid that Power BI's BigQuery connector can't ignore the datasets which you don't have permission to access.

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous

     

    I see, is it possible to request this feature somewhere?

     

    Thanks,

    Tim