Top 100 Power BI Interview Questions & Answers

power-bi-interview-questions

1. What is BI?

Business intelligence is a technology-driven strategy. It encourages you to break down data and to give significant information which helps corporate chiefs, business managers, and different clients to take conclusive business choices.

2. What is a Power BI?

Power BI is a Business Intelligence and Data Visualization tool which encourages you to change over data from the different data source into intelligent dashboards and BI reports. It gives different software connectors and administrations.

3. Why use Power BI?

Here are four essential explanations behind utilizing Power BI tool:

Pre-manufactured dashboards and reports for SaaS Solutions.

Power BI permits continuous dashboard refreshes.

Offers Secure and solid association with your data sources in the cloud or on-premises

Power BI offers quick sending, cross breed design, and secure condition.

Causes you in data investigation utilizing common language inquiry

4. What are the important components of Power BI?

Important components of Power BI are:

1) Data Integration, 2) Data Processing, and 3) Data Presentation

5. What is Dax Function?

It is a formula expression language called (DAX) that can be used with various visualization tools like Power BI. It is also known as a functional language, where the full code is kept inside a function.

6. What are the data types of Dax?

Data types of Dax are: 1) Numeric, 2) Boolean, 3) DateTime, 4) String, and 5) Decimal.

7. What are the essential applications of the Power BI?

Power BI is mainly used by:

PMO – Project Management Office
Business & Data Analyst
Developer & Database Administrator
IT Team, IT Professional
Consumer for End User Report
Data Scientist

8. What are the drawbacks of using Power BI?

Here, are the primary disadvantages of Power BI:

Dashboards and reports just imparted to clients having indistinguishable email spaces.

Power Bl doesn’t blend imported data, which is gotten to from continuous associations.

Power BI can’t acknowledge document size bigger than 1 GB.

Dashboard doesn’t acknowledge or pass client, account, or other element boundaries.

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

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

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

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

Power BI Desktop permits you to aggregate the data into little lumps. For gathering, you should utilize Ctrl + snap to choose numerous components in the visual. Right-click one of those components which show up in bunches window.

13. Explain the term responsive slicers.

On a report page, you can without much of a stretch resize a responsive slicer to different sizes and shapes, and the data contained in it ought to be adjusted by it. In the event that if the visual turns out to be too little to be in any way helpful, a symbol speaking to the visual capacity to have its spot, therefore sparing the space on the report page.

14. Define the term ‘M language.”

It is a programming language utilized in Power Query. It’s a practical, case-delicate language which is like other programming dialects and simple to utilize.

15. What information is required to create a map in Power Map?

Power Map can show visualizations which are topographical in nature. That is the reason an area data is required, for instance, city, state, nation or scope and longitude.

16. What are the important features of Power BI dashboard?

It permits you to bore through the page, bookmarks, and determination sheet.

It permits you to make different tiles like web content, pictures, textbox, and incorporate URLs.

Permits you to set report format to versatile view.

17. What are the steps to go to Data Stories Gallery in Power Bi communities?

Steps to go to Data Stories Gallery:

To begin with, open PowerBI.com in a most loved program.

By floating on Learn

Snap on Community

Look down nearly nothing, and you will discover Data Stories Gallery.

Anybody can present her or his Data Story also.

18. Where incremental licensing refresh feature is accessible?

Incremental refresh feature mainly used for high-end scalability of data by publishing only on that workspace in Power BI Service where Premium capacity is needed.

19. How can you analyze Power BI reports data in excel?

You have to follow the underneath given advances:

Open Power BI Admin entrance, go to occupant settings and select – > Analyze.

Watch that Power BI Administrator has empowered Excel choice or not.

At that point at the upper right corner, click settings to download and introduce Excel refreshes.

Next, go to one side hand side route sheet, go to the workspace, click on the dataset, click on Eclipses (three dabs) and select Analyze in Excel.

Download ODC record, spare, and double tap on it.

After that necessities to give power BI client id and secret key.

20. What is Power Pivot, and what are the filter writes in Power BI?

Power Pivot is an in-memory component which offers highly compressed data storage. It helps you to build a data model, creating formulas, relationship, calculated columns from various resources.

Filters are applicable in:

Visualization level
Page Level
Report Level

21. How can you perform Dynamic filtering in Power BI?

Dynamic Filtering in Power BI is done using the following steps:

Once all the data are set up, publish a detail report to Power BI.
Publish it to group workspace.
Create a filter link
Create a DAX calculated column.
Public overview report

22. What is Power Pivot Data Model?

It is a model that contains data composes, tables, segments, and table relations. These data tables help you to produce for holding data for a business substance.

23. What is Power Query?

Power query is an ETL tool which helps you to clean, shape, and modify data utilizing instinctive interfaces without doing anything.

24. Which programming language is used in Power Query?

M-code is a new programming language that is used in power query. It is similar to other programming languages and easy to use.

25. List out benefits of using Variables in DAX.

Here, are benefits of using DAX function:

By declaring and evaluating a variable, the variable can be reused multiple times in a DAX expression, which helps you to avoid additional queries of the source database.
Variables can make DAX expressions more useful and logical.
Variables is only scoped, which should be measure or query which can’t be among measures.

25. What are Tiles in Power BI?

Tile is a significant component of power BI benefits and can be said as an image of the data which can be stuck to the dashboard.

26. What is on-premise gateway?

On-premise entryway goes about as an extension which causes you to move the data, which is on-premise (not on the cloud) securely and safely.

27. Name two types of connectivity modes in Power BI?

Two types of connectivity modes used in Power BI are:

Import
Direct Query

28. Explain the term data alerts.

Alert works on data that is refreshed, Power BI looks for an alert, and it reaches the alert threshold or the limit then the alter will be triggered.

29. What is the calculated column?

It is a calculating expression of DAX which allows calculation on data stored in a new column.

30. What is query collapsing?

The process of converting the steps in power query editor to SQL and executing it by the source database is called query collapsing.

31. Explain data source filter.

It is a parameter to filter the data into machines.

32. What is content packs?

These are pre-built solutions build for popular services as a major part of the Power BI experience.

33. What are the types of filters available in Power BI Reports?

Important filters of Power BI reports are:

Visual-level Filters
Page-level Filters
Report-level Filters

34. What is Bookmark?

Bookmark in Power BI encourages you to catch the designed perspective on a report page in a particular time. This incorporates channel and condition of visual which can utilize an alternate way to return to the report that you can include as a bookmark.

35. What are the advantages of using a variable in Power BI?

Variables help you to create more logical Queries and which should be used for multiple DAX functions.

36. Why use selection pane in Power BI?

Determination Pane encourages you to assume responsibility for visuals which require to be shown and which ought not be shown. It permits you to join various visual pages in the gathering and is likewise utilized in bookmarking.

37. How to handle Many to Many relationships in Power BI?

You can use Crossfiltering option in Power BI to address the Many to Many relationships.

38. Explain x-velocity in memory.

It is the main engine which is used in power pivot. It allows you to load the large set of data into Power BI data.

39. Explain the term Custom Visuals.

Graphs or visual which are not included in Power BI desktop are imported for better visualization.

40. Is it possible to have created multiple active relationships in Power BI?

No, we can’t set multiple active relationships in Power BI.

41. State the main difference between District() and Values() in DAX?

The only difference between two functions is that with District help you to calculate the null values.

42. State the major differences between MAX and MAXA functions

If you want to calculate numeric values, then use MAX. However, if it is for non numeric values, then you should use MAXA.

43. Is on-premise access possible in Power BI?

No, it is absurd to expect to get to Power BI administrations on private or inner assistance cloud. Nonetheless, by utilizing Power BI work area, you can interface with the on-premises data sources.

44. What is the major difference between the old version and a new version of Power BI tool?

The most recent adaptation has more hearty highlights, and it is renowned with the name Power BI Desktop. This is an across the board answer for Power View, Power Pivot, and Power Query in the backend. Power BI offers many include ins for Excel, which is valuable for better visualizations.

45. Explain the term incremental refresh?

Increment refresh is a newly added data so that there is no need to truncate or load the entire data.

46. Is the Power BI tool available for free?

You can get to Power BI for nothing. Be that as it may, on the off chance that you wish to utilize all the component of Power BI, at that point you can utilize its genius membership account. The membership account offers an upgraded rendition of a few highlights that are accessible with Power Bi free record.

47. What kind of data can you store in Power BI?

In Power BI, you can store mainly two types of data.

Fact Tables:

The focal table in a star composition of a data distribution center is a reality table that stores quantitative information for examination, which isn’t standardized by and large.

Dimension Tables:

It is a table in the star pattern which causes you to store properties and measurements which portray objects that are stored in a fact table.

48. State the main difference between Filter and Slicer.

On the off chance that you are utilizing the typical channel client can’t associate with the dashboard. Then again, slicer permits clients to have a cooperation with Reports just as Dashboards.

49. What is the Embed Code?

Power BI online contains an option for publishing on web that will generate a link address for the Power BI report. You can share these links to others, which is called embed code.

50. What are the method to hide and unhide a specific report in Power BI?

To hide and unhide specific report, you have to go to selection Pane in the menu bar, and press hides/unhide toggle button to bookmark.

51. How can you compare Target and Actual Value from a Power BI report?

You need to use Gauge chart to compare two different measure.

52. Can you create multiple dynamic connections between two tables?

No, we can’t create more that one multiple dynamic connections.

53. What is the use of Power BI designer?

Power BI Designer permits clients to make natural reports and dashboards, effectively and rapidly. It additionally encourages clients to change visual views of their data at fingertips for better analytics and educated dynamic.

54. Can you refresh Power BI reports after they are published to the cloud?

Yes, it is possible. Gateways can be used to do so.

For SharePoint: Data Management Gateway
For Powerbi.com: Power BI Personal Gateway

55. What is Custom Visuals?

Custom Vizual are those visual which are not available in BI desktop, which are imported from the market for the purpose of better visualization.

56. What are the gateways that available in Power BI?

The two gateway method available in Power BI are:

On-premises information door
On- premises information door ( personal mode)

57. What is natural language search choice?

The natural language search choice is language-based learning for communicating with information as a part of Power BI suite for Office 365 advertising.

58. Can you join two unique information source in the same Power BI dashboard?

Yes, we can join two unique information source in the same Power Bi dashboard. We can also merge comparable reports in your Power Bi account into using single dashboard.

59. Why is TOP N not accessible for the Page and Report Level Filter?

ToP N is not accessible for the Page and Report Level Filters because their channels are associated with different visuals.

60. Explain the collect function.

Collect function excludes null value. It does aggregate spatial values. You can’t transform data to another format.

61. How can you differ COVAR and COVARP?

The main difference between the two is that: COVAR directly gives the same co-variance, whereas COVARP is the population covariance.

62. How can you assign SSRS with Power BI?

Here are the steps to integrate SSRS with Power BI:

SSRS Report Items like charts can be pinned to Power BI dashboards.
A subscription is created to keep the snapshot of data in dashboard refreshed.
Power BI reports will soon able to publish to SSRS portal.

63. Explain z-order in Power BI?

Z-order is a design strategy which is used for arranging visual over shapes. It can be defined as an implementation method which can be applied whenever reports have multiple elements.

64. What is the only prerequisite for connecting to a database in Azure SQL Database?

The only prerequisite for before connecting to a database is that the user need to configure firewall setting to allows remote connections.

65. Name out some important DAX functions used in Power BI.

Sum, Max, AVG, Distinct, Count, Calculate, Datediff are some important widely used DAX functions.

66. What is X-speed in-memory investigation motor used for Power Pivot?

The primary motto behind power turn is the x Velocity in-memory analytics engine. It allows dealing with the various measures of information as it stores data in the columnar database.

67. Name widely recognized information forming systems.

The most widely recognized information forming systems are:

Removing columns and rows
Adding indexes
Applying for a sort order

68. What happens by clicking on a single information point in one of the various visual in a report?

At the point when you click on single information point data gets select and duplicated to the clipboard. In addition, the replicated data can be stuck in wherever as per your necessity.

69. What is CORR function? When we use it?

CORR is a correlation function. It gives a correlation between two variables. It mostly ranges from -1 to 1.

70. State the difference between Count and CounD function.

Count function returns to count, excluding NULL values whereas Countd returns distinct values which exclude NULL values.

71. Explain DATEDD function in Power BI.

DATEDD function helps you to convert any input to a date format. This input can number, string, or a data type input.

72. What does DATENAME function do?

DATENAME function shows the name of the specific part of the date that is given.

73. What is the DATEPART function?

It returns date function as an integer. However, DATENAME function does the same thing, except it returns the name of the part of the date.

74. What does DATEDIFF function do?

This function gives a difference between 2 dates based on the specified Date part.

75. What is the use of ENDSWITH function?

ENDSWITH function helps you to return the logical result to the given string. In case If the sub-string is available at the end of the sub string, then it returns TRUE.

76. What is IFNULL function?

If the value is not NULL iFNULL function result is the first expression, if it is not, then it will return the second expression.

77. What is the use of INDEX Function in Power BI?

INDEX function helps you to retrieve the index of the respective row.

78. What is the main difference between LTRIM and RTRIM?

LTRIM function helps you to remove the white space from the LEFT of the string. RTRIM helps you to remove it from the right the last index.

79. What is the use of MID function?

MID function returns the string character from the specified index position.

80. How can you apply percentile function in Power BI?

PERCENTILE function allows you to returns the data value of the specific percentile number.

81. What is the SIGN function?

Sign function returns the direction of the values. If it returns 1, if positive then 1, if 0 then 0.

82. What is the use of statewith function?

This function returns the logical answers TRUE if the sub-string is the starting string for the superstring. If it is not, it will return false.

83. What is the use of split function?

SPLIT function is used to split the string database on the given delimiter.

84. What is the need of signing up with business email?

Power BI is not supporting, the email address given by telecommunications or consumer email service providers. Thus, there is need for signing up with work email.

85. Name the market place where you can download the Power BI mobile apps.

App store
Google Play
Window Store

86. In which year Microsoft invented Power BI Embedded?

In, the year 2016 Microsoft discharged new administration which is named as Power BI Embedded.

87. What area do you go to change and reshape data in Power BI?

Data Editing helps you to change and reshape data in Power BI.

88. Data Category settings should be used for mapping information to geographic areas in Power BI?

Scope and Longitude (e.g. 47.6080, – 122.3351)

89. What do you use as a consolidate inquiry in Power BI?

Join Queries are used as a consolidate inquiries in Power BI

90. What is the option to unpivot data in the question proofreader?

Unpivot line is a choice to unpivot any data in the question proofreader.

91. What is the process to refresh Power BI reports when it is uploaded into the cloud?

Power BI, reports can be refresh using Data management, gateway, and Power BI Personal Gateway.

92. What visual would you need to use to show solitary esteem?

Disseminate Plat is a visual you should use to show solitary esteem.

93. Which of the following Power BI memberships allows you the right permit to see Power BI content with the various Power BI applications?

Power BI Premium P1 is an application which gives this type of solutions for you.

94. Which field composes can be added to the Field well of a Slicer visual?

Computing segments should be made with a DAX articulation.

95. What is the M dialect capacity to sort a segment in inquiry supervisor?

The command for this purpose is Sort-> Table

96. Which Power in BI visual is ideal for estimating execution against an objective?

Projectile Power Bi visual is most fitting for this purpose.

97. What context style is allowed by Power BI DAX?

Power BI DAX content style is both Row and Filter.

98. In, Power Bi, where do you discover the Q&A highlight?

You will get at the highest point of a report in the Power BI benefit.

99. How can you dynamically change the value measure to show multiple measures?

You can do this by using harvesting measure and switch function.

100. What is self-service business intelligence?

Self-service Business Intelligence SSBI is a method to deal with data investigation which empowers business clients to channel, fragment, and break down their data, without top to the bottom specific information.

101. What is Power BI DAX style?

It is both Row and Filter Context

More :

Power BI vs Tableau

What is Power BI Desktop?

Power bi for mac

Power BI Tutorial