1. Introduction to Business Intelligence and Power BI
1.3 Components of Power BI
| Component | What it is | Who uses it |
|---|---|---|
| Power BI Desktop | Free Windows application used to connect to data, transform it, build the model and design reports. Files are saved as .pbix (or as a Power BI Project, .pbip). |
Report developers and analysts |
| Power BI Service | The cloud (SaaS) platform at app.powerbi.com. Used to publish, share, schedule refresh, build dashboards and apps. | Developers, business users, administrators |
| Power BI Mobile | Apps for Android and iOS (and Windows) for viewing reports and dashboards on the go. | Managers and business users |
| Power BI Report Server | An on-premises report portal for organisations that must keep reports inside their own servers. Uses a special version of Desktop optimised for Report Server. | Organisations with strict data residency needs |
| On-premises data gateway | A bridge software installed on a machine inside the company network, so the cloud Service can securely refresh or query on-premises data (e.g. a local SQL Server or files on a shared drive). | Administrators, developers |
Other pieces you will hear about: Power BI Report Builder (for pixel-perfect, printable paginated reports), Power BI Embedded (putting reports inside your own apps) and Power BI Visuals Marketplace (AppSource) for custom visuals.
Data sourcesExcel · CSV SQL · Web | → | DesktopPower Query Model · DAX Report | → | Publishto the Service | → | ServiceWorkspaces Refresh · Apps | → | ConsumeBrowser Mobile · Teams |
Samjla ka? Desktop madhe banvaycha, Service madhe share karaycha – evdha lakshat theva, baki sagla pudhe aapoaap samjel.
Ravindra Bagale's Tip
Friends, many students mix up Desktop and the Service, and try to build data models in the browser or expect scheduled refresh from Desktop. Remember: you build in Desktop, and you share, refresh and secure in the Service. Keep this split clear in your head from day one. Don't make this mistake!
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students Desktop आणि Service मध्ये गल्लत करतात, browser मध्ये data models बनवायचा प्रयत्न करतात किंवा Desktop कडून scheduled refresh ची अपेक्षा करतात. लक्षात ठेवा: build Desktop मध्ये करायचं, आणि share, refresh आणि secure Service मध्ये. ही विभागणी पहिल्या दिवसापासून डोक्यात स्पष्ट ठेवा. ही चूक करू नका!
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students Desktop और Service को मिला देते हैं, browser में data models बनाने की कोशिश करते हैं या Desktop से scheduled refresh की उम्मीद करते हैं. याद रखो: build Desktop में करते हैं, और share, refresh और secure Service में. यह बँटवारा पहले दिन से दिमाग़ में साफ़ रखो. यह गलती मत करना!