exporting data from dv360 to BigQuery

[gointeraction]

iam trying to export an offline report from dv360 to BigQuery.
I followed along the documentation which was pretty straight forward.
when trying to export a sample off line report it fails

anyone with experience that can help?

thank you

[ms4446]

There could be several reasons why you're experiencing difficulties exporting an offline report from Display & Video 360 to BigQuery. Here are a few things you might want to verify:

• Ensure that your Display & Video 360 and BigQuery accounts are properly linked. You can confirm this by adhering to the guidelines provided in the Google Support documentation: https://support.google.com/displayvideo/answer/6375151?hl=en.
• Verify that the BigQuery dataset you're attempting to export to is in place and that you possess the necessary write permissions.
• Confirm that the sample offline report you're trying to export is compatible with BigQuery. It's important to note that not all offline reports can be exported to BigQuery. 

Here are a few more troubleshooting suggestions:

• Attempt to export a different offline report. If this is successful, the issue might be with the specific report you were initially trying to export.
• Try exporting the report in a different file format. Some formats are more compatible with BigQuery than others.
• Consider exporting the report to a different BigQuery dataset. If this works, the problem might be related to the permissions on the original dataset.

[gointeraction]

Hi, thanks for the reply

I followed the steps again and it seems i did everything right
just to make sure.

there is no need to create a dedicated project for this dataset?

[ms4446]

No, there is no strict requirement to create a dedicated project for this dataset in BigQuery. You can use an existing project as long as you have the necessary permissions to create and manage datasets within that project.

However, it's often a good practice to create a dedicated project for specific tasks or workflows. This can help with organization, access control, and cost tracking, especially if you're working in a larger team or on complex projects.

[rachk]

@ms4446 wondering if you can help, I am having a similar issue and can't find any other posts or help articles about it.

I have followed all the steps to set up the link, and a colleague from the media agency who manages the account has successfully created tables in the BigQuery dataset. However when I try to build my own Offline or Instant Reports with BigQuery format, it allows me to select BigQuery as a Format but then gives an error message 'Failed to get BigQuery links. Try reopening the dialog'.

How come this is only happening to my login and my colleague can successfully create a BigQuery report?

[ms4446]

The issue you're encountering, where you receive an error message stating 'Failed to get BigQuery links. Try reopening the dialog' when attempting to create Offline or Instant Reports in BigQuery format in Display & Video 360 (DV360), suggests a problem that is specific to your user account or permissions. Given that your colleague can successfully create tables in the BigQuery dataset, we can infer that the system setup and integration between DV360 and BigQuery are generally correct. Here are several steps and considerations to help isolate and resolve your issue:

1. Check User Permissions

• DV360 Permissions: Ensure that your DV360 account has the necessary permissions to create and manage reports. There might be roles or permissions that your account lacks compared to your colleague's account. In DV360, permissions can be quite granular, affecting what you can and cannot do within the platform.

• BigQuery Permissions: Similarly, verify that your Google Cloud account has the appropriate permissions to access BigQuery and perform actions on the dataset. You should have at least BigQuery User and BigQuery Data Editor roles on the Google Cloud project to which you're trying to export data. If your role is more restrictive than that of your colleague's, it could explain the discrepancy in capabilities.

2. Browser and Connectivity Issues

Sometimes, the issue might be as simple as a browser glitch or a connectivity problem:

• Try clearing your browser's cache and cookies or use an incognito/private browsing window to see if the issue persists.

• Attempt to use a different browser altogether. Compatibility issues, although rare, can still occur.

• Check your internet connection and ensure that there are no firewall or VPN settings that might interfere with your access to Google Cloud services.

3. Project Access

• Confirm that you're trying to access the same Google Cloud project as your colleague. In some cases, users might have access to multiple projects, and a mix-up could lead to permission issues.

• Ensure that the BigQuery API is enabled for your account in the Google Cloud project you're trying to use. Even if it's enabled at the project level, individual users might encounter issues if their account settings are not properly configured.

4. Organization Policies

• In organizations, there can be domain-wide policies that restrict certain actions for specific users or groups. It's possible that an organizational policy is affecting your ability to create BigQuery reports in DV360.

• Check with your Google Workspace administrator (formerly G Suite) or your organization's IT department to see if there are any policies that might be affecting your account differently than your colleague's.

5. Contact Support

If after going through these steps, the issue remains unresolved, it would be advisable to contact Google support. Since your colleague can perform the action successfully, there's a clear discrepancy between account permissions or settings that only Google's support team might be able to diagnose and resolve effectively.