BigQuery Credential Problems when Accessing Google Sheets Federated Table

0 votes

I defined a table as a federated table which refers to a google sheet. It works perfectly well when I query it from the google bigquery web UI. However, if I try to query it using the Tableau Software BigQuery driver, I get the following error message: No suitable credentials found to access Google Drive. Contact the table owner for assistance.

A few facts about my setup:

  1. When I use the BigQuery driver in Tableau, I log in using the same user id that I use when I go into the BigQuery web UI.
  2. Queries from Tableau to a native BigQuery table work fine.
  3. I enabled the google drive api in my cloud account.
  4. The google sheet and google big query account are under the same google user.
  5. I have no problem saving a bigquery query as a google sheet under that account.
  6. I tried sharing the sheet "to anyone that has the URL" and it does not work.
Jun 5, 2018 in Tableau by ghost
• 1,790 points
77 views

1 answer to this question.

0 votes

This is something Tableau should fix. The problem is that when they send request to BigQuery, they only pass BigQuery API scope. However they should also request GoogleDrive scope.

answered Jun 5, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer

MDX query in Tableau pivot table

You can view them here - \My Documents\My ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
66 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,530 points
74 views
0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
24 views
+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 19, 2018 in Tableau by Atul
• 5,530 points
170 views
0 votes
1 answer
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,794 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
76 views
+1 vote
1 answer

Tableau tooltip incorrect when toggling through quick filter

I think your confusion is in what ...READ MORE

answered Jul 20, 2018 in Tableau by Atul
• 10,240 points
81 views
+1 vote
1 answer

How to add filter on different sheets based on clicks?

Go to Actions… (if you're on a dashboard, you ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,240 points
49 views