[{"@context":"http:\/\/schema.org\/","@type":"BlogPosting","@id":"https:\/\/wiki.edu.vn\/en\/wiki41\/microsoft-power-bi-wikipedia\/#BlogPosting","mainEntityOfPage":"https:\/\/wiki.edu.vn\/en\/wiki41\/microsoft-power-bi-wikipedia\/","headline":"Microsoft Power BI – Wikipedia","name":"Microsoft Power BI – Wikipedia","description":"before-content-x4 Business analytics service by Microsoft after-content-x4 Power BI is an interactive data visualization software product developed by Microsoft with","datePublished":"2015-06-11","dateModified":"2015-06-11","author":{"@type":"Person","@id":"https:\/\/wiki.edu.vn\/en\/wiki41\/author\/lordneo\/#Person","name":"lordneo","url":"https:\/\/wiki.edu.vn\/en\/wiki41\/author\/lordneo\/","image":{"@type":"ImageObject","@id":"https:\/\/secure.gravatar.com\/avatar\/c9645c498c9701c88b89b8537773dd7c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c9645c498c9701c88b89b8537773dd7c?s=96&d=mm&r=g","height":96,"width":96}},"publisher":{"@type":"Organization","name":"Enzyklop\u00e4die","logo":{"@type":"ImageObject","@id":"https:\/\/wiki.edu.vn\/wiki4\/wp-content\/uploads\/2023\/08\/download.jpg","url":"https:\/\/wiki.edu.vn\/wiki4\/wp-content\/uploads\/2023\/08\/download.jpg","width":600,"height":60}},"image":{"@type":"ImageObject","@id":"https:\/\/wiki.edu.vn\/wiki4\/wp-content\/uploads\/2023\/08\/download.jpg","url":"https:\/\/wiki.edu.vn\/wiki4\/wp-content\/uploads\/2023\/08\/download.jpg","width":100,"height":100},"url":"https:\/\/wiki.edu.vn\/en\/wiki41\/microsoft-power-bi-wikipedia\/","about":["Wiki"],"wordCount":4329,"articleBody":"     (adsbygoogle = window.adsbygoogle || []).push({});before-content-x4Business analytics service by Microsoft       (adsbygoogle = window.adsbygoogle || []).push({});after-content-x4Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence.[1] It is part of the Microsoft Power Platform.Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a database, webpage, or structured files such as spreadsheets, CSV, XML, and JSON.Table of Contents       (adsbygoogle = window.adsbygoogle || []).push({});after-content-x4General[edit]History[edit]Key components[edit]Licenses[edit]User licenses[edit]Workspace licenses[edit]Paginated reports[edit]See also[edit]References[edit]Further reading[edit]External links[edit]General[edit]Power BI provides cloud-based BI (business intelligence) 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.History[edit]This application was originally conceived by Thierry D’Hers and Amir Netz of the SQL Server Reporting Services Team at Microsoft.[4]  It was originally designed by Ron George in the summer of 2010 and named Project Crescent.[5]  Project Crescent was initially available for public download on 11 July 2011, bundled with SQL Server Codename Denali.[6]  Later renamed Power BI it was then unveiled by Microsoft in September 2013 as Power BI for Office 365.[7]  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 24 July 2015. It has several versions for Desktop, Web, and Mobile App, etc. [8]On 14 April 2015, Microsoft announced that they had acquired the Canadian company Datazen, to “complement Power BI, our cloud-based business analytics service, rounding out our mobile capabilities for customers who need a mobile BI solution implemented on-premises and optimized for SQL Server.”[9]  Most of the ‘visuals’ in Power BI started life as Datazen visuals.In February 2019, Gartner.com, a software reviewing company, confirmed Microsoft as Leader in the “2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platform” as a result of the capabilities of Power BI platform.[10] This represented the 12th consecutive year of recognition of Microsoft as Leading vendor in this Magic Quadrant category (beginning 3 years before this tool was even created).[11]       (adsbygoogle = window.adsbygoogle || []).push({});after-content-x4Key components[edit]Key components of the Power BI ecosystem comprise:Power BI Desktop[12]The Windows desktop-based application for PCs and desktops, primarily for designing and publishing reports to the Service.Microsoft Power BI Desktop is built for the analyst. It combines state-of-the-art interactive visualizations, with industry-leading data query and modeling .Power BI ServiceThe SaaS-based (software as a service) online service. This was formerly known as Power BI for Office 365, now referred to as PowerBI.com, or simply Power BI.Power BI Mobile AppsThe Power BI Mobile apps for Android and iOS devices, as well as for Windows phones and tablets.Power BI GatewayGateways are used to sync external data in and out of Power BI and are required for automated refreshes. In Enterprise mode, can also be used by Power Automate (previously called Flows) and PowerApps in Office 365.Power BI EmbeddedPower 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 ServerAn on-premises Power BI is reporting solution for companies that won’t or can’t store data in the cloud-based Power BI Service.Power BI PremiumCapacity-based offering that includes flexibility to publish reports broadly across an enterprise, without requiring recipients to be licensed individually per user. Greater scale and performance than shared capacity in the Power BI ServicePower BI Visuals MarketplaceA marketplace of custom visuals and R-powered visuals. You can give life to your business data and take insight from this result. [13]Power BI Dataflow[14]A Power Query implementation in the cloud that can be used for data transformations to make a common Power BI Dataset that can be made available for several report developers through Microsoft’s Common Data Service. It can be used as an alternative to for example doing transformations in SSAS, and may ensure that several report developers use data that has been transformed in a similar way.Power BI DatasetA Power BI Dataset can work as a collection of data for use in Power BI reports, and can either be connected to or imported into a Power BI Report.[15] A Dataset can be connected to and get its source data through one or more Dataflows.Power BI DatamartWithin Power BI, the Datamart is a container which combines Power BI Dataflows, Datasets and a type of data mart or data warehouse (in the form of an Azure SQL Database) into the same interface. The interface then has the possibility of being a single place for administration of both the ETL layer (Dataflow), an intermediary data mart (with for instance storage of star schemas, dimension tables, fact tables), and finally the modelling layer (Dataset).Power BI DatahubA data hub for discovering Power BI datasets within an organization’s Power BI Service so that datasets may be reused from one central location.It offers details on the things as well as an access point for working with them, such as building reports on top of them, utilizing them with Excel’s Analyze feature, accessing settings, controlling permissions, and more.[16]Licenses[edit]Power BI has many different licenses depending on use.User licenses[edit]Some common user licenses are Free, Pro and Premium. Free users must be part of an organisation with a Power BI license. They can consume reports, and can also build, but not publish. In practice, creators need at least a Pro in order to publish reports. Premium users can publish like Pro, but also have more features available for developing.Workspace licenses[edit]Premium capacity refers to the license of the workspace, not the licenses of its users or creators. Also, access to several features, functionalities, and kinds of content that are exclusively accessible through Premium is made possible with a Power BI Premium per user license.[17]Premium per user is a special workspace license which was added in 2020 November,[18] and can be a more affordable alternative to Premium workspace licenses for organisations with few users which have advanced analytical requirements.[18]Paginated reports[edit]Paginated reports for Power BI, which can be built with Power BI Report Builder, are a special type of SSRS reports with pagination formatting which can give better control of the layout of reports which need to be printed to paper or pdf. This is in contrast to regular Power BI reports which instead are optimized for presentation or interactivity and exploration on a screen. Paginated reports can currently as of 2022 not be made with the regular Power BI Desktop report builder software. Instead, the standalone Power BI Report Builder has to be used, which can be viewed as a descendant of the SQL Server Reporting Services (SSRS) Microsoft Report Builder for Microsoft SQL Server introduced in 2004. It is also similar to the Report Designer in SQL Server Data Tools.Power BI Paginated reports are saved in the Report Definition Language (.rdl file format), as opposed to the .pbix file of regular Power BI reports. The RDL format is based on XML, and was proposed by Microsoft as a benchmark for defining reports with SSRSSome example use cases where currently as of 2022 paginated reports may be more suitable than regular Power BI reports may include printing of invoices or other repeated printouts of reports with similar layout but different content, or for printing reports where text would otherwise overflow due to being cut off by scrollbars.See also[edit]References[edit][19]Further reading[edit]External links[edit]^ “Bring your data to life with Microsoft Power BI”. Microsoft.com. Microsoft. Retrieved 4 May 2016.^ a b “Magic Quadrant for Business Intelligence and Analytics Platforms”. Gartner.com. Gartner, Inc. Retrieved 4 May 2016.^ Caldwell, Nick (31 March 2016). “Embed the wow of Power BI in your applications with Microsoft Power BI Embedded!”. Powerbi.microsoft.com. Microsoft. Retrieved 4 May 2016.^ “A Glimpse at Project Crescent”. Microsoft BI Blog. Microsoft. Retrieved 29 June 2017.^ “Data Visualization Done Right: Project Crescent”. Microsoft BI Blog. Microsoft. Retrieved 29 June 2017.^ Unkroth, Kay. “Announcing Microsoft SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3)”. blogs.msdn.microsoft.com. Microsoft. Retrieved 28 May 2019.^ “Office 365 Gets Colorful 3D Charts, Natural Language Search”. PC Mag India. ZiffDavis, LLC PCMag India. 26 September 2013. Retrieved 4 May 2016.^ The Power BI Team, Microsoft (10 July 2015). “Announcing Power BI general availability coming July 24th”. Microsoft Power BI Blog. Microsoft. Retrieved 4 May 2016.^ Hathi, Kamal (14 April 2015). “Microsoft acquires mobile business intelligence leader Datazen”. blogs.microsoft.com. Microsoft, Inc. Retrieved 10 January 2022.^ Research, Gartner (11 February 2019). “2019 Magic Quadrant for Analytics and Business Intelligence Platforms”. Gartner.com. Gartner, Inc. Retrieved 11 February 2019.^ “Microsoft announces the 2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms”. microsoft.com. Microsoft, Inc. Retrieved 11 February 2019.^ Hyman, Jack (8 February 2022). Microsoft Power BI for dummies. NJ: wiley. pp.\u00a047\u201362. ISBN\u00a0978-1-119-82487-9.^ “Power BI Custom visuals on AppSource”. Microsoft AppSource. Microsoft. 25 December 2017. Retrieved 25 December 2017.^ Creating a dataflow – Power BI | Microsoft Docs^ Get started, Power BI (3 October 2022). “Basic concepts for designers in the Power BI service”. Retrieved 4 April 2022.^ paulinbar. “Data discovery using the data hub – Power BI”. learn.microsoft.com. Retrieved 11 March 2023.^ kfollis. “Power BI service features by license type – Power BI”. learn.microsoft.com. Retrieved 27 November 2022.^ a b Meet Power BI Premium per user element61^ How Power BI works for Cloud Computing     (adsbygoogle = window.adsbygoogle || []).push({});after-content-x4"},{"@context":"http:\/\/schema.org\/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"item":{"@id":"https:\/\/wiki.edu.vn\/en\/wiki41\/#breadcrumbitem","name":"Enzyklop\u00e4die"}},{"@type":"ListItem","position":2,"item":{"@id":"https:\/\/wiki.edu.vn\/en\/wiki41\/microsoft-power-bi-wikipedia\/#breadcrumbitem","name":"Microsoft Power BI – Wikipedia"}}]}]