Microsoft Power BI Interview Questions and Answers PDF Download by Industry Experts, Practical Scenarios, Examples, Problems and Solutions.

POWER BI INTERVIEW QUESTIONS - INDEX

What is the default visual interaction in Power BI ?
How to change default visual settings in Power BI ?
How many types of interactions are there in Power BI ?.


What is DAX in Power BI ?
How to implement DAX in Power BI ?
What are the most commonly used DAX functions in Power BI ?
Sample DAX Formula in Power BI.


Explain Power BI Data Refresh Architecture


Configuring automatic refresh in Power BI


What is Differences between visual level filters, page level filters and report level filters in Power BI


What is Difference between Power BI Desktop and Power BI


Building Blocks in Power BI (or) Components of Power BI.


Difference between Microsoft Business Intelligence MSBI and Power BI. SSIS, SSAS and SSRS.

What is the default visual interaction in Power BI ?
How to change default visual settings in Power BI ?
How many types of interactions are there in Power BI ?.

What is the default visual interaction in Power BI ?


The default visual interaction in Power BI should be Drill Mode On, we can set this to on off, if we keep off, we have to change the setting every time. Instead set the Default to ‘Drill Mode On’.
What it means to Drill Mode on, if the totals are at yearly level, the drill mode on can enable user to drill down to monthly, weekly, daily and so on. The level of drill downs are only possible based on the data.

Click here for full answer...

What is DAX in Power BI ?
How to implement DAX in Power BI ?
What are the most commonly used DAX functions in Power BI ?
Sample DAX Formula in Power BI

What is DAX:


DAX (Data Analysis Expressions) helps in creating new information from existing information (or) data. The existing information can be at detail level, using DAX we can create information such as aggregated, summarized and so on.

Click here for full answer...

Explain Power BI Data Refresh Architecture.
What are the different steps involved in Power BI data refresh ?

To use data refresh, you need a way to pull data from the data source (SQL Server, in this example) and push it directly into the SSAS model generated by Power BI.

Click here for full answer...


Configuring automatic refresh in Power BI.

Power BI now has all of the information it needs to refresh the data, both on demand and on a scheduled basis. Expanding the Schedule Refresh section, you can define when Power BI attempts to refresh the dataset.

Click here for full answer...


How many types of filters are there in Power BI Reports ?
What is the Differences between visual level filters, page level filters and report level filters in Power BI ?

Power BI provides variety of option to filter report, data and visualization. The following are the list of Filter types.

Click here for full answer...


Visual-level Filters


These filters work on only an individual visualization, reducing the amount of data that the visualization can see. Moreover, visual-level filters can filter both data and calculations.

Click here for full answer...


What is the Difference between Microsoft Business Intelligence tool - Power BI Desktop and Power BI.

Power BI Desktop


Power BI Desktop is a Windows application (Clinet) running on the local computer. It is more a of client machine which can connect with variety of data sources from your computer to the data in the local computer or the data in the server.

Power BI
Power BI is a cloud solution. We can use web browser to connect with Power BI. We can perform the same development work using either Power BI OR Power BI Desktop.

Click here for full answer...

Building Blocks in Power BI (or) Components of Power BI.

The following are the Building Blocks (or) Key components of Power BI


- Visualizations
- Datasets
- Reports
- Dashboards
- Tiles

Click here for full answer...

Difference between Microsoft Business Intelligence MSBI and Power BI. SSIS, SSAS and SSRS.

Microsoft Business Intelligence - MSBI


Microsoft product with ETL capability, multidimensional data organizing capability and visualization ability. MSBI comes with three sub components to support earlier mentioned functionalities. The following are the components of MSBI:

MSBI - SSIS

This component works as an Data Integration Service which can perform up to some level of ETL acitivity.

Click here for full answer...