What Is BI
What Is BI
What Is BI
Different Power BI versions like Desktop, Service-based (SaaS), and mobile Power
BI apps are used for different platforms. It provides multiple software connectors and
services for business intelligence.
Power BI Desktop
Power BI desktop is the primary authoring and publishing tool for Power BI.
Developers and power users use it to create brand new models and reports from
scratch.
Costs: Free
Power BI service
Online Software as a Service (SaaS) where Powe Bl data models, reports, dashboards
are hosted. Administration, sharing, collaboration happens in the cloud.
Power BI Data Gateway works as the bridge between the Power Bl Service and on-
premise data sources like DirectQuery, Import, Live Query. It is Installed by Bl
Admin.
It can host paginated reports, KPIs, mobile reports, & Power Bl Desktop reports. It is
updated every 4 months and installed/managed by the IT team. The users can modify
Power Bl reports other reports created by the development team.
Power BI mobile app is available for iOS, Android, Windows. It can be managed
using Microsoft Intune. You can use this tool to view reports and dashboards on the
Power Bl Service Report Server.
Architecture of Power BI
There are Power BI components are 5 main components released in the market.
Power Query: It can be used to search, access, and transform public and/ or internal data
sources.
Power Pivot: It is used for data modeling for in-memory analytics.
Power View: This component allows you to visualize, analyze, and display data.
Power Map: It brings data to life with interactive geographical visualization.
Power BI Service: It allows you to share data views and workbooks, which you can refresh
from on-premises and cloud-based data sources.
Power BI Q&A: It allows you to ask questions and get immediate answers using a natural
language query.
Data Management Gateway: It offers periodic data refreshers, view data feeds, expose
tables.
Data Catalog: This component allows the user to discover and reuse queries using the Data
Catalog. Metadata can be facilitated for search functionality.
Advantages of Power BI
Here are the advantages of using Power BI:
Disadvantages of Power BI
Here, are Cons/drawbacks of using Power BI:
Dashboards and reports only shared with users having the same email domains.
Power Bl will not mix imported data, which is accessed from real-time connections.
Power Bi will not accept the file larger than 250MB and zip file which compressed by the data
of X-velocity in-memory database.
Power BI can’t accept file size larger than 1 GB.
Dashboards never accept or pass user, account, or other entity parameters.
Very few data sources that permit real-time connections to Power BI reports and dashboard.