Tuesday, December 22, 2020

Administrator roles related to Power BI

 Administrator roles related to Power BI

There are several roles that work together to administer Power BI for your organization. Most admin roles are assigned in the Microsoft 365 admin center or by using PowerShell. The Power BI Premium Capacity and Power BI Embedded Capacity admin roles are assigned when the capacity is created. To learn more about each of the admin roles, 

ADMINISTRATOR ROLES RELATED TO POWER BI
Type of administratorAdministrative scopePower BI tasks
Global adminMicrosoft 365Has unlimited access to all management features for the organization
Assigns roles to other users
Billing adminMicrosoft 365Manage subscriptions
Purchase licenses
License adminMicrosoft 365Assign or remove licenses for users
User adminMicrosoft 365Create and manage users and groups
Reset user passwords
Power BI adminPower BI serviceFull access to Power BI management tasks
Enable and disable Power BI features
Report on usage and performance
Review and manage auditing
Power BI Premium Capacity adminA single Premium capacityAssign workspaces to the capacity
Manage user permission to the capacity
Manage workloads to configure memory usage
Restart the capacity
Power BI Embedded Capacity adminA single Embedded capacityAssign workspaces to the capacity
Manage user permission to the capacity
Manage workloads to configure memory usage
Restart the capacity

Monday, December 21, 2020

Types of Filters in Power BI

Types of Filters in Power BI 

The four types of filters are:

  • Report – Applies to all pages in the report.

  • Page – Applies to all the visuals on the current report page.

  • Visual – Applies to a single visual on a report page. You only see visual level filters if you have selected a visual on the report canvas.

  • Drillthrough – Allows you to explore successively more detailed views within a single visual.

Friday, December 18, 2020

Parts of Power BI Desktop environment

 Parts of Power BI Desktop environment

In Power BI Desktop, you'll begin to build reports in the Report view. You'll be working in five main areas:

The five areas of Report view.

  1. Ribbon - Displays common tasks that are associated with reports and visualizations.
  2. Report view, or canvas - Where visualizations are created and arranged. You can switch between ReportData, and Model views by selecting the icons in the left column.
  3. Pages tab - Located along the bottom of the page, this area is where you would select or add a report page.
  4. Visualizations pane - Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.
  5. Fields pane - Where query elements and filters can be dragged onto the Report view or dragged to the Filters area of the Visualizations pane.

Basic building blocks in Power BI

 

Basic building blocks in Power BI

  1. Visualizations – A visual representation of data, sometimes just called visuals
  2. Datasets – A collection of data that Power BI uses to create visualizations
  3. Reports – A collection of visuals from a dataset, spanning one or more pages
  4. Dashboards – A single-page collection of visuals built from a report
  5. Tiles – A single visualization on a report or dashboard