LPU Cavite Tech Day – Data Visualizations with Power BI

Eventbrite URL: https://www.eventbrite.com/e/data-visualization-using-power-bi-tickets-38712899324

Eto na ata an pinaka fulfilling workshop na nagawa ko sa talambuhay ko. I taught them the basics and then gave them space for creativity, binigyan ko sila ng mapapagkunan ng data na gusto nilang paglaruan, and then Boom !! ayan! nakagawa sila ng sarili nilang PowerBI Reports. Nung nag lalaboy laboy ako sa room, madami akong nakikita mga makukulay at mga nagtangkang gumamit ng custom visuals. I’m quite sure that they were able to publish it on their free PowerBI Account. Pero etong tatlo lang ang brave enough to share they discoveries with the class.

Number of High-school Provincial Enrollment by Gender from Chriselle Molar:

Imports of the Department of Health from Daryl Nicolas:

Philippine Provincial Election Results of 2016 from some random computer science student:

Not bad for students with zero knowledge on Business Intelligence and the Context of the Data. I enjoyed their report and given them a little something in return for sharing what they’ve learned form that day. I’ll try to add a few posts regarding on how they could further improve their PowerBI Reports so stay tuned.

I would like to commend the efforts of those people behind the Open Data Philippines more power to you guys and hopefully more updated data para mas happy kaming mga data professionals.

Connecting PowerBI on Office365 to OneDrive for Business

User Story

First of all I would like to give a special thanks to Programmers, Developers for letting me use one of their accounts for PowerBI Publishing and saving data source in their OneDrive for Business.

I made this in response to a question during my talk on Usapag Ulap on Azure last January 21, 2017. It was an impromptu question regarding connecting to OneDrive for Business but I guess you can also use this to connect to OneDrive Personal. I see this question worthy of a blog post because you can create an excel survey and visualize the survey results using PowerBI, and schedule the dataset refresh so that the results will be updated every now and then.

Getting Started

• This blogpost assumes that you attended Usapang Ulap.
• Hence you know how we connected to OneDrive for Business
• Hence you know that our Report has Open and Closed Issues
• Hence you know that we tried to verify that the report is refreshing by changing the Closed items into Open Items.

Getting Things Done

1. After creating your PowerBI Report (with the source file pointed on the OneDrive for business) and publishing it to office 365. You will encounter this error: “The credential stored in the cloud is missing.”

    

   

   The dreaded credential error.

   This error means that PowerBI could not connect to OneDrive for Business because it cannot use the credentials you supplied on PowerBI Desktop because these credentials stays on the computer.

1. In order to correct this, Click the ellipsis on the right of your PowerBI Dataset name. and click Schedule Refresh

   
   

2. You will be brought to a page where you can change the settings for your dataset, expand the Data Source Credentials and click Edit Credentials.

   

3. You will be prompted to configure the authentication method of the data source, on the dropdown menu choose OAuth2 and click the Sign In button.

   

4. An Office365 sign in page will pop up, choose the account that you use to sign in to OneDrive for Business login with it.

   

5. A pop up on the top right corner of the screen will verify that you’re successful with the configuration.

   

6. You may now proceed to refreshing your dataset.

   Before Refresh:

   
   

   After Refresh: