Forum Discussion

clark_hsu's avatar
clark_hsu
Regular Visitor
8 years ago
Solved

Error Interacting with REST API while connecting to Google BigQuery

While connecting to Google BigQuery, I am getting the following error: DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied: Dataset projectname...
  • Anonymous's avatar
    Anonymous
    8 years ago

    clark_hsu,

    I don't think that Power BI can bypass the permissions.

    Regards,
    Lydia

clark_hsu's avatar
clark_hsu
Regular Visitor
8 years ago

I have worked with the admin to check further details.

Apparently, the some datasets within the project have customized permission rights that could not be overwritten at the project editor level.

 

Is there a way for PowerBI to simply bypass the datasets without permissions and just list those with?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

clark_hsu,

I don't think that Power BI can bypass the permissions.

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, 

     

    i had the same problem and just realised that if you rename the view wothout spaces it fixes the issue. 

     

    i.e.

    view from this table

    view_from_this_table