Part 4: Publish Visualizations online with 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

Some take-aways from the visualizations

There is a lot to learn from our follow up of Mr X!

(Don’t take these too seriously – this is a made up example!)

There are some very clear correlations

  • Mood gets better on days that Mr X eats higher quality food and exercises
  • The less carbs Mr X eats, the more weight loss – but at the same time his mood goes down!
  • Fun is clearly related to Productivity

The long term follow up leads to new questions

  • Mr X has made some clear progress on his weight and running – loosing 12 kg and lowering his km average more than 30 seconds. Well done!
  • Still, his mood has gone down over time. Strangely enough his stress load is down as well.
  • Does Mr X need more challenge to feel good?
  • Lots of sick days in the beginning of both 2015 and 2016 – why is that?

Would you be comfortable on getting this kind of data on Your life?

Publish the data on your web page

Just click Publish in the desktop client and then sign in to your online Power BI account. You should see the report, and also be able to put it as an iFrame on a web page!

Keeping Power BI visuals updated when data is added

To keep our visuals up to date with the latest information we have to do some configurations in Power BI online.

  1. Right click on the data set in the Power BI online interface and choose “SCHEDULE REFRESH”
  2. Go to Data Credentials. You will have to enter your Google credentials (choose Authentication method: Basic)
  3. Choose “Keep your data up to date”
  4. Apply



And that's it! We hope you enjoyed our blog series on integrating data from Google Sheets into Power BI. Contact us below if you need help with Power BI in your organization!