In Power BI Desktop, you can connect to a Google BigQuery database and use the underlying data just like any other data source in Power BI Desktop.

Check my blog on how to connect Google Bigquery using Power BI Desktop.

Recently I came across this error below while trying to connect to Google Bigquery table using Power BI desktop. The error stated that the Bigquery project exceeded quota for free query bytes but there was no such configuration done on the project.

The error occurred because it was pointing to a NON-BILLING project by default. So the solution is to point it to any BILLING project in your Google Bigquery environment.

Below are the steps to point a Billing Project instead of default:

Go to Home – Edit Queries

You will be viewing screen with error message.

Next, go to Source under Applied Steps

Update Address Bar with following M query:

= GoogleBigQuery.Database([BillingProject="Include-Billing-Project-Id-Here"])

Replace <Include-Billing-Project-Id-Here> with any BILLING Project in your Google Bigquery environment.

Press ENTER

Select your Dataset and then your table again.

It will now display the data without any error.

Useful Links :

Power BI Desktop and Google Bigquery