英文:
The Google BigQuery service has denied access for this request. Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials
问题
我试图将两个 BigQuery 表连接到 Tableau，但我收到以下错误消息：
> Google BigQuery 服务拒绝了此请求的访问权限。
访问被拒绝：BigQuery BigQuery：获取驱动凭据时被拒绝了权限。
在 BigQuery 中，一个表从位于 GoogleDrive 上的 GoogleSheet 接收数据。另一个表是常规的 BigQuery 表。我在查询中将它们连接，因为我需要来自两者的数据。
我是 Google Sheet 和 BigQuery 数据集（以及 BigQuery 项目）的所有者。
这可能的原因是什么？需要授予什么权限，以便 Tableau 接受从 BigQuery 表中提取数据的表中的数据？
英文:
I am trying to connect two BigQuery tables to Tableau but I receive the following error:
> The Google BigQuery service has denied access for this request.
Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.
In BigQuery, one table receives data from the GoogleSheet that is located on GoogleDrive. Another table is a regular BigQuery table. I join them within a query as I need the data from both.
I am the owner of the Google Sheet and BigQuery dataset (as well as BigQuery project).
What can be the reason for this? What permission needs to be granted, so Tableau accepts the data from the BigQuery table that pulls the numbers from Google Sheets?
答案1
得分: 1
这个问题已经由Tableau发布，在这里。
如果你遇到这个错误，
Google BigQuery 服务拒绝了这个请求。错误代码：015CFBE6
拒绝访问：BigQuery BigQuery：
在获取驱动凭证时被拒绝许可。
您可以通过安排查询以运行并将（每日）数据存储在BigQuery中的视图中来解决这个问题，然后您可以连接Tableau到这个新的数据源，即视图。由于查询是由BigQuery运行的，Tableau不需要访问您的驱动器。
英文:
This issue has been published by Tableau here.
If you're facing the error,
> The Google BigQuery service has denied access for
> this request. Error Code: 015CFBE6
> Access Denied: BigQuery BigQuery:
> Permission denied while getting Drive credentials.
you will be able to resolve the issue by scheduling your query to run and store the (daily) data in a BigQuery in a view, you can then connect Tableau to that new source ie.the view. As the query is being run by BigQuery, Tableau won't need to access your drive.
答案2
得分: 0
Tableau使用哪些凭据？
a) 个人凭据
b) 服务账户凭据
-
如果是a)，请确保您对两者都有适当的访问权限。我不完全了解在与BigQuery建立连接时Tableau请求的权限是什么。但很可能它只会请求BigQuery的范围。
-
如果是这种情况，您可以尝试通过一个可以访问两者的服务账户来建立连接。确保它能访问您的表和工作表。
如果都不起作用，您可以从工作表创建一个BQ本机查询。然后，您的Tableau查询将引用该查询，而不是“drive”表。
只需按计划查询中的示例执行操作。
CREATE OR REPLACE mydataset.myDriveTableBQNative
AS
SELECT * FROM mydataset.myDriveTable
如果您需要数据更实时，您还可以研究更多的事件驱动推送，以在工作表更改时触发（appscript）。
英文:
What credentials is Tableau using?
a) Personal credentials
b) Service Account credentials
-
If a), then double-check that you have proper access to both. I am not fully aware of what permissions Tableau requests when you establish a connection with BigQuery. But it is likely that it only asks for the BigQuery scope.
-
If that's the case you could try establishing a connection via a service account that has access to both. Make sure it has access to your table as well as your sheet.
If none work, you could create a BQ native query from the sheet. Your Tableau query would then reference that instead of the "drive" table.
Simply use something like in scheduled queries.
CREATE OR REPLACE mydataset.myDriveTableBQNative
AS
SELECT * FROM mydataset.myDriveTable
If you need your data to be more real-time you could also look into more event-driven push on sheet change (appscript).
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论