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 3: Connecting Power BI to Google Sheets
Part 4: Some Power BI visualizations and correlations
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.
- Right click on the data set in the Power BI online interface and choose “SCHEDULE REFRESH”
- Go to Data Credentials. You will have to enter your Google credentials (choose Authentication method: Basic)
- Choose “Keep your data up to date”
- 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!