Forum Discussion
BigQuery Connector Error: Restricted datasets causes connection failure (REST API: access denied)
Anonymous,
If these datasets are in a single project, you would need to grant permission on the list which is mentioned in error message.
However, if you know the specific table name that you want to connect to, please add a blank query and paste the following code into Advanced Editor of the blank query, then check if you get any errors.
let
Source = GoogleBigQuery.Database(null),
#"project-data" = Source{[Name="yourprojectname"]}[Data],
table_Schema = #"project-data"{[Name="yourtable",Kind="Schema"]}[Data]
in
table_Schema
There is an example for your reference.
Regards,
Lydia
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,
I am afraid that Power BI's BigQuery connector can't ignore the datasets which you don't have permission to access.
Regards,
LydiaAnonymous
I see, is it possible to request this feature somewhere?
Thanks,
Tim