Microsoft Power BI

Connecting Power BI to AgileData.io Consume

This MagicBook outlines how to connect PowerBI to the Consume area of your AgileData.io tenancy. By following this MagicBook you will be able to use PowerBI to query and visualise the Consume data which is available to you in AgileData.io.

The data stored within AgileAdata.io is physically stored in a database called Google BigQuery. PowerBI can natively connect to the Google BigQuery database with a few simple steps. This MagicBook describes these steps.

Pre Requisites

You will need to have access to the following PowerBI components:

  • PowerBI Desktop

  • PowerBI Service

This MagicBook assumes you have already installed PowerBI Desktop. It also assumes you and have signed up for the PowerBI service and have a valid login for this service.

Connection Steps

The first step is to connect PowerBI Desktop to the AgileData.io Consume view.

The second step is to publish this connection to PowerBI service.

Connect PowerBI to AgileData.io Consume View

When you have opened PowerBI Desktop you should see the “Get Data from another source” link:

../../_images/1.png

If the add data option is not visible, using the top menu go to “File > GVet data > Get data to get started” menu option:

../../_images/2.png

Once the “Get Data” popup appears, search for “bigquery”. Then select “Google BigQuery” from the list on the right and click the “Connect” button:

../../_images/3.png

If you have not signed in previously you will be promtped with the sign in option. Click the “Sign In” button:

Once you have signed-in you will not need to do it again.

../../_images/4.png

You will be prompted for your username/email address and your password. Enter those details:

../../_images/5.png

You will be asked to confirm the connection, click the “Allow” button:

../../_images/6.png

You will receive confirmaiton you have signedin, click Connect:

../../_images/7.png

You will be shown a list of AgileData.io Tenancy’s you have access to:

../../_images/8.png

Expand your AgileData Tenancy by clicking on the “>” icon to the left of the Tenancy. Then expand the Consume area using the same icon, and you will see a list of Consume Views you have permission to access:

../../_images/9.png

Tick the selection box for the Consume View you want to connect PowerBI to. Then click the “Load” button:

MagicTip - A preview of the data in the Consume View is available on the right hand side if you click the Consume View.

../../_images/10.png

Select the “DirectQuery” option from the list of options provided and click the “ok” button:

This option means PowerBI reports will always be refreshed with the latest data from AgileData.io everytime a user accesses the PowerBI report and therefore will always be upto date.

../../_images/11.png

The fields in the Consume view are now displayed on far right:

../../_images/12.png

If you want to see the Consume view in the Power BI model screen click model icon on the left:

../../_images/13.png

You can now create a PowwerBI report based on this data, using your usual report create approach.

Publish PowerBI Connection to PowerBI Service

If you want other PowerBI report authors to be able to use this connection and create new reports based on the selected AgileData.io Consume view you will need to publish the connection to the PowerBI service.

The first thing we need to do is to login to the PowerBi Service from within the PowerBI Desktop. To do this click the “Signin” link at the top right of the s cfreen.

../../_images/14.png

A pop up screen will appear asking for your email address. This is the email address you use for Microsoft PowerBI not the one you use for AgileData.io (but they might be the same)

../../_images/15.png

Enter your email and click the “Continue” button.

A Password prompt will appear, enter your PowerBI password.

If you succesfully login you will be returned to the PowerBI Desktop screen and in the top right of the screen instead of seeing “Signin” you will see your PowerBI user name.

../../_images/16.png

Click the “Publish” option on the menu ribbon.

A pop up screen will show the PowerBI workspaces you have available to you. Select the relevant workspace you want to save this connection into and the click the “Select” button.

../../_images/17.png

You will see a message saying PowerBI is publishing.

../../_images/18.png

And then you will see a success message. Click on the “Got it” button

../../_images/19.png

You can now open PowerBI Service in your browser https://app.powerbi.com And then signin using your PowerBI email and password.

You can leave PowerBI Desktop open if you want to create another connection or close it if you have finished with it.

Click on the “Datasets” menu option on the left.

../../_images/20.png

You will see a list of connections to data that are available to you. Click on the Connection you just published from the PowerBI Desktop:

../../_images/21.png

Click on the “Create from scratch” button:

../../_images/22.png

You can now start using data in the report using your typical report creation approach..

../../_images/23.png

Frequently Asked Questions

Can we create a connection to a Consume view without using PowerBI Desktop?

No, at the present time only PowerBI Desktop is able to create a new connection to Google Big Query. But once the connection is published to the PowerBI Service then it can be used without using the PowerBI Desktop.

Do we need the Power BI Gateway to connect to our data?

???

Can I include multiple Consume Views in a single PowerBI connection?

???