Data Studio reports from BigQuery fail

Problem

As described in Analyze data with Looker Studio, Data Studio reports from BigQuery are failing with the following error message even though Billing is enabled on the project with the targeted datasets: 

Quota exceeded: Your project exceeded quota for free query bytes scanned. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors

Environment

  • Data Studio
  • BigQuery

Solution

Confirm that the Billing Project selected in the Data Studio configuration has Billing enabled and enable it if it's not.

Cause

When setting up the connection from BigQuery to Data Studio the project chosen as the Billing Project in Data Studio doesn't have Billing enabled. This project is different from the one that holds the dataset(s).