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

POWER BI INTERVIEW QUESTIONS - INDEX

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.

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...