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

Anonymous

 

Thanks for replying. I have checked with the admin and we've upgraded my access to dataEditor.

However, PowerBI would still produce the same error.

 

I have tried revoking GCP to PowerBI access and re-establishing the connection; yet the same result occurred.

 

At this moment, I am not able to further pinpoint the source issue; however, I do not believe it lies with access control.

As mentioned previously, with the same access rights, I had no problem connecting through Data Studio and Tableau.

 

 

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