Power BI – Administration

Last updated on Sep 27 2021
Bhavin Mukherjee

Table of Contents

Power BI – Administration

Power BI administration role is assigned to those that 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 click on the Edit option.

Page 1 Image 1 20
Navigate

Navigate to the Customized Administrator tab and select Power BI Service Administrator.

Page 1 Image 2 2
Power BI Service Administrator

Purchasing

Power BI is a newly designed tool from Microsoft, which consists of the subsequent 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.
https://powerbi.microsoft.com/en-us/pricing/

Page 2 Image 3 10
Install

This is the link to directly download Power BI files −
https://www.microsoft.com/en-us/download/details.aspx?id=45331

Page 2 Image 4 1
Power BI files
Page 2 Image 5
Download

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 employed for publishing a report with the flexibility to move to the cloud environment later.
https://powerbi.microsoft.com/en-us/report-server/

Page 3 Image 6 1
on-premise

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 capabilities 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’s also possible to push data in real time employing 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 employing any of the subsequent 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.
Subsequent is the C# code to get an authorization code from Azure AD in Power BI service.

Page 4 Image 7 8
C# code

Security

Azure Active Directory (AAD) authentication is employed in Power BI when a user authenticates employing Power BI service. Power BI login credentials can be an email account employed by users to set up their BI account and is an effective username.
Power BI provides security level employed by Azure cloud that includes the subsequent level of security −
• Multitenant Environment Security
• Networking Security
• AAD based Security
For data storage, there are two different repositories employed in Power BI −
• Azure BLOB
• Azure SQL Database
Azure BLOB storage is employed for data uploaded by users and Azure SQL database is employed to store system data. Power BI security is mostly based on data and network security measures available in Azure cloud and authentication is also based on Azure AD.
So, this brings us to the end of blog. This Tecklearn ‘Power BI – Administration’ blog helps you with commonly asked questions if you are looking out for a job in Power BI. If you wish to learn Power BI and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI

• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources

Power BI Workflow

• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships

Power Query for Data Transformation

• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations

Filters and Drill Down Report

• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report

Power Pivot for Data Modelling

• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions

Data Analysis Expression – DAX Queries

• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features

Power BI Desktop & Administration

• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters

Introduction to Power Q & A

• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

 

0 responses on "Power BI - Administration"

Leave a Message

Your email address will not be published. Required fields are marked *