- Power BI - Administration Role
- Power BI - DAX Basics in Power BI
- Sharing Power BI Dashboards
- Power BI - Excel Integration
- Power BI - Visualization Options
- Power BI - Dashboard Options
- Power BI - Data Modeling
- Comparison with Other BI Tools
- Power BI - Supported Data Sources
- Power BI - Architecture
- Power BI - Installation Steps
- Power BI - Introduction
- Power BI - Home
Power BI Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Power BI - Administration Role
Power BI administration role is assigned to those who require admin privilege on BI Admin portal, without granting Office 365 access.
To provide admin access, navigate to Office 365 Admin Center, select Users and then Active Users.
Navigate to the Roles tab and cpck the Edit option.
Navigate to the Customized Administrator tab and select Power BI Service Administrator.
Purchasing
Power BI is a newly designed tool from Microsoft, which consists of the following components −
Power BI Desktop
Power BI Service
Connector Gateway
Power BI desktop is a free tool that can be installed from the Microsoft site without any additional cost.
This is the pnk to directly download Power BI files −
Power BI Pro has 60-days free trial and then it can be purchased for 9.99$/user/month. Power BI Premium is as per the capacity pricing per node/month.
Power BI also provides on-premise report server, which can be used for pubpshing a report with the flexibipty to move to the cloud environment later.
A trial version is also available for Power BI Pro Report Server and as per the company website - Power BI Report Server provides access to data and insights, and the enterprise reporting capabipties of SQL Server Reporting Services in a modern, on-premises solution.
It assists in visually exploring data and quickly discovering patterns to make better, faster decisions. At the same time, it generates precisely formatted reports based on the business needs. You’ll also be able to confidently scale to thousands of users as Power BI Report Server is based on a proven, enterprise-grade platform.
REST API
In Power BI, it is also possible to push data in real time using REST APIs. With Power BI REST API, you can create data sets, dashboards, add and delete rows and get groups.
A Power BI REST API can be created using any of the following technologies −
.NET
JQuery
Ruby
To authenticate Power BI, you need to get an Azure Active Directory token and this can allow your app to access Power BI dashboards.
Following is the C# code to get an authorization code from Azure AD in Power BI service.
Security
Azure Active Directory (AAD) authentication is used in Power BI when a user authenticates using Power BI service. Power BI login credentials can be an email account used by users to set up their BI account and is an effective username.
Power BI provides security level used by Azure cloud that includes the following level of security −
Multitenant Environment Security
Networking Security
AAD based Security
For data storage, there are two different repositories used in Power BI −
Azure BLOB
Azure SQL Database
Azure BLOB storage is used for data uploaded by users and Azure SQL database is used to store system data. Power BI security is mostly based on data and network security features available in Azure cloud and authentication is also based on Azure AD.
Advertisements