Power BI Interview Questions and Answers
In case you’re searching for Power BI Interview Questions and answers for Experienced or Freshers, you are at the correct place. There is parcel of chances from many presumed organizations on the planet. The Power BI advertise is relied upon to develop to more than $5 billion by 2020, from just $180 million, as per Power BI industry gauges. In this way, despite everything you have the chance to push forward in your vocation in Power BI Development. Gangboard offers Advanced Power BI Interview Questions and answers that assist you in splitting your Power BI interview and procure dream vocation as Power BI Developer.
We have prepared a set of best Power BI interview question and answers for beginners and professionals to excel the interview process with ease. These Microsoft Power BI interview question and answers help you gain knowledge on frequently asked interview questions by interviewers in the best companies. We will not only provide you with these limited set of power bi interview question and answers but also update with new questions regularly. Have a glance at these best interview questions to crack the interview process on power bi. Kickstart your career by taking help of the best set of Power BI interview questions prepared by industry experts.
Before you go through Power BI interview questions and answers, let’s give you a brief intro on Power BI. Power BI is developed by Microsoft, it is essentially a business analytics solution which enables you to visualize your data and share it across your organization or embed it into your websites or applications. Power BI has been a major contribution for the growth of Microsoft. With power bi users can create reports and dashboards without having the need to rely on information technology staff. It has a market share about 11.84% and used by major companies like Mortenson, Organogenesis Inc, Ideal Concepts etc. Microsoft Power BI is mainly used in industries like Technical, Retail, Manufacturing, Finance, Transportation etc.
Best Power BI Interview Questions and Answers
Do you believe that you have the right stuff to be a section in the advancement of future Power BI, the GangBoard is here to control you to sustain your vocation. Various fortune 1000 organizations around the world are utilizing the innovation of Power BI to meet the necessities of their customers. Power BI is being utilized as a part of numerous businesses. To have a great development in Power BI work, our page furnishes you with nitty-gritty data as Power BI prospective employee meeting questions and answers. POwerBI Interview Questions and answers are prepared by 10+ years experienced industry experts. Power BI Interview Questions and answers are very useful to the Fresher or Experienced person who is looking for the new challenging job from the reputed company. Our Power BI Questions and answers are very simple and have more examples for your better understanding.
By this Power BI Interview Questions and answers, many students are got placed in many reputed companies with high package salary. So utilize our Power BI Interview Questions and answers to grow in your career.
Q1) What are the building blocks of Power BI?
Answer: Power map, power view, power pivot, power query, power BI desktop, power Q & A.
Q2) What is Vizualization?
Answer: Visualization is a process of representing the data in pictorial form like graphs or tables or charts based on the requirements.
Q3) What is a Dashboard?
Answer: Dashboard is used to visualize the stratagic data of one or multiple reports in a glance.
Q4) What are the Different types of filters?
Answer: Filters are broadly classified into three types based on their levels and they are as follows
- visual level filter
- report level filter
- page level filter.
Q5) What are Tiles in Power BI?
Answer: it is a feature of power BI services and can be said as a still of the data or snap shot of the data which can be pinned to the dashboard.
Q6) What is on-premise Gateway?
Answer: On premise gate way acts as a bridge which is used to transfer the data which is on premise (not on cloud ) in a safe and secure way .
Q7) What is Content Pack?
Answer: Content pack is used to share the data ,data sets or dashboard with the people in the organization ,it takes place over BI website and can be shared with multiple people also.
Q8) What is DAX?
Answer: It is used for creating Expressions and formulas , and is a library of functions and operators.
Q9) What are the features of DAX?
Answer: Dax is a library which is a collection of functions and operators which can be used in formulas to calculate one or more values and it in a simple way it is all about creating new information from data that already exists in your model.
Q10) What is difference Between SUM() and SUMX()
Answer: Sum function takes the columns of data and aggregate it and will give the total but sumX function lets you filter the data which you are adding
Q11) How the Filter DAX is used?
Answer: FILTER DAX, it is used to filter the data in column based way depending on the functions, FILTER(Table,[Sales] > 100)
Q12) What is difference CALCULATE() and CALCULATETABLE()?
Answer: The difference between calculate and calculate Function is that Calculate excepts and returns a single value , where ass calculate table except and returns a table. Calculate: It is used to produce a single value , whereas Calculate Table is used to Produce a whole table.
Q13) What is a Report?
Answer: Report is a feature of Power BI , which is a result of visualized data from a single data set ,A report can have multiple pages of visualization.
Q14) What are the advantages of Power BI?
- Integrates well with the existing application
- It contains Rich and personalized Dashboards.
- Publishing of reports in a secured way
- Quick accessibility to data which means there is no memory and speed issue.
Q15) What are different connectivity modes in Power BI?
- Direct Query
Q16) What is Excel BI Tool kit?
Answer: It can be explained as the plugins of the Excel which enables to shape, transfer, create and Project the analysed data are Power Query, Power View, Power Pivot, Power Map which are said to be the heart of the Power BI and which gives it a boost.
Q17) What is Data refresh?
Answer: Data refresh is a feature of Power BI that connects to an external or on premises data source and refreshes the data of the dataset with in the power BI service and not in the local file.
Q18)What are data alerts?
Answer: Alert work on data that is refreshed ,when data is refreshed BI looks for an alert and if it reaches the alert threshold or the limit then the alert will be triggered.
Q19) Why TOP N is not available for the Page level and Report Level Filter?
Answer: As the page level filter and report level filters are associated with multiple visuals.
Q20) What is a calculated column?
Answer: it can be defined as calculating expression of DAX where the data in a row is calculated and stored in a new column.
Q21) What is a Bookmark?
Answer: Using bookmarks in Power BI result in capturing the configured view of a report page in that particular time which also included filters and the state of visuals, where this bookmark can be used a short cut to come back to the reports that you add as a bookmark.
Q22) What is a slicers?
Answer: it is a canvas visual filter which is used in Power BI desktop where users who are viewing can segment the report by using values like geometric region ,it is one of the important filter in visualization.
Q23) what are synchronize slicers?
Answer: It is a feature in Power Bi which helps to synchronize the slicers over multiple reports.
Q24) What is a parameter? How and where we set it?
Answer: Parameter is the value you wanted to receive from user on live time, it can be set in Power Query editor by selecting manage parameters and setting it up with the respective fields of the table/sheet parameter can be defined as set of input values which are set depending up on the requirement.it can be set as follows select manage parameters<<power query editor <<set it up with the respective fields of the table/sheet.
Q25) How to show the value in percentage?
Answer: Select the visual calculated value in the visualization tab -> select the below arrow -> show value as -> percent of grant total Select the visual calculated value in the visualization tab -> select the below arrow -> show value as -> percent of grant total.
Q26) how to setup hierarchy in Power BI?
Answer: When you have set of fields that is on hierarchy eg. Product Category and Product names, you can set up hierarchy by dragging the product name over the product category so that a new hierarchy field is created where we can drill down the data and see the detailed data consider you have list of countries and cities you can create hierarchy as follows in the fields pane << drag city field onto country field<< the hierarchy will be created.
Q27) What is Power BI Service?
Answer: Power BI Service is a cloud based analytic solution where it helps you to design reports, create dashboards and publish ,collaborate and share the reports with internal and external stakeholders power Bi service is a cloud based solution which is used to make reports ,visualization of data ,creating dashboards so that one can publish collaborate and share among the stake holders.
Q28) What are the different components in Power BI?
Answer:The different components we use in power bi are Power BI Service, Power Query, Power Pivot, Power View, Power Map, Data Management Gateway, Power BI Q&A, Data Catalog, Power map ,power view ,power pivot ,power query ,power BI desktop ,power Q & A.
Q29) What is power BI Desktop?
Answer: Power BI desktop is a free application which can be installed in your local files and can be used for visualzing and tranforming the data and making dashboards with it.
Q30) What are the different DAX Functions?
The different DAX functions are
- 1.Aggregation functions,
- Counting functions,
- Logical functions,
- Information functions,
- Text functions,
- Date functions”
Q31) What are the mostly used DAX Functions?
Answer: The mostly used aggregate DAX are MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT, for conditional DAX AND, OR, SWITCH are available others are ISBLANK, ISFILTERED, ISCROSSFILTERED, ALL, FILTER, CALCULATE, INTERSECT, EXCEPT, NATURAL INNER JOIN, NATURALLEFTEROUTERJOIN, SUMMARIZECOLUMNS, ISEMPTY,VAR, GEOMEAN, MEDIAN, DATEDIFF.”
Q32) What is known as query collapsing?
Answer: process of converting the steps in power query editor to sql and executing it by source database.
Q33) What is data source filter?
Answer: it is a parameter to filter the data before loading into machines.
Q34)What are the advantages of using variables in power bi?
Answer: Variables are used to create more logical Queries and can be used for multiple DAX functions.
Q35) How to Calculate MTD WTD and YTD in Power BI?
Answer: We can use DAX Formulas to find MTD, YTD and WTD as given below YTD_Sales = CALCULATE(Sum(Sales[Sales_Product]),YEAR(Sales[CreatedDate])=YEAR(TODAY())) ,MTD_Sales = CALCULATE(sum(Sales[Sales_Product]),MONTH(Sales[CreatedDate])=MONTH(TODAY())), WTD_Sales = CALCULATE(sum(Sales[Sales_Product]),WEEKNUM(Sales[CreatedDate])=WEEKNUM(TODAY()))
Q36) How to use calculate DAX Function?
Answer: Calculate function is mostly used in power BI from simple filters to Complex functions.
Q37) What is very unique in case of CALCULATE DAX Functions?
Answer: changes can only be made to filter context of measurer by using calculate DAX.
Q38) What is the need of selection pane in Power BI?
Answer: Selection Pane is used to have control over vizuals which needs to displayed and which need not to be displayed and also helps us to combine multiple vizual page in group and is also used in book marking.
Q39) What is x-velocity in memory Concept?
Answer: X-velocity in memory concept is the main engine used in power pivot. It helps to load the even large set of data into Power BI and visualize immediately without any lags.
Q40) How to Handle Many to Many Relationship in Power BI?
Answer: Crossfiltering option can be used in power BI to address the Many to Many relationship.
Q41) List out the Key Components in Power BI?
Answer: There are different components in Power BI as listed below,
- Power BI Service
- Power Query,
- Power Pivot,
- Power View,
- Power Map,
- Data Management Gateway,
- Power BI Q&A,
- Data Catalog”
Q42) What is the language used in Power Query Editor?
Answer: Power Query editor uses M language , it is a programing language and is also case sensitive.
Q43) What is a custom Vizuals?
Answer: Graphs or visuals which are not availabe in Bi desktop are imported from market for better visualization.
Q44) How to connect Power BI to Mysql Database?
Answer: One should install mysql database and use host name and credentials to connect to power bi.
Q45) Can we have multiple active relationship in Power BI?
Answer: No, We cannot set up more than one active relationship in Power BI.
Q46) What could be the difference between Distinct() and Values() in DAX?
Answer: The Distinct() and Values() are same but Distinct calculates the null values also.
Q47) What is difference between MAX and MAXA functions?
Answer: if the calculation is for numeric values then use MAX ,if it is for non numeric values then use MAXA.
Q48) What is What if parameter in power bi?
Answer: When you wanted to put a scenario and based on scenario you wanted to see the visuals, the best is What if parameter. It could help us with forcasting data and do an advanced analytics. Eg. IF we set up the discount of product from whatif parameter from 1 to 20. and user can change the values and see the changes in sales, profit, margin, revenue etc. which helps in detailed analysis.
Q49) What is incremental refresh?
Answer: it is used refresh the newly added data so that there is no need to truncate and load the entire data.
Q50) What is powerBI?
Answer: PowerBI is a business analytical solution, Which makes easy to connect data from Multiple data sources and make a data model which will be utilized by the across the organization and make easy to create rich visualization and sharing among organization. It makes easy to do slice and dice the metrics.
Q51) Different Products in PowerBI family?
- PowerBI Desktop
- PowerBI Service
- PowerBI Mobile Apps
- Onpremises Gateway
- PowerBI Report Server
Q52) What are the kind of Licences are available in PowerBI?
- Power BI Free
- Power BI Pro
- PowerBI Premium
Q53) What are the three main tabs in Reports development Window?
- Relationship tab
- Datamodeling Tab
- Report Tab
Q54) How many default Graphs(Visualizations) in Power BI?
Answer: 26 Views
Q55) What are three Important Tasks in Creating Dashboards in PowerBI?
There are three main Important Steps involved in creating Dashboard
1.Make sure the proper relationship between tables.
2.Data modeling according the requirement
3.Creating Reports with suitable Graphs which make sense
Q56) What are building blocks PowerBI?
Q57) What are the different filters in PowerBI?
- Visual Level filters
- Page Level Filters
- Report Level Filters
Q58) What is the difference Between Filter and Slicer?
Answer: By using the Normal filters User cannot interact with the Report or Dashboard, but with slicer user can have an interaction with Reports and Dashboards
Q59) What is parameter?
Answer: Parameter is a Dynamic Filter, It can be used in the calculation Fields, based on the parameter value result will be changed.
Q60) What are the data types in Power BI?
Q61) Difference Between New Measure and New column?
- If we create New Column based on some Logic physically data will be stored.
- If we create New measure based on some logic the calculations will be performed on the fly based on the dimension which we use,so here data physically will not be stored.
Q62) What is DAX?
Answer: Dax (Data Analysis Expressions) is a Formulae expression language ,It can be used in different BI tools, This is the combination of multiple functions which will be helpful in data Analysis Calculations
Q63) What are the different joins in Power BI?
1.Vertical Joins will be used in Merging the data from multiple tables
2.Horizontal Joins will be used in appending the data from Multiple tables
Q64) Can we have more than one active relationship between two tables?
Q65) What is meant by Gateway and what are its different types?
Answer: Gateway acts as an extension between on premise datasource and azure cloud administration.
- Individual Gateway
- On Premise Gateway
Q66) What are the two ways to use power bi?
- Power BI service
- Power BI desktop
Q67) What is Power BI service?
Answer: Power BI service is a cloud-based application which is hosted in com.
Q68) What is Power BI desktop?
Answer: Power BI desktop is a free – open source application which can be installed in your PC. The reports developed in power bi can be published to Power BI service.
Q69) What are the features of Power BI desktop?
- Able to pull in data from variety of sources
- Create relationships between your data and enrich your data model
- Create and save your reports
- Upload and publish your reports.
Q70) In terms of Pricing, how can power BI be categorized?
- Power BI (Free)
- Power BI Pro (Licensed)
Q71) What are the different types of refresh in Power BI?
- Package Refresh
- Model/data Refresh
- Tile Refresh
- Visual Container Refresh
Q72) What are the different connectivity modes in Power BI?
- Import Mode
- Direct Query Mode
Q73) What is meant by Gateway and what are its different types?
Answer: Gateway acts as an extension between on premise datasource and azure cloud administration.
- Individual Gateway
- On Premise Gateway
Q74) What is Content Pack?
Answer: The Content pack can have dashboards, reports and relevant data bases which can be shared across to clients
Q75) What is Embed Code?
Answer: There is an option in Power BI online (Power BI service) that publish to web which will generate a link address for the power BI report. This link can be shared across to clients.
Q76) What are the different components in Power BI application?
- Power BI desktop
- Power Pivot
- Power Query
- Power VIEW
- Power MAP
Q77) What are the report components available in Power BI?
- Data sets
Q78) How do create actions and navigations in Power BI?
Answer: To Navigate to a certain report on click, you must Book mark a page and assign the book mark to a button or icon.
Q79) How to Group different columns existing in a data set?
Answer: Grouping the columns of a data set can be achieved in DAX using summarize ()
Q80) How to toggle between two options and make it interact with rest of the visualizations in repor?
Answer: Toggling Action can be achieved in Power BI reports, when in case there are two are more dimensions. This can be showcased using an “Enlighten Slicer” in Power BI which can be imported form Market Place.
Q81) How can you identify which user has logged in to Power BI server or viewing the report from Power BI?
Answer: The way to identify the user is to create a DAX column and embed “username ()” or “principalusername ()”, which will retrieve information on the user has logged in.
Q82) How do you filter on all the reports in a specific page in Power BI dashboard?
Answer: The column or data that is to be filtered across all reports in Page should be dragged to “Page Level Filter Section” which will help the same.
Q83) How do u hide and unhide a specific report in Power BI?
Answer: We have to go to selection Pane in the menu bar and hide/unhide the report and the action can be passed to book mark.
Q84) Which chart can be used to represent two different measures in dual axis in Power BI?
Answer: The simple work around to form dual axis in Power BI is to use a “Line and Clustered Chart” embedding two different measures to Line Values and Columns Value.
Q85) How can u download excel files which has millions of records from a Power BI report?
Answer: To download large extracts of data, we can host the excel file to a share point, which will generate a .xlsx link, which can be embedded to “Text” or “Button”. On clicking on the Text link or Button. The excel file gets downloaded directly which is hosted in share point or some other base location.
Q86) How do you compare Target and Actual Values from a Power BI report?
Answer: To compare two different measure, we have to use a Gauge Chart from where the Target and Actuals can be inferred.
Q88) How to represent different levels of hierarchy of data in one singe visualization?
Step 1. Create a hierarchy by grouping the required data from the data tab and pull that into Axis Tab and Enable drill down option by clicking on down arrow on the chart.
Step 2. Pull all the hierarchical columns separately in to the axis pane in the order of their hierarchy and enable the drill down action by clicking on down arrow on the chart.
Note: Both Step 1 and Step 2 will serve the same purpose.
Q89) Which language is used along power query?
Answer: There is a language called M-Code which is used along with power query and it is also easy to use and highly case sensitive.
Q90) What is power pivot?
Answer: It is a data modelling component which allows data compression, aggregation and calculation very efficiently.
Q91) What is power query?
Answer: It is a self-service ETL (“Extract”Transform” Load) tool and allows users to pull data from different sources.
Q92) What is power view?
Answer: It is a visualization tool which allows users to drag and drop for easy and quick visualisation.
Q93) What is power map?
Answer: It is 3D data visualiation tool which allows users to create interactive visualization on tables and charts.
Q94) What is DAX?
Answer: It is a formula expression language which could be used in different BI and visualisation tools.
Q95) What is calculate function?
Answer: It is a function which evaluates expression which modified by filters.
Q96) What is Filter function?
Answer: It is a function which allows you to manipulate data to create dynamic calculations.
Q97) What is Time Intelligence function?
Answer: It is a function which allows to manipulate data using time periods.
Q98) How to setup hierarchy in Power BI?
Answer: When you have set of fields that is on hierarchy of importance eg. Item Category and Product names, you can set up chain of importance by hauling the item name over the item class with the goal that another pecking order field is made where we can penetrate down the information and see the point by point information think of you as have rundown of nations and urban communities you can make progressive system as follows in the fields sheet << drag city field onto nation field<< the chain of importance will be made.
Q99) What is Power BI Service?
Answer: Power BI Service is a cloud-based explanatory arrangement where it causes you to configuration reports, make dashboards and distribute ,team up and share the reports with inner and outer partners control Bi administration is a cloud based arrangement which is utilized to make reports ,perception of information ,making dashboards so one can distribute work together and share among the partners.
Q100) What is a custom Vizuals?
Answer: Diagrams or visuals which are not availabe in Bi work area are imported from market for better perception.
Q101) What are the sort of Licenses are accessible in PowerBI?
- Power BI Free
- Power BI Pro
- PowerBI Premium
Q102) What are the three fundamental view in Reports improvement Window?
- Relationship View
- Data modeling View
- Report View
Q103) Can we have various dynamic relationship in Power BI?
Answer: No, We can’t set up more than one dynamic relationship in Power BI.
Q104) What is incremental refresh?
Answer: it is utilized invigorate the recently included information so that there is no compelling reason to truncate and stack the whole information.
Q105) How many default Graphs Visualizations in Power BI?
Answer: 26 Views
Q106) What are the Data types in Power BI?
- Numeric(Decimal,Fixed Decimal,Whole)
Q107) Difference Between New Measure and New column?
Answer: On the off chance that we make New Column dependent on some Logic physically information will be put away.
On the off chance that we make New measure dependent on some rationale the figurings will be performed on the fly dependent on the measurement which we use, so here information physically won’t be put away.
Q108) What are the various participates in Power BI?
Answer: Vertical Joins will be utilized in blending the information from various tables
Flat Joins will be utilized in attaching the information from numerous tables
Q109) Can we have more than one dynamic connection between two tables?
Q110) What are the parts of Power BI?
- Power BI work area
- Power BI Online Service
- Power BI passage
- Power BI Report Server
- Power BI Mobile Apps
Q111) What are Building Blocks in Power BI?
Q112) What is Visualizations?
Answer: Perception is a visual description of information. Model: Pie Chart, Line Graph, Side by Side Bar Charts, Graphical Presentation of the source information over Geographical Map, Tree Map, and so forth.
Q113) What is Datasets?
Answer: Dataset is a gathering of information that Power BI uses to make its representations. Eg-Excel sheets and Oracle or SQL server tables.
Q114) What are reports?
Answer: Report is a lot of perceptions that show up commonly on at least one pages. Eg-Sales by Country, State, City Report, Logistic Performance report, Profit by Products report and so on.
Q115) What is Dashboards?
Answer: Dashboard is single layer appearance of various perceptions, i.e we can consolidate at least one representations into one page layer.
Eg:Sales dashboard can have pie outlines land maps and bar graphs.
Q116) What is Tiles?
Answer: Tile is a solitary perception in a report or on a dashboard. Eg:Pie Chart in Dashboard or Report.
Q117) What are the different sorts of Filter in Power BI Reports?
- Visual Level Filter
- Page Level channel
- Report Level Filter
- Drill through Filter
Q118) What is Visual level Filters?
Answer: These channels take a shot at just a being representation decreasing the measure of information that the perception can see additionally visual dimension channels can channel the two information and computations.
Q119) What is Page level Filters?
Answer: These channels work at the report page level. different pages in a similar report can have different page level channels.
Q120) What is Report level Filters?
Answer: There channels take a shot at the entire report sifting all pages and representations worked in the report.
Q121) What are the principle parts of the Power BI toolbox and what do they do?
- Power Query-gives you a chance to discover get to and combine information from various sources
- Power Pivot-a displaying device
- Power View-an appearance device for making diagrams tables and that’s only the tip of the iceberg
- Power Map-gives you a chance to make geospatial portrayal of your information
- Power -gives you a chance to utilize common language to find solutions to questions.
Q122) What is a substance pack, and for what reason would you utilize one?
Answer: A substance pack is an instant, predefined gathering of representations and reports utilizing your picked administration (for instance, Sales power). You’d utilize one when you need to get fully operational rapidly, rather than making a report without any preparation.
Q123) What are probably the most well known hotspots for information in the Get Data menu?
Answer: Exceed expectations, Power BI datasets, web, content, SQL server and investigation administrations.
Q124) What are the classes of Data types?
- Power BI
- Online Services
Q125) Name some regularly utilized undertakings in the Query Editor.
- Connect to information
- Shape and join information
- Group columns
- Pivot segments
- Create custom segments
- Query equations
Q126) What is DAX ?
Answer: So as to do information investigation on information and for figuring in power rotate, Data Analysis DAX) is utilized.
- Dax takes a shot at segment esteems
- We can change or put in information utilizing DAX
- The determined sections can be determined however the equivalent is impossible for columns utilizing DAX
Q127) What are the network modes accessible in Power BI?
Answer: Fundamentally there are two kinds of availability modes
Q128) What are the various sources that you worked away at ?
Answer: Power BI bolsters huge scope of information sources. You can snap Get information and it demonstrates to all of you the accessible information associations. It enables you to associate with various level files,SQL database, and Azure cloud or even web stages, for example, Face book, Google Analytics, and Salesforce objects
Q129) What information sources would i be able to associate with?
- The rundown of information hotspots for Power BI is broad, however it very well may be assembled into the accompanying:
- Content packs for administrations, with instant dashboards, reports, and datasets for administrations, for example, Salesforce. Notwithstanding building up an information association, Power BI gives pre-fabricated dashboards and reports for every one of these administrations.
- Connectors to databases and different datasets, for example, Azure SQL Databaseand SQL Server Analysis Services forbidden information.
Q130) What are the different Excel BI include ins?
- Power Query—discover, alter and load outside information
- PowerPivot—for information displaying for investigation
- Power View—structure outwardly and intuitively reports
- Power Map—show bits of knowledge on 3D Map
Q131) Types of Data Refresh in Power BI
- Bundle Refresh
- Model/information invigorate
- Tile invigorate
- Visual compartment invigorate
Q132) How will you share your Power BI report to customer?
- Substance Pack
- Install Code
Q133) What is install code in power BI
Answer: We have a choice in Power BI online that convey to web which will create a connection address for the demanding Power report. We can share that connect to our customer to view Power BI report with no sign in/login conventions.
Q134) What are the gateways available in Power BI?
- On-premises information door:
- On-premises information door (Personal mode)
Q135) How to apply information security in Power BI report?
- A DAX look can be valuable on a table sifting its lines at question time.
- Dynamic security include the utilization of USERNAME works in security job definition.
- typically a table is made in the model that relates clients to explicit measurements and a job.
Q136) What is Natural language search choice in Power BI?
Answer: A characteristic language based learning for communicate with information as a feature of the Power BI for Office 365 advertising.
As you type your inquiry picks the best perception to show your answer; and the representation changes powerfully as you alter the inquiry. Likewise causes you group your inquiry with recommendations, auto-complete, and spelling amendments.
Q137) Can we join two unique information sources in same Power BI dashboard?
Answer: Indeed. It is conceivable in Power BI. In Power BI Online, we can blend perception from comparable reports in your Power BI account into one single dashboard utilizing pin independent of the information sources.
Q138) What is the contrast between Power BI Desktop and Power BI on the web?
Answer: Power BI Desktop is a windows application which be fit for be kept running on our constrained PC. Power BI work area can be utilized to build up the reports interface with assortment of information source from our PC to the information in the neighbourhood PC or the information in the server. We can circulate the report from Power BI work area to Power BI online once finished the improvement.
Power BI is a cloud based arrangement. We can apply internet browser to interface with Power BI on the web. We have the option to play out a similar advancement take a shot at Power BI online however a few restrictions there.
Q139) What is the contrast among SUM and SUMX in DAX work?
Answer: Total capacity takes the sections of information and total it and will give the aggregate however sumX capacity gives you a chance to channel the information which you are including
Q140) How the Filter DAX is utilized?
Answer: Channel DAX, it is utilized to channel the information in section put together path depending with respect to the capacities, FILTER(Table,[Sales] > 100)
Q141) What are Data alarms
Answer: Ready work on information that is revived ,when information is invigorated BI searches for a caution and on the off chance that it achieves the ready edge or the utmost, at that point the alarm will be activated.
Q142) Why TOP N isn’t accessible for the Page level and Report Level Filter?
Answer: As the page level channel and report level channels are associated with different visuals.
Q143) What is a Bookmark?
Answer: Utilizing bookmarks in Power BI bring about catching the arranged perspective on a report page in that specific time which additionally included channels and the condition of visuals, where this bookmark can be utilized an easy route to return to the reports that you include as a bookmark.
Q144) What are slicers?
Answer: It is a canvas visual channel which is utilized in Power BI work area where clients who are survey can section the report by utilizing esteems like geometric district ,it is one of the significant channel in representation.
Q145) What are synchronizing slicers?
Answer: It is a component in Power Bi which synchronizes the slicers over various reports.
Q146) What is a parameter? How and where we set it?
Answer: Parameter is the worth you needed to get from client on live time, it tends to be set in Power Query supervisor by choosing oversee parameters and setting it up with the individual fields of the table/sheet parameter can be characterized as set of information esteems which are set depending up on the requirement.it can be set as pursues select oversee parameters<<power question editorial manager <<set it up with the particular fields of the table/sheet.
Q147) How to demonstrate the percentage in rate?
Answer: Select the visual determined an percentage in the perception tab – > select the underneath bolt – > show an incentive as – > percent of give all out Select the visual determined an incentive in the representation tab – > select the beneath bolt – > show an incentive as – > percent of give all out.
Q148) What is ceiling function?
Answer: Ceiling functions is equivalent to roundup in excel. It do work in transform data to another format as like 3.12 results 4
Q149) What is the Collect function?
Answer: Excluding null values it do aggregate the spatial values. It cannot be performed anything other than Spatial data type.
Q150) What does Contains function do?
Answer: Contains function works in a way of producing logical results for the given character against the argument. Simply, TRUE if string have sub-string.
Q151) What is CORR function? Where we use it?
- CORR is a correlation function. It gives Pearson correlation between 2 variables. It ranges from -1 to 1.
- Where 1 refers 100% positive correlation, -1 refers 100 negative correlation and 0 refers no correlation between those variables.
Q152) What is the difference between Count and CountD function?
Answer: COUNT function returns count excluding NULL values. COUNTD returns distinct values excluding NULL values.
Q153) What does COVAR function do?
Answer: COVAR function gives the sample covariance for the given arguments. Co-variance is stated as the factor which talks about the relationship between each other and how much one variable is affected by another.
Q154) What is the difference between COVAR and COVARP?
Answer: COVAR directly gives the sample co-variance where COVARP is the population co-variance. Sample uses n-1 for calculation and population uses n. Where n is the number of line items.
Q155) What is Date function?
Answer: Date function converts any input to a date format. Input can be string, number or a date type input.
Q156) What does DATEADD function do?
Answer: This function adds a specified date interval for a specific part of date. Can be a day/month/year.
Q157) What does DATEDIFF function do?
Answer: It gives the difference between 2 dates based on the specified Date part. Could be possibly Day/week/month/year.
Q158) What do DATENAME function do?
Answer: DATENAME function results the name of the specified part of the date that given. To be precise, it works in a way to produce the day(Monday/Tuesday/etc..), month(January, February/etc.) or year(2018/2019/etc.)
Q159) What is DATEPARSE function is used for?
Answer: DATEPARSE function returns the date type object from a string input. If a data is stored in string property and must be changed to Date type, we can use DATEPARSE function to do it.
Q160) What is DATEPART function?
Answer: DATEPART function returns the part of the date function as an integer, where DATENAME function does the same, but returns the name of the part of the date.
Q161) What is the difference between DATE and DATETIME function?
Answer: DATETIME function returns the date and time type for the given number, where DATE function gives DATE type.
Q162) What is DATETRUNC function do?
Answer: DATETRUNC function gives you the truncated date to the respective time period you specify. In simple words, you wanted to achieve the first date of a month for all dates of the month, you can apply DATETRUNC function to transform all the dates to the first day of that month. It applies to month, week, quarter and year.
Q163) What does the ENDSWITH function do?
Answer: Endswith function used to return the logical results to the given string. If the sub-string is available at the end of the super string, then it returns TRUE.
Q164) What does the function FIND used for?
Answer: FIND function is used to return the index position of the substring from the super string.
Q165) What is FIRST function?
Answer: FIRST function gives the index offset for all rows from the current row. It gives the negative index values as such to give exact offset value.
Q166) What does function FLOAT does?
Answer: FLOAT function transforms the date type to float from integer. All values parsed will be converted to FLOAT from the given data type.
Q167) What is FLOOR function?
Answer: FLOOR function returns the nearest lesser integer value. Say you apply this function for 3.85, it will result you 3. Which is equivalent to round down in excel. Note that, this function is data source limited. It is not applicable for all data source.
Q168) What does the function FULLNAME does?
Answer: FULLNAME function returns the username from the local system. If it is connected to online profile, it returns the online profile username.
Q169) Is there a function to do a simple IF ELSE query?
Answer: IIF is the function which performs IF ELSE statement. It works in a way to generate the IF this else what scenario.
Q170) What is IFNULL function?
Answer: IFNULL function works in a way to produce IF it is not a NULL, then result the first expression, if not, return the second expression.
Q171) What does INDEX function do?
Answer: INDEX function is used to retrieve the index of the respective row. It works in the reverse way of FIRST function. FIRST function gives the offset index starts from 0. Index function starts with 1 and incremented by 1.
Q172) What is ISDATE function?
Answer: ISDATE function returns the Logical result TRUE/FALSE on a string data type. If it is returnable as Date, then it returns TRUE, if not FALSE.
Q173) What does ISNULL function do?
Answer: ISNULL produces logical results whether it is a NULL or not. If it is NULL, it returns TRUE, if not it returns FALSE.
Q174) What is the difference between the function FIRST and LAST?
Answer: LAST function returns the index offset values from the last row element. It works as the reverse of FIRST function. Index value of last row element starts with 0.
Q175) What is LEFT and RIGHT function do?
Answer: LEFT function returns the n number of characters from left of the given string. Right function does the same work from right. N represents number of characters.
Q176) What does LOOKUP function do?
Answer: LOOKUP function returns the value in the given expression for the specified target row. NULL will be resulted if in case of no match found.
Q177) What is the difference between LOWER and UPPER?
Answer: LOWER function returns the lowercase for the string parsed. Where UPPER function returns the uppercase value for the given string.
Q178) What is the difference between LTRIM and RTRIM?
Answer: LTRIM function removes the extra white space from the LEFT of the string. RTRIM removes it from the right last index.
Q179) What does MAKEDATE function is used for?
Answer: For the given individual values as year, month and day, it generates a Date type object.
Q180) What does MAKETIME function is used for?
Answer: For the given individual values as Hour, minute and second, it generates a Date type object.
Q181) What does MID function do?
Answer: MID function returns the string characters from the specified index position. On the string, it can be possible to extract the number of positions that we required to have.
Q182) What is the difference between Today & Now functions?
Answer: TODAY function gives you the current today’s date, where as NOW function returns the current date and time along with.
Q183) How do we apply percentile function?
Answer: PERCENTILE function returns the data value of the specified percentile number. Make sure you have it in the range of 0 to 1. Also, it should be a numeric constant.
Q184) What is POWER function?
Answer: POWER function returns the POWER for the given number for the specified power.
Q185) What does rank function do? Compare other rank functions?
Answer: RANK function calculates the regular competition rank and returns the identical values. In the second argument, you can ask for Ascending or Descending values accordingly. Please refer the below image for different types of ranks listed.
Q186) What does replace function do?
Answer: REPLACE function replaces the sub-string found in super-String based on the given replacement. This function is as generic with SQL and Excel.
Q187) What is RUNNING_AVG function do?
Answer: RUNNING_AVG function gives the average value to all the cells/pane/region processed for. It works to give the average by making all those inclusive values accordingly.
Q188) What is SIGN function?
Answer: SIGN function returns the direction of the values. Say if the value is Negative, it returns -1, if positive then 1, if 0 then 0.
Q189) What does split function do?
Answer: SPLIT function works to split the string data based on the given delimiter. And returns the specific part of the text based on the token value. Note that split function is limited for some data sources. Cannot be applied to all data sources.
Q190) What does STARTSWITH function do?
Answer: SATRTSWITH function returns the logical answers in a way, TRUE if the sub-string is the starting string for super-string. FALSE if not so.
Q191) What is the difference between STDEV and STDEVP?
Answer: STDEV is the standard deviation formula for population(n). STDEVP is the function of standard deviation for sample(n-1).
Q192) What is the difference between VAR and VARP?
Answer: VAR is the variance formula for population(n). VARP is the function of variance for sample(n-1).
Q193) In general, what is the basic difference between regular functions and window functions?
Answer: Normal regular functions operate to generate expression for the whole data parts, but window functions limits itself with the offset from the current row where it produces different values accordingly.
Q194) What does Day, month & year function do?
Answer: Year function returns Year for the specified date, where Month function gives month & day function gives Day of the week respectively.
Q195) What is the difference between a report and dashboard in power BI?
Answer: Report is a page view of many visualizations, Where Dashboard is a final presentation or the final page which can be leveraged to have a solution extracted from multiple reports. In simple words, It is that which is the shorter version of reports in final format that answers business questions.
Q196) Specify the different types of filters?
Answer: In general, power BI filters are of 3 different types.
- Visual level filter
- Page level filter
- Report level filter
Q197) Do all the features of power pivot in excel is applicable in Power BI?
Answer: Mostly, not completely, it is because that, Power BI is mostly created for visualization rather than the transformation process. It do work lot effective comparing with Excel processing.
Q198) What is a Power BI?
Answer: Power BI by Microsoft is a cloud-based platform in which your unrelated sources of information are turned into coherent, interactive insights, and visualized format. With the help of collective work among connectors, software services, and apps, the data is transformed into the visualized format. The data that is transformed can be presented in Excel spreadsheets or the form of a cloud-based data-sharing environment.
Q199) Why we need Power BI?
Answer: There are many reasons for why we need Power BI, some of the reasons are as follows:
- To meet self-service and corporation business intelligence needs on a single platform we need Power BI.
- We need BI to create interactive data visualization insights across data centres.
- In finding solutions fast and accurate with the leading AI industry.
- Power BI is used to connect Excel queries with Power BI dashboards to make quick analysis and share business data in new ways.
Q200) What are the advantages of Power BI?
Answer: The advantages of Power BI are as follows:
- Power Bi provides us with an easy way to connect to your data sources and visualizes the information.
- It also creates quick insights from the local database or excel spreadsheets.
- Power BI even be your visualization tool, personal report, and decision engine for corporations and group projects.
Q201) List the features of Power BI?
Answer: The features of Power BI are as follows:
- Power BI is robust and ready for custom development, modeling, and real-time analytics.
- It creates an enhanced data-driven environment by enabling everyone to transform data into insightful visualizations.
- Power BI provides a platform to create quick and efficient custom apps and it also automates workflow to enhance business productivity.
- Provides security and built-in governance for your organization.
Q202) What are the differences between the Power BI service and Power BI Report Server?
|Feature||Power BI Report Server||Power BI service|
|Lifecycle||Services are managed fully||Modern lifecycle policy|
|Source data||Cloud or on-premises||On-premises or Cloud|
|License||Power BI Premium||Power BI Pro or Power BI premium|
|Creating of Reports||Creates Power BI Reports in Power BI Desktop||Creates Power BI Reports in Power BI Desktop|
|Gateway Requirements||No||Required for on-premise data sources|
Q203) Define the term ‘Power BI Desktop’?
Answer: Most of the people who work on Business Intelligence (BI) tasks use Power BI desktop to create reports. Power BI Desktop is a free application that we can download in our desktops to connect, visualize, and transform the data. By using this desktop we can combine different sources of data and finally combines this data into data models. These data models let your corporations build visuals and share them among other people in your organization.
Q204) What are the building blocks in Power BI?
Answer: There are five building blocks in Power BI, and they are:
- Datasets: Datasets can be defined as a collection of data, which is used by Power BI for creating visualizations.
- Reports: Reports are the collection of or group of visualizations that appear as a whole in one or more pages.
- Dashboards: Dashboard is the window that is mainly used to represent the collection of all the visuals on a single page.
- Visualizations: The visual representation of data in the form of charts, graphs, and the other is called visualization.
- Tiles: Collection of visualizations that appear on one or more pages.
Q205) What is a Power BI service?
Answer: Power BI service is an online cloud-based service for report editing and collaboration of teams. By using limited modeling we can connect different data sources in Power BI services.
Q206) What is the key difference between the Power BI Desktop and the Power BI service?
Answer: The significant difference between Power BI Desktop and Power BI service is that the BI desktop is used to create reports whereas, BI services are used to share the reports which are created by Business Intelligence Desktops.
Q207) Define Content Packs in Power BI?
Answer: The name itself says that the content packs are a collection or the package of various related documents or files or content.
Q208) How many types of Content Packs are there?
Answer: There are two types of content packs, and they are:
- Salesforce shared by other users in your organization.
- Services provided by Marketo and Google Analytics.
Q209) What are the business applications in which Power BI is used?
Answer: The following are the key business applications in which Power BI is used. They are:
- Used in an organization to find insights.
- Usage of Power BI in Mobile application development.
- In Visualizes Marketing leads and Sales in the Marketing Industry.
- For the retail industry and consumer goods.
- Power BI is the key application in the top airports like ‘Heathrow’.
Q210) What are the parts of Power BI?
Answer: The parts of Power BI include:
- Power BI Desktop
- Power BI service
- Power BI mobile apps
- Power BI Report Server
Q211) What is the Power BI Report Server?
Answer: In today’s World, Power BI Report Server is a solution for on-premises reporting with the flexibility of moving to the cloud in the future. This server also provides a way to manage and display KPIs and images.
Q212) What are the major components of Power BI?
Answer: The components of Power BI are as follows:
- Power View: It is a data visualization tool used to represent data in the form of charts or graphs.
- Power Map: Helps in processing the accurate Geo-spatial locations in the data sets.
- Power Pivot: Provides the way to data model the whole information.
- Power Query: It is a data transformation engine that is used to perform operations on the loaded data.
- Power Q&A: It provides easier ways for users to interact with reports using simple languages.
Q213) Define Power Pivot?
Answer: It is an Excel add-in used to create sophisticated data models and to perform effective data analysis. By using Power Pivot we can collect large volumes of data from different sources. In this, we can create data models and tables with relationships.
Q214) What is Power Query in Power BI?
Answer: Power Query is a mashup and data processing software which is mainly used to connect various data sources. The output that is generated by Power Query can either go to Power BI or Excel.
Q215) What is Power BI Embedded?
Answer: Power BI Embedded provides a simplified way to understand how developers and ISVs use Power BI capabilities using web analytics. The Power BI Embedded APIs are used for embedding reports and dashboards, this embedding provides access to the latest Power BI features app workspaces and gateways.
Q216) What is DAX?
Answer: DAX is abbreviated as Data Analysis Expressions, It is the formula language used by Power BI. These expressions are mainly used to perform data analysis and basic calculations in Power Pivot.
Q217) Define Tile in Power BI?
Answer: The single visualization on a Power BI Dashboard or in a report is called as tile.
Q218) Is Power BI free to use?
Answer: Well, Power BI provides a free trial version, but the best and advanced features of Power BI are accessible only if we have the Pro subscription account. Most of the business organizations use Power BI Pro to access the advanced features.
Q219) What are paginated reports?
Answer: These reports are the long standard reports in the SQL Report Server, now these reports are available in Power BI for use. The term ‘paginated’ means the reports designed are fit to the page.
Q220) How many types of filters are available in Power BI Reports?
Answer: Three types of filters are available in Power BI Reports, and they are:
- Report-level Filters
- Visual-level Filters
- Page-level Filters
Q221) How do we import and analyze data from a web page using Power BI Desktop?
Answer: Four steps are carried to import and analyze data from the webpage. They are:
- Go to get data option which is present in Hone Ribbon tab on Power BI Desktop and then select web option.
- Copy and paste the URL in the web dialog box and then click ok.
- After that, the connection is established to the particular URL, and the Power BI navigator dialog box shows the catalog of the tables on the page.
- Finally, select the Results(edit) in the Navigator page and then click edit. Now, the preview of the tables will be opened in the Power BI query editor in which we can analyze and transform the data from a web page.
Q222) Can the Power BI Report refreshed after they are published to the cloud?
Answer: Yes, By using gateways the Power BI Reports can be refreshed after they are published to cloud.