Power BI

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
Microsoft Power BI 2016
Power bi logo black.svg
Developer(s) Microsoft
Operating system Microsoft Windows
Type Data mining, business intelligence
Website powerbi.microsoft.com/en-us/

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.[1]


Power BI provides cloud-based BI services, known as "Power BI Services", along with a desktop based interface, called "Power BI Desktop". It offers data warehouse capabilities including data preparation, data discovery and interactive dashboards.[2] In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform.[3] One main differentiator of the product is the ability to load custom visualizations.[4][5]


This application was originally conceived by Dhers and Amir Netz of the SQL Server Reporting Services Team at Microsoft.[6] It was originally designed by Ron George in the summer of 2010 and named Project Crescent.[7] Project Crescent was initially available for public download on July 11, 2011 bundled with SQL Server Codename Denali.[8] Later renamed to Power BI it was then unveiled by Microsoft in September 2013 as Power BI for Office 365.[9] The first release of Power BI was based on the Microsoft Excel–based add-ins: Power Query, Power Pivot and Power View. With time, Microsoft also added many additional features like Question and Answers, enterprise level data connectivity and security options via Power BI Gateways.[2] Power BI was first released to the general public on July 24, 2015.[10]

Key components[edit]

Key components of the Power BI ecosystem comprises:

Power BI Desktop 
The Windows-desktop-based application for PCs and desktops.
Power BI (Service) 
The SaaS (software as a service) based online service (formerly known as Power BI for Office 365, now referred to as PowerBI.com or simply Power BI).
Power BI Mobile Apps 
The Power BI Mobile apps for Android and iOS devices, as well as for Windows phones and tablets.
Power BI Gateways 
Gateways used to sync external data in and out of Power BI.
Power BI Embedded 
Power BI REST API can be used to build dashboards and reports into the custom applications that serves Power BI users, as well as non-Power BI users.
Power BI Report Server 
Provides a localized way for storing and managing Power BI reports.
Power BI Visuals Marketplace 
A marketplace of custom visuals and R-powered visuals.[11]

See also[edit]


  1. ^ "Bring your data to life with Microsoft Power BI". Microsoft.com. Microsoft. Retrieved 4 May 2016. 
  2. ^ a b "Magic Quadrant for Business Intelligence and Analytics Platforms". Gartner.com. Gartner, Inc. Retrieved 4 May 2016. 
  3. ^ "Embed the wow of Power BI in your applications with Microsoft Power BI Embedded!". Powerbi.microsoft.com. Microsoft. Retrieved 4 May 2016. 
  4. ^ "dataviz.boutique | datadriven.pro - BUSINESS INTELLIGENCE, DATENVISUALISIERUNG, ADVANCED ANALYTICS, DATA WAREHOUSE & PERFORMANCE MANAGEMENT by Klaus Birringer". dataviz.boutique | datadriven.pro (in German). Retrieved 2017-04-24. 
  5. ^ "OKViz (The Good Visuals for Power BI)". okviz.com. Retrieved 2017-04-24. 
  6. ^ "A Glimpse at Project Crescent". Microsoft BI Blog. Microsoft. Retrieved 29 June 2017. 
  7. ^ "Data Visualization Done Right: Project Crescent". Microsoft BI Blog. Microsoft. Retrieved 29 June 2017. 
  8. ^ "SQL Server codename "Denali" CTP3, including Project "Crescent" is now publicly available". Microsoft BI Blog. Microsoft. Retrieved 29 June 2017. 
  9. ^ "Office 365 Gets Colorful 3D Charts, Natural Language Search". PC Mag India. ZiffDavis, LLC PCMag India. Retrieved 4 May 2016. 
  10. ^ "Announcing Power BI general availability coming July 24th". Microsoft Power BI Blog. Microsoft. Retrieved 4 May 2016. 
  11. ^ "Power BI Custom visuals on AppSource". Microsoft AppSource. Microsoft. Retrieved 25 December 2017.