By using this site, you acknowledge that you have read and understand our Cookie policy, Privacy policy and Terms .
close

Posts and tutorials about Power BI.

rss_feed Subscribe RSS

BigQuery is Google’s serverless data warehouse in Google Cloud. Power BI can consume data from various sources including RDBMS, NoSQL, Could, Services, etc. It is also easy to get data from BigQuery in Power BI.

In this article, I am going to demonstrate how to connect to BigQuery to create visuals.

Prerequisites

Google Cloud account is required. You can register a trial account.

In BigQuery, there is a public dataset named world_bank_intl_debt in project bigquery-public-data. We are going to use table international_debt to create some visual.

The details about this table is available here: https://bigquery.cloud.google.com/table/bigquery-public-data:world_bank_intl_debt.international_debt?pli=1&tab=details

Cost of querying public data sets

Public data sets are paid by Google for storage but you need to pay for querying it.

Connect to BigQuery in Power BI

Open Power BI and create a new file.

In the Home tab and click Get Data button.

In the Database tab of the opened window, select “Google BigQuery”.

image

Click Connect button to continue.

Click Sign in button to sign into your Google Could account.

image

In the opened window, click Allow button to allow Power BI Desktop to view and manage your data in Google BigQuery:

image

Click connect button once signed in to continue.

Select the Required Data Tables

The hierarchy of BigQuery is: Project -> DataSet -> Table.

In the opened window Navigator, expand bigquery-public-data project.

image

For this tutorial, we just need international_debt table under world_bank_intl_debt dataset.

image

Click Load button to load the data.

And then you can setup Connection settings. In this case, let’s choose Import which will bring a copy of the data into Power BI.

Please note you will pay for querying the data. There are 1,359,644 records in this table. You can customize the query to only retrieve sample data to reduce the cost.

image

Once imported, the following fields are available to use:

image

Create a visual using the data imported

With the data available, we can now easily create a line chart by using field year as Axis and field value as Values.

image

You can create as many visuals as you can do with any other data sources.

image

Summary

It is very easy to consume Google BigQuery data in Power BI. You can create joins when drafting the queries or implement within Power BI.

For performance and cost consideration, you may choose to physicalise some data in BigQuery and then query the aggregated data into Power BI.

info Last modified by Raymond at 4 months ago
info About author

info License/Terms

More from Kontext

local_offer Java local_offer bigquery local_offer gcp local_offer dataflow local_offer gcs

visibility 5046
comment 0
thumb_up 1
access_time 2 years ago

This page documents the detailed steps to load CSV file from GCS into BigQuery using Dataflow to demo a simple data flow creation using Dataflow Tools for Eclipse. However it doesn’t necessarily mean this is the right use case for DataFlow. Alternatively ...

open_in_new View

local_offer Azure local_offer power-bi

visibility 1437
comment 0
thumb_up 1
access_time 2 years ago

Microsoft Azure provides a number of data analytics related products and services. It allows users to tailor the solutions to meet different requirements, for example, architecture for modern data warehouse, advanced analytics with big data or real time analytics. The following diagram sho...

open_in_new View

local_offer lite-log local_offer power-bi

visibility 226
comment 0
thumb_up 0
access_time 2 years ago

DATATABLE StaticTable1 = DATATABLE("IntCol",INTEGER,"StringCol",STRING,{{1,"User1"},{2,"User2"}}) The above expression generates a table with two columns IntCol and StringCol : ...

open_in_new View

local_offer power-bi local_offer google-analytics

visibility 2384
comment 0
thumb_up 0
access_time 2 years ago

Power BI is my favourite BI and visualization tool as it is very simple yet powerful. It doesn’t only support traditional data sources like databases, CSV, JSON, XML and etc., but also supports emerging sources that are available in HDFS, Spark, R, Salesforce, Google Analytics and cloud platforms...

open_in_new View

comment Comments (2)

comment Add comment

Please log in or register to comment. account_circle Log in person_add Register
R
Raymondarrow_drop_down

Hello,

I'm not sure whether I understand your questions correctly or not. Once your import the data using Import or Direct Query, you can then customise through Power Query Editor in Power BI:

https://docs.microsoft.com/en-us/power-query/power-query-quickstart-using-power-bi


format_quote

person Joana Barbosa access_time 6 months ago
Re: Use Google Cloud BigQuery as Data Source in Power BI

Hi,

Thank you for your post.

Do you know how to customize de query in power query?

Couldn't find it in any documentation.


Thanks.

Joana Barbosa

reply Reply
account_circle Joana Barbosa

Hi,

Thank you for your post.

Do you know how to customize de query in power query?

Couldn't find it in any documentation.


Thanks.

Joana Barbosa


reply Reply