Power BI Interview Questions

Are you scheduled for a last-minute Power BI interview? The finer hacks to crack a Power BI job interview are here. Spend just 10 minutes every day to master the top Power BI interview questions. This ultimate list of Power BI interview questions and answers will help you revive your knowledge on many topics like role-based usage of Power Bi, Premium Capacity, Ant concepts, Installing Ant, etc. and land a good job as Power Bi/SQL Developer, Senior Database Developer, and others.

  • 4.8 Rating
  • 20 Question(s)
  • 20 Mins of Read
  • 8521 Reader(s)

Intermediate

Microsoft has categories Power BI users as below:

  • Consumers (also called as End-Users) of Power BI who gets insights of the data in the form of reports and used for decision making.
  • Designers who Collect, Wangle, Explore, Transform, Model, and Evaluate Data and then design reports, publish reports to Power BI Web Service and create dashboards.
  • Administrators who are responsible for User governance using Office 365 (like Provisioning of Power BI Access to workspaces Licenses) and Administering User Security (like assigning Power BI admin roles and assigning Premium capacity roles)
  • Developers who helps Power BI consumers and designers to build integrating / embedding custom visuals in Power BI Reports and building streaming datasets.

These roles are basically deals for user access, governance and security and below are roles:

  • Office 365 Global Administrator: This role is Super Admin for Office 365 Suite called Global administrator and will be able to grant various admin roles to others
  • Office 365 Billing Administrator: This role used to Manage licenses or subscriptions.
  • Power BI Service Administrator: This role is inside of O365 suite and used to manage User metrics, users, Audit Logs, tenant settings and Premium settings. Only O365 Global Admin can assign this role to others to help out better control on Power BI space.
  • Power BI Premium Capacity Administrator: This role can be assigned to others by Power BI Service Admin and used to assign Premium capacity to app workspaces.
  • Power BI Embedded Capacity Administrator: This role is available in Microsoft Azure portal. O365 Global and Power BI Service administrators are called as Power BI Embedded Capacity Admin.

Portals and centers are User friendly GUI tools available for organization which running in the cloud(Azure) and will help in providing access, managing users and security.

  • Power BI Admin Portal: This portal helps to manage User metrics, Users, Audit logs and  tenant settings and Premium capacity settings in organization.
  • Office 365 Admin Center: This center enables to manage users, configure, setup, groups and licensing, monitoring activities and see descriptive reports.
  • Office 365 Security & Compliance Center: This center will help to protect data by providing right roles & permissions to users and also comply with legal by following regulatory standards.
  • Azure Active Directory (AAD) in the Azure portal: AAD is basically to manage Identity and  Access Management which helps organization to provide maintain Single Sign On(SSO) id for their users. In this portal, admin can add, remove, restrict the access for users (or) user groups (or) security groups in the organization.
  • Powershell Cmdlets Administrative APIs & SDK: This part of azure portal, where admin can manage the users, user groups, security groups, etc.. by command-lets instead of GUI.

Premium Capacity is a way to have dedicated server/node for better handling Power BI Service Workload for your organization which supports up to 1 TB of data storage.

Premium capacity can be identified by seeing Diamond icon beside our app workspace and it can be assigned by Office 365 Global Administrator (OR) Power BI Service Administrator.

Diamond icon

Steps:

  • Open app.powerbi.com in favorite browser.
  • In navigation page, select respective app workspace
  • Edit Settings
  • Expand Advanced then enable Premium capacity for it.

Based on your organization and users Capacity, pricing must be planned.

Pro Users are required to collect, model, authors the reports and dashboards and publish to web services for sharing and collaboration will be charged.

Frequent Users are just consumers of reports and dashboards, Time frame of a week probably several. These users can have free license to access Reports and Dashboards as App Workspace is backed with Premium capacity.

Occasional Users are end-users where they very rarely use reports and dashboards. These users can have free license to access Reports and Dashboards  as App Workspace is backed with Premium capacity.

Incremental refresh feature is released  in May 2018, it is traditionally reserved for large models (Like more than 1 GB) in analysis servers for high-end scalability of data by publishing only to workspace in Power BI Service where Premium capacity is enabled for them.

Eg: It will increase the speed and efficiency of data refresh by just refreshing the data changes in last 1 day -10 days instead of loading last 3 years of data.

To enable it just right click on tables in fields pane and enable Incremental refresh. 

This can be achieved by Dynamic Row Level Security(RLS) in Power BI.

Steps to be followed:

  • In Modeling menu.
  • Select Manage Roles.
  • Create & define Role name.
  • Select required table and UserPricnicpalName() function and publish this to Power BI Service.

Once users log in to Power BI service with respective user id (UserPricnicpalName()) they will be able to see only data based on role we created.

To attain this need to create Content Pack,

  • Need to select Specific Group of people (User Email ids or Distribution lists) (OR)
  • My Entire Organization in then we choose give access to Dashboards or Reports or Datasets.

This major feature is introduced in July 2018 called Composite Model. Here, Power BI desktop author is empowered to combine the data which is coming from a variety of sources and establish relationships between those tables in data model.

  • DirectQuery, which is a large table in SQL server and need not to download in data model.
  • Dual, which is a small table in SQL server, can be downloaded easily into data model.
    However, this will be only in RAM will not be saved in .PBIX.
    To enable this feature, right clicking on the table in the Fields pane and select table properties, another window Field properties pane will appear and can change Storage Mode from DirectQuery to Dual
  • Import, will import the data from sources like CSV or Excel or Azure SQL server or Azure Data Lake or Azure Cosmos to data model and will occupy the space in .PBIX
  • Power BI Dashboards are available in Power BI web Service.
  • Can use DrillThrough page, Bookmarks and Selection pane.
  • Tiles can be directly pinned from reports to dashboards which gives very high-level day to day view of main KPIs of business and by a click on tiles will navigates back to reports for detailed view
  • Report layout can be set to Mobile view.
  • Apart from that various tiles can be created like Web Content, Images, Textbox and integrate URLs, Videos, and custom streaming data tile.

  • Power BI reports are created in Power BI Desktop.
  • Advanced Q&A and tooltip option can be enabled.
  • Various report page size can be set like (16:8, 4:3, Letter, Tool Tip, Cortana, and custom).
  • Set Page Background and Wallpaper.
  • Can use DrillThrough page, Bookmarks and Selection pane.
  • Download Custom Visualizations from marketplace
  • Set Color Themes to reports
  • Can printout of reports similar to Microsoft PowerPoint Presentations.
  • Exported to PDF
  • Contains 190+ DAX functions to apply on our data, whenever necessary.
  • Save as Template file (.PBIT).
  • Report layout can be set to Desktop as well as Mobile.

Yes, it’s possible by following the steps below:

  • Firstly, Power BI Admin portal, in tenant settings “Analyze in Excel” option must be enabled by Power BI Administrator.
  • Then at upper right corner, click settings to download and install Excel updates.
  • Next left-hand side navigation pane, got to workspace > dataset > click on Eclipses (three dots) and select Analyze in Excel.
  • Download .ODC, save and double click on it.
  • Post that need to provide power BI user id and password.
  • Which will connect to dataset in Power BI.
  • Data Stories Gallery, is a place where all the designers of Power BI across the different countries, those who have analyzed the data out of their personal interest and brought the data back to life and wanted to showcase the rest of the world about their outstanding skills.
  • They upload Power BI (.PBIX) with their Storytelling and anyone can download their work.

Steps to go to Data Stories Gallery:

  • Open PowerBI.com in favorite browser.
  • By hovering on Learn
  • Click on Community
  • Scroll down a bit and you will find Data Stories Gallery.
  • Also find Power BI reports where they have designed games.
  • And anyone can submit her or his Data Story as well.
  • Here any Power BI report designers or consumers or developers or admins can suggest ideas(that could be anything new feature, or enhancement etc.) which can improve user Experience and currently that is what Microsoft is listening to User Voice”.
  • Once this is posted in ideas page, then different users across the world, possible needs similar or same kind requirements and they start supporting idea by Voting it.
  • No of votes increases then your idea has got demand which is called “Hot Idea”.
  • Then Microsoft product team will consider it and releases that feature in subsequent releases.
Requirement

Best type of Visual
For Identify or perform trend progress over time analysis

Line or combo chart
For Identify any relationship among values

Scattered and bubble chart
Compare the different categories or times over the time

Column Chart
Labels have long names and need to compare more than 7

Bar Chart
Show Percentage and as well as Total

Stacked Column Chart
To check the distribution or composition

Area or Pie Chart
Data has Countries, counties, Longitudes and Latitudes etc.

ArcGIS or Map or Filled Maps

Advanced

  • Open app.powerbi.com in favorite browser
  • Click Upper right corner on settings.
  • Select Power BI Admin.
  • Select Users and click Go to O365 Admin Center.
  • Will be landed in portal.office.com.
  • Select active users.
  • Flyout will appear, check the required users and edit product licenses.
  • Select radio button “Add to existing product license assignments" and Enable Power BI Pro License.
    (OR)
  • Can use Powershell Azure Active Directory command-lets to assign the license.

Streaming dataset is also called as Real Time Datasets and can create real time Dashboard, which updates just similar Live Cricket score or Live Football Score or Live Temperature etc.

  • Open app.powerbi.com.
  • upper right corner Click on + Icon.
  • Select Steaming Dataset.
  • Flyout will appear with 3 options API, Azure Stream Analytics & PUBNUB.
  • Select API and hit next.
  • Next flyout, Provide dataset name then Column names and respective data types.
  • Enable Historic data analysis (which will help holding old data in dataset to perform analysis) then hit Create.
  • Streaming dataset will be created, and it will show api url and also Codes – Raw, cURL & Powershell.
  • Select PowerShell, copy code.
  • Open PowerShell ISE.
  • Paste the code and modify default values and press F5.
  • It will immediately insert the data into Streaming dataset.

Go to dataset:

  • check for the dataset which is created.
  • click create reports to insert visuals and pin those visuals to Dashboard

(OR)

Go to dashboards:

  • Upper middle click + Add tile.
  • In flyout select source tile as REAL-TIME DATA then next.
  • Your existing Steaming dataset will appear, if it’s not readily available then create new dataset.

Yes, it’s possible using options below and can be enabled in the View menu.

  • Bookmarks pane– to save default/preferred view and save with view name.
  • Selection Pane – to select required visuals in a Page and rest can be hidden.

Process:
Initially, place all Slicers on shape Rectangle > name Rectangle of List of slicers > go to selection pane then select rectangle and all the slicers and create Bookmark with name Select Slicer.

Finally, insert blank Button and name as “Show Slicers” in field properties Action assign Bookmark “Select Slicer”

Yes, can be done.

  • Select Clustered Column chart
  • Drag Date hierarchy in Axis
  • Drag Numbers Values
  • In Format options scroll  In X-Axis, Turn Off Concatenate labels option.
  • Go to canvas, select Chart visual then click on more options, Select Sort A->Z
  • Again, click on more options Sort by Date.


Yes, this can be achieved.

  • Need to insert Image using Page Background and wallpaper to give illusion to look similar web page.
  • By using Bookmarks, Selection panes and Buttons.
  • Bookmarks and Selection pane to save with favorite view name which want to be shown to consumers.
  • Using Buttons can assign above bookmarks to actions.
  • Buttons will be placed on Cover Page or Landing Page or Main page
  • Except Main page all pages will be hidden state.
  • Publish to Power BI Web Service.

Description

Power BI is a business analytics service provided by Microsoft. Its primary aim is to provide interactive business intelligence and visualizations capabilities, with the help of which users can create their own dashboards and reports. Power BI was released in the year 2013 where Microsoft decides to blend multiple Excel add-ons together to create a completely independent tool. Power BI is considered as the major contributing factor in the growth of data visualization domain or Microsoft in BI.

There are many companies who use Apache Kafka. According to iDatalabs, most of the companies that are using Power Bi are found in the United States and the United Kingdom, particularly in the industry of Computer Software. Mostly, these companies have 50-200 employees with a revenue of 1M-10M dollars. To name a few of these companies: Devon Energy Corporation, Rolls-Royce Motor Cars Limited, H.J. Heinz Company, etc.

According to payscale.com, the average salary of a Business Intelligence Developer (BI) who has Microsoft Power BI skills, is $62,5000 per year.

Worried about your Power BI interview? We have got the perfect rescue for you wherein you will be advised on the most common Power BI interview questions with answers. Rest assured as we are offering you the most asked interview questions on Power BI to help you clear your upcoming Power BI job interview.

Here, through expert advice, we have gathered a few sample power BI Interview Question and their answers. Through this, you will learn the components of Power BI, PowerPivot, data refresh, DAX in Power BI. These Interview questions for Power BI will give you an idea of the type of questions which could be asked in Power BI interviews. Power BI interview questions & answers here are suitable for both freshers and experienced professionals at any level.

Read More
Levels