Power Platform – Power BI for beginners. Exploring Power BI Service. Creating simple chart application / Demo

Hi All,

LIFE IS BEAUTIFUL 🙂 With Power BI its more FUN 🙂

In following articles we discussed Introduction to Power BI, Power BI Desktop. We also tried one small demo, prepared chart for my Teams / SharePoint sites in my Tenant.

Today we will discuss another part of Power BI “Power BI Service”.

What is Power BI Service :

Power Platform - Power BI Service - Home Page
Fig1: Power Platform – Power BI Service – Home Page
  • Power BI service contains dashboards which displays tiles which opens further to show reports

Creating a report – Lets create one simple report, lets have a FUN 🙂

Use Case: Lets have one real life scenario – Our Office 365 Administrator wants to know how many users are unlicensed and what are the other users license. This is pretty simple use case. We can directly download from users section as

Power Platform - Power BI Service - Exporting users
Fig2: Power Platform – Power BI Service – Exporting users

But if my organization having large number users and my admin need to track and present to management then showing in excel is not intuitive. So again I choose the option “Power BI” and having a fun 🙂

Following are the detailed steps:

  • Get the Data : Here we will get the data from users CSV file which we exported as shown in below Fig3. We have “Get data” option in nav pane at the bottom as shown in Fig4.
Power Platform - Power BI Service - Exported Users
Fig3: Power Platform – Power BI Service – Exported Users
Power Platform - Power BI Service - Creating new report - Get data - Connecting to Data
Fig4: Power Platform – Power BI Service – Creating new report – Get data
  • Click on “Get data” link, we will be redirected to the page where we have multiple options to create our own content / to create the new datasets as
Power Platform - Power BI Service - Creating new report - Creating new content / Creating new datasets / getting existing data sets - getdata page
Fig5: Power Platform – Power BI Service – Creating new report – Creating new content / Creating new datasets / getting existing data sets – getdata page
  • Here please observe the URLs in address bar for every step. How they are changing.
  • Here, we need to get the data from our Users CSV file, so we will use “Files” option under “Create new content” section.
  • Click on “Get” button from “Files” tile under “Create new content” section. We will be redirected to “Files” pane as
 Power Platform - Power BI Service - Creating new report - Creating new content / Creating new datasets - Loading content from existing CSV file
Fig6: Power Platform – Power BI Service – Creating new report – Creating new content / Creating new datasets – Loading content from existing CSV file
  • We have various options to load the file, this is really very nice :). For now we will get the file from local drive so we will click on “Local File” tile.
  • As we click on “Local File” task “File Upload” dialog will open to get the file from local system
  • Select the file from which we need to load the data, once data loaded successfully, we will get redirected to dashboards page as
Power Platform - Power BI Service - Creating new report - Loaded the data from existing CSV  file
Fig7: Power Platform – Power BI Service — Dashboard – Creating new report – Loaded the data from existing CSV file
  • As we have data ready, we are ready to create the report.
  • From the right top corner click on “+ Create” button as shown in above Fig7
  • Once we click on “+Create” report, pop up will appear with various options as
Power Platform - Power BI Service -- Dashboard - Selecting "Report" option for creating new Report
Fig7: Power Platform – Power BI Service — Dashboard – Selecting “Report” option for creating new Report
  • As we click on “Report” option, select the
Power Platform - Power BI Service - Dashboard - Selecting data set to create the report
Fig8: Power Platform – Power BI Service — Dashboard – Selecting data set to create the report
  • Once we selected the data set, dataset page opens, where from “Visualizations” pane we could add any chart and explore.
  • Here we will select “Stacked column chart” and Axis as “Licenses” as shown in below Fig9.
Power Platform - Power BI Service - Report - Showing licenses and there count
Fig9: Power Platform – Power BI Service – Report – Showing user licenses and there count

isn’t so easy and intuitive. We can try various other options from “Visualizations” pane. We will discuss some of those here and will have more FUN 🙂

Stay tuned with Knowledge Junction and having FUN with technology, njoying LIFE journey. HAVE A FANTASTIC LIFE AHEAD 🙂

Advertisements

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.