Skip to main content

Power BI Blog - What is Power BI and Why we use Power BI.

This Power BI blog is an introduction to the Power BI. In this Power BI tutorial, you will learn Power BI basics - what is Power BI, Power BI Desktop and Power BI Service. Power BI tool is a combination of Business Intelligence and Visualization. Before we dig deep let’s understand what is Business Intelligence. Business Intelligence is a broad spectrum which consists of using different business strategies and techniques to gather data, refine it and process it for the purpose of data analysis which gives us some meaningful information which helps in data driven decision making. When we present this information in the form of some charts, graphs it takes the form of Visualization.

So, Power BI is a Business Intelligence tool which helps us to get data from different sources, provides functionality with which we can easily transform (ETL) it and use some techniques, functions to take out some meaningful information from the data inserted into Power BI and which can be easily presented into some graphs or charts for better understanding with the help of various in-built Power BI visualizations.

Power BI Parts:

Power BI Parts
Fig 1. Power BI Parts

Let’s get an understanding of what each part is.

Power BI Desktop:

Power BI Desktop
Fig 2. Power BI Desktop

This is the foremost tool to develop all kinds of Power BI reports and Power BI visualisations. In this tool we connect Power BI Desktop from data sources, merge different data sources (if the organization stores data separately as per their requirement), transform the data and make a data model.

Power BI Desktop make use of Power Query Engine which helps to transform the data. All the transformations that Power BI Desktop let us do graphically is done using Power Query Formula Language called M. So, all the data transformation is done using scripting language M behind the scenes and we can use M for any transformation that cannot be done graphically.

After we make the Power BI data model, we use DAX (Data Analysis Expression) functions to do data analysis on the data imported. Once the required measures, columns or calculated columns are created, all these calculations can then be represented using Power BI Visuals.

So, Power BI Desktop is the most important part of the Power BI, where we import data, merge it if required, transform it using M, helps to do analysis using DAX and present the calculations as Power BI Visuals.

Power BI Service:

Power BI Service
Fig 3. Power BI Service

Power BI Service also referred to as Power BI Online is the SaaS (Software as a Service) part of Power BI. Once we are done with creating the report or visuals in Power BI Desktop, we can then publish that report to Power BI Service ( Users can login to Power BI Service and view the reports that is published to it using Power BI Desktop.

It is not just used for viewing reports but you can create dashboards using visuals from different reports which will work as an overview of all the reports. Power BI Service is also used to create reports, but data modelling feature is not available in Power BI Service.

Power BI Mobile Apps:

Power BI Mobile Apps on Android, iOS and Windows platform, helps users view, monitor and interact with Power BI reports through Mobile Devices using Power BI Mobile Apps anywhere and anytime.

Power BI Report Server:

Power BI Report Server, lets you create reports and keep them on-premises rather than on-cloud (Though you can migrate them on-cloud). You can access Power BI Report Server using a secure Web Portal, where you can create Power BI Reports, Mobile Reports KPIs, Paginated Reports (Scrollable Reports with multiple pages like in Crystal Reports or SQL Server Reporting Services) using Report Builder.

You need to download and install Power BI Desktop optimized for Report Server. When you publish the report using this version of Power BI Desktop it will be published to Power BI Report Server rather than Power BI Service. Though you can use Power BI Report Server web portal to upload the Power BI Reports (pbix files) created using Power BI Desktop. With Power BI Report Server, you can create (as in SQL Server Reporting Services) and host reports (as in Power BI Service).

Power BI Data Sources:

Power BI supports many different data sources from where you can fetch the data, merge it and transform it, make measures and calculations and present them with Power BI Visuals. Here is the list of some of the data sources (including Big Data Sources) that Power BI supports. Access Database, Amazon RedShift, Azure Analysis Services, Azure Blob Storage, Azure SQL Database, Azure SQL Data Warehouse, Azure HDInsight (HDFS), Excel, File, Folder, Facebook, GitHub, Google Analytics, Hadoop, IBM DB2, Impala, JSON, MailChimp, MySQL, OData, ODBC, Oracle, OleDb, PDF, PostgreSQL, Power BI DataFlows, Python Script, R Script, SalesForce Objects, SAP HANA, SnowFlake, Spark, SQL Server, SQL Server Analysis, Sybase, Teradata, Web, XML(Source: Microsoft).  

This is a brief introduction of what is Power BI and its parts. Why we use Power BI Desktop and Power BI Report Server and what we do with Power BI Service and Power BI Mobile Apps. In the continuation of this blog we will work on an example from a sample database to look at how we can create visuals and customize them.

About Amlgo Labs : Amlgo Labs is an advanced data analytics and decision sciences company based out in Gurgaon and Bangalore, India. We help our clients in different areas of data solutions includes design/development of end to end solutions (Cloud, Big Data, UI/UX, Data Engineering, Advanced Analytics and Data Sciences) with a focus on improving businesses and providing insights to make intelligent data-driven decisions across verticals. We have another vertical of business that we call - Financial Regulatory Reporting for (MASAPRAHKMAEBAFEDRBI etc) all major regulators in the world and our team is specialized in commonly used regulatory tools across the globe (AxiomSL Controller ViewOneSumX DevelopmentMoody’s RiskIBM Open Pages etc).We build innovative concepts and then solutions to give an extra edge to the business outcomes and help to visualize and execute effective decision strategies. We are among top 10 Data Analytics Start-ups in India, 2019 and 2020.

Please feel free to comment or share your views and thoughts. You can always reach out to us by sending an email at or filling a contact form at the end of the page.


  1. I see all the pictures you mentioned on your blog. And that really impressed me. You have great knowledge of this. Please share more information with us.
    Power BI Consultants Sydney

  2. Remarkable post. I simply came across your blog and desired to say that I have really enjoyed searching your blog posts. Thank you for sharing such blogs. Philippines Import Customs Data

  3. Great job for publishing such a nice article. Your article isn’t only useful but it is additionally really informative. Thank you because you have been willing to share information with us. Power Bi Consulting services

  4. I feel Power BI is the most useful and resource full tool that can easily take up more and more complex database operations and solutions and possibly recommend a simpler version of this.

    Powerbi Read Rest


  5. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating and read more Cloud Bi Solutions


Post a Comment

More Popular Posts

Amlgo Blog - Experience The Experiments

Amlgo Labs Blog  is a step towards our vision to share knowledge and experiences, Amlgoites accept every challenge very enthusiastically. We do experiments, we fail but we learn and build complex solutions to help our clients solve their problems in Data, Analytics, Prediction, Forecasting, Reporting, Designing and Development area. During this process we enjoy immense learning everyday and we have decided to share our thoughts, learnings, experiments and experiences so that we don't work in silos and contribute the best of our knowledge towards community and learn more by views and reviews. This website is maintained and brough to you by  Amlgo Labs Professionals .   Our Strong Basics -  1)   KISS (Keep It Simple and Straightforward) :  We believe most of the problems can be solved by keeping things simple and straight. This is the learning we had in past, sometimes we try to solve technical problems using high end algorithms and complex codes but this results into complications.

Power BI Card Visual With Conditional Formatting

In this blog we will take you through the Power BI Card Visual and a workaround to present card with conditional formatting. To know more about what is Power BI please do check Power BI Blog . The conditional formatting, we do will not be on the Card Visual, but the output will certainly look like Card, which is a requirement in some cases. Many Power BI users have used Card Visual to represent some value on the Power BI Reports separately or on above of any other visual, but sometimes clients ask which is deemed difficult to achieve, but not impossible. So, let’s dive into the practical to know more about it.

A simplified view of a QlikView tool:

In our last blog related to Qlikview, we discussed the use of Qlikview for Financial Data Analytics . Qlikview is a Business Intelligence tool that consists of a front end to visualize the processed data and a back end to provide the security and publication of the mechanism for QlikView user documents.

Polybase Installation for Scale-Out process

This part is the continuation of the previous blog about the introduction of  Polybase Scale-Out Group . As we have discussed in our earlier blog PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, PolyBase can be used to access external data in SQL Server, Oracle, Teradata, and MongoDB.

JavaScript: The Important Basics

In this weird world of technology people often get confused how does a website work? What all things should I be aware of? So we are here to help you. Most of the content on web is developed with the help of JavaScript. JavaScript is really becoming popular these days with the coming of ECMAScript2015 and ECMAScript 2016, for this reason, some beginners learning React and Angular and are also trying to tackle more modern JavaScript syntax at the same time. If you're new to both, it can be confusing as to "what is JavaScript and what are its important features". This document should serve as a primer to help you get up-to-speed on JavaScript syntax that we feel matters the most for learning React as well as Angular.

How to Connect Windows with Ansible?

Hello Techies, this blog is the continuation of the last blog Install Ansible on Windows which is the second part of the series Ansible with Windows . Before you proceed, I recommend you to please take a look at the introductory blog of this series so to have an understanding of this series.