Interview questions for Power BI

Power BI Interview Questions and answers for beginners and experts. List of frequently asked Power BI Interview Questions with answers by Besant Technologies. We hope these Power BI Interview Questions and answers are useful and will help you to get the best job in the networking industry. This Power BI Interview Questions and answers are prepared by Power BI Professionals based on MNC Companies expectation.

1. What are the drawbacks of using Power BI?

Here, are the main drawbacks of Power BI:
• Dashboards and reports only shared with users having identical email domains.
• Power Bl does not mix imported data, which is accessed from real-time connections.
• Power BI can’t accept file size larger than 1 GB.
• Dashboard does not accept or pass user, account, or other entity parameters.

2. What is self-service business intelligence?

Ans: Self-Service Business Intelligence (SSBI)
• SSBI is an approach to data analytics that enables business users to filter, segment, and, analyze their data, without the in-depth technical knowledge in statistical analysis, business intelligence (BI).
• SSBI has made it easier for end users to access their data and create various visuals to get better business insights.
• Anybody who has a basic understanding of the data can create reports to build intuitive and shareable dashboards.

3. Name out three important Power BI tools?

Three important power BI tool are:
• Power BI Desktop—It is used for desktop computers
• Power BI service—It is an online software as a service tool
• Mobile Power BI apps—They are used for iOS and Android devices.

4. What data sources can Power BI connect to?

The list of data sources for Power BI is extensive, but it can be grouped into the following:
• Files: Data can be imported from Excel (.xlsx, xlxm), Power BI Desktop files (.pbix) and Comma Separated Value (.csv).
• Content Packs: It is a collection of related documents or files that are stored as a group. In Power BI, there are two types of content packs, firstly those from services providers like Google Analytics, Marketo or Salesforce and secondly those created and shared by other users in your organization.
• Connectors to databases and other datasets such as Azure SQL, Databaseand SQL, Server Analysis Services tabular data, etc.

5. What are the important components of the Power BI toolkit, and what do they do?

• Power Query: It allows you to discover, access, and consolidate information from different sources.
• Power Pivot: A modeling tool.
• Power View: It is a presentation tool for creating charts, tables, and more.
• Power Map: Helps you to create geospatial representations of your data.
• Power Q&A: Allows you to use natural language to get answers to questions.

6. What are Building Blocks in Power BI?

The following are the Building Blocks (or) key components of Power BI:
1. Visualizations: Visualization is a visual representation of data.
Example: Pie Chart, Line Graph, Side by Side Bar Charts, Graphical Presentation of the source data on top of Geographical Map, Tree Map, etc.

2. Datasets: Dataset is a collection of data that Power BI uses to create its visualizations.
Example: Excel sheets, Oracle or SQL server tables.

3. Reports: Report is a collection of visualizations that appear together on one or more pages.
Example: Sales by Country, State, City Report, Logistic Performance report, Profit by Products report etc.

4. Dashboards: Dashboard is single layer presentation of multiple visualizations, i.e we can integrate one or more visualizations into one page layer.
Example: Sales dashboard can have pie charts, geographical maps and bar charts.

5. Tiles: Tile is a single visualization in a report or on a dashboard.
Example: Pie Chart in Dashboard or Report.

7. What types of data types are available in Power BI?

Important Data sources used in Power BI Desktop are:
• All
• File
• Database
• Power BI
• Azure
• Online Services
• Other

8. What is grouping? How can you use it?

Power BI Desktop allows you to group the data into small chunks. For grouping, you should use Ctrl + click to select multiple elements in the visual. Right-click one of those elements which appear in groups window.
13. What is special or unique about the CALCULATE and CALCULATETABLE functions?

Ans: These are the only functions that allow you modify filter context of measures or tables.
• Add to existing filter context of queries.
• Override filter context from queries.
• Remove existing filter context from queries.
Limitations:
• Filter parameters can only operate on a single column at a time.
• Filter parameters cannot reference a metric.

9. What are the different Excel BI add-in?

Below are the most important BI add-in to Excel:
• Power Query: It helps in finding, editing and loading external data.
• Power Pivot: Its mainly used for data modeling and analysis.
• Power View: It is used to design visual and interactively reports.
• Power Map: It helps to display insights on 3D Map.

10. Can we have more than one active relationship between two tables in data model of power pivot?

No, we cannot have more than one active relationship between two tables. However, can have more than one relationship between two tables but there will be only one active relationship and many inactive relationship. The dotted lines are inactive and continuous line are active.

11. What is xVelocity in-memory analytics engine?

The main engine, xVelocity in-memory analytics engine. This machine can handle large amount of data as it stores data in columnar databases and in enhances memory analytics which results in faster processing of data as it loads all data to RAM memory.

12. Where do I get started with Power BI?

Power BI Blogs
• Seminars
• Getting started videos on YouTube Channels
• Join a community and ask questions

13. State the advantages of Power BI?

The advantages of Power BI are stated below:
• User can create their data sources too easily and quickly to visualize data.
• Serves for multiple purposes such as data visualization, personalized reports, decision support engines to business organizations and groups.
• Establishes faster connection with local DB or to excel spread sheets.