Using Google Sheets as a data source in Power BI

Written by: BizOne

Blog series: Google Sheets and Power BI

Part 1:Using Google Sheets as data source in Power BI

Part 2: Structuring the data

Part 3: Connecting Power BI to Google Sheets

Part 4: Some Power BI visualizations and correlations

September 26, 2016

In this blog-post you will get some hands on tip on getting started using Power BI. We have chosen to use Google Sheets as a data source, since it gives the user a simple yet powerful interface for input of new data into your system.


This combination is probably not the solution you look for in the long run, especially if you run a slightly larger organization, but it can be a good way to quickly start measuring some Key Performance Indicators.

The example we use is a simple yet powerful KPI system for someone who wants to follow up his/her life, for example life quality, health and exercise. This simple data set actually makes it easy to do pretty interesting correlation analyses – for example: “How does the kind of food I eat affect my well-being?” and “What are the factors that affect my productivity at work?”

Further down is a short introduction to Power BI. Or if you already know enough, please move on to Part 2: Structuring the data


A very short introduction to MS Power BI

Quite recently  Microsoft Power BI has turned up as a decent Data Visualization tool on the Business Intelligence market. It might not be as powerful as Tableau or Qlikview, but it definitely has its place. Some of it’s advantages are

  • No high starting fees, just a “pay-per-user” as you go, and at 10 USD/user/month it is quite a bargain compared with high-end alternatives.
  • Ease-of-use. You don’t need to be a BI-expert to get started. Although some experience from BI development is good, most analysts should find it pretty straight forward to read data from Excel sheets or web sources and get some dashboards up and running.
  • It looks great! In just a few hours you can have good looking dashboards in your mobile or integrated on your web page for follow up.

Ok, lets get started! Next page: Part 2: Structuring the data