{"id":245,"date":"2022-05-03T06:38:44","date_gmt":"2022-05-03T06:38:44","guid":{"rendered":"https:\/\/gauthamit.com\/blog\/?p=245"},"modified":"2022-05-20T03:41:35","modified_gmt":"2022-05-20T03:41:35","slug":"power-bi-interview-questions-and-answers","status":"publish","type":"post","link":"https:\/\/gauthamit.com\/blog\/power-bi-interview-questions-and-answers\/","title":{"rendered":"Power BI Interview Questions and Answers"},"content":{"rendered":"

Power BI Interview Questions and Answers<\/strong><\/h2>\n

1.What is Power BI?<\/strong>
\nPower BI was introduced by Microsoft to combine the multiple data visualization features into one.
\nPower BI is the new term for the data-driven industry and thus carries a lot of opportunities on its shoulders. It comes as a package of three major components:
\nPower BI services
\nPower BI Desktop
\nPower BI mobile app
\nWith these three components, Power BI lets you create a data-driven insight into your business.
\nBased on various roles, you can leverage Power BI to your benefits like creating reports, monitor progress, integrate APIs, and many more.<\/p>\n

2.Why Power BI?<\/strong>
\nPower BI has simplified the workaround of getting data from various sources and collating them into one tool for proper management. We can share these interactive reports for different industries like retail, for free.
\nPower BI is the new flash word in the data-driven tech industry today. The power BI opportunities are umpteen and spread across versions. With proper knowledge of the tool you can easily grab
\nopportunities as a:
\nPower BI data analyst
\nPower BI developer
\nPower BI software engineer
\nPower BI project manager
\nSQL Server Power BI developer
\nPower BI consultant
\nWith good compensation, you get to work with a product\u2019s data and learn about its insights to make important decisions. Not just this, with the latest Gartner\u2019s BI and Analytics report, Power BI has emerged as the winner. With so much hype, learning Power BI is worth it.<\/p>\n

3.How would you define Power BI as an effective solution?<\/strong>
\nPower BI is a strong business analytical tool that creates useful insights and reports by collating data from unrelated sources. This data can be extracted from any source like Microsoft Excel or hybrid data warehouses. Power BI drives an extreme level of utility and purpose using interactive graphical interface and visualizations. You can create reports using the Excel BI toolkit and share them on-cloud with your colleagues<\/p>\n

4.What are the various refresh options available?<\/strong>
\nFour main refresh options are available in Power BI:
\nPackage\/OneDrive refresh: This synchronizes Power BI desktop or Excel file between the Power BI service and OneDrive
\nData\/Model refresh: This means scheduling the data import from all the sources based on either refresh schedule or on-demand.
\nTile refresh: Refresh the tiles\u2019 cache on the dashboard every time the data changes.
\nVisual container refresh: Update the reports\u2019 visuals and visual container once the data changes.<\/p>\n

5.What is a Power BI desktop?<\/strong>
\nTo access the Power BI features, visualize data, or model them to create reports, you can
\nsimply download a desktop version of Power BI. With the desktop version, you can extract
\ndata from various data sources, transform them, create visuals or reports, and share them
\nusing Power BI services<\/p>\n

6.Where is the data stored in Power BI?<\/strong>
\nPrimarily, Power BI has two sources to store data: Azure Blob Storage: When users upload the data, it gets stored here. Azure SQL Database: All the metadata and system artifacts are stored here. They are stored as either fact tables or dimensional tables.<\/p>\n

7.What are the available views?<\/strong>
\nIn power BI, you have various kinds of views viz:
\nData View: Curating, exploring, and viewing data tables in the data set. Unlike, Power Query editor, with data view, you are looking at the data after it has been fed to the model.
\nModel View: This view shows you all the tables along with their complex relationships. With
\nthis, you can break these complex models into simplified diagrams or set properties for them at once.
\nReport View: The report view displays the tables in an interactive format to simplify data
\nanalysis. You can create n number of reports, provide visualizations, merge them, or apply
\nany such functionality.<\/p>\n

8.What are the available formats?<\/strong>
\nPower BI is available in various formats:
\nPower BI desktop: For the desktop version
\nPower BI mobile app: For using the visualizations on mobile OS and share it
\nPower BI services: For online SaaS<\/p>\n

9.Power BI can connect to which data sources?<\/strong>
\nThe data source is the point from which the data has been retrieved. It can be anything
\nlike files in various formats (.xlsx, .csv, .pbix, .xml, .txt etc), databases (SQL database, SQL Data Warehouse, Spark on Azure HDInsight), or form content packets like Google
\nAnalytics or Twilio.<\/p>\n

10.What are the building blocks of Power BI?<\/strong>
\nThe major building blocks of Power BI are:
\nDatasets: Dataset is a collection of data gathered from various sources like SQL Server, Azure, Text, Oracle, XML, JSON, and many more. With the GetData feature in Power BI, we can easily fetch data from any data source.
\nVisualizations: Visualization is the visual aesthetic representation of data in the form of maps, charts, or tables.
\nReports: Reports are a structured representation of datasets that consists of multiple pages.
\nReports help to extract important information and insights from datasets to take major business decisions.
\nDashboards: A dashboard is a single-page representation of reports made of various datasets. Each element is termed a tile.
\nTiles: Tiles are single-block containing visualizations of a report. Tiles help to differentiate each report.<\/p>\n

11.What are content packs in Power BI?<\/strong>
\nContent packs are packages comprising different Power BI objects such as reports, dashboards, datasets, etc. The two types of content packs are:
\nService provider content packs: Service providers such as Google Analytics, Salesforce, etc.
\nprovide pre-built content packages User-created content packs: Users can create their content packages and share them within the organization<\/p>\n

12.What are the various Power BI versions?<\/strong>
\nThe three major versions of Power BI are as follows:
\nPower BI Desktop: The free interactive tool that connects multiple data sources, transforms
\ndata, and creates visualized reports. Power BI Premium: The premium version is used for larger organizations with a dedicated storage capacity for each user. With premium, data sets up to 50GB storage capacity can be hosted along with 100TB storage on the cloud as a whole. It costs $4995 per month.
\nPower BI Pro: With the pro version, you get full access to the Power BI dashboard, creation
\nof reports, along with unlimited sharing and viewing of reports. You also have a storage limit of 10GB per user<\/p>\n

13.What are the purpose and benefits of using the DAX function?<\/strong>
\nDAX is much more than Power BI. If you learn DAX as a functional language, you become
\nbetter as a data professional. DAX is based on different nested filters which magnificently
\nimproves the performance of data merging, modeling, and filtering tables.<\/p>\n

14.What is Power Pivot?<\/strong>
\nPower Pivot enables you to import millions of rows from heterogeneous sources of data
\ninto a single excel sheet. It lets us create relationships between the various tables, create
\ncolumns, calculate using formulas, and create PivotCharts and PivotTables.
\nAt a time there can be only one active relationship between the tables which is
\nrepresented by a continuous line<\/p>\n

15.What is Power Query?<\/strong>
\nPower query is a function that filters transforms, and combines the data extracted from
\nvarious sources. It helps to import data from databases, files, etc and append data<\/p>\n

16.Difference between Power BI and Tableau?<\/strong>
\nThe major differences between Power BI and Tableau are:
\nWhile Power BI uses DAX for calculating columns of a table, Tableau uses MDX
\n(Multidimensional Expressions).
\nTableau is more efficient as it can handle a large chunk of data while Power BI can handle only a limited amount.
\nTableau is more challenging to use than Power BI<\/p>\n

17.What is GetData in Power BI?<\/strong>
\nGetData offers data connectivity to various data sources. Connect data files on your local system. The supported data sources are:
\nFile: Excel, Text\/CSV, XML, PDF, JSON, Folder, SharePoint.
\nDatabase: SQL Server database, Access database, Oracle database, SAP HANA database, IBM, MySQL, Teradata, Impala, Amazon Redshift, Google BigQuery, etc.
\nPower BI: Power BI datasets, Power BI dataflows.<\/p>\n

18.What are filters in Power BI?<\/strong>
\nPage-level filters: These are applied on a particular page from various pages available within a report.
\nVisualization-level filters: These are applied to both data and calculation conditions for
\nparticular visualizations.
\nReport-level filters: These are applied to the entire report.<\/p>\n

19.What are the types of visualizations in Power BI?<\/strong>
\nVisualization is a graphical representation of data. We can use visualizations to create reports and dashboards. The kinds of visualizations available in Power BI are Bar charts, Column charts, Line chart, Area chart, Stacked area chart, Ribbon chart, Waterfall chart, Scatter chart, Pie chart, Donut chart, Treemap chart, Map, Funnel chart, Gauge chart, Cards, KPI, Slicer, Table, Matrix, R script visual, Python visual, etc<\/p>\n

20.What do we understand by Power BI services?<\/strong>
\nPower BI provides services for its cloud-based business analytics. With these services, you
\ncan view and share reports via the Power BI website. Power BI is a web-based service for
\nsharing reports. Power BI service can be best referred to as PowerBI.com, PowerBI
\nworkspace, PowerBI site, or PowerBI portal.<\/p>\n

21.What is the comprehensive working system of Power BI?<\/strong>
\nData Integration: The first step is to extract and integrate the data from heterogeneous data sources. After integration, the data is converted into a standard format and stored in a
\ncommon area called the staging area.
\nData Processing: Once the data is assembled and integrated, it requires some cleaning up.
\nRaw data is not so useful therefore, a few transformation and cleaning operations are
\nperformed on the data to remove redundant values, etc. After the data is transformed, it is
\nstored in data warehouses.
\nData Presentation: Now that the data is transformed and cleaned, it is visually presented on the Power BI desktop as reports, dashboards, or scorecards. These reports can be shared via mobile apps or web to various business users<\/p>\n

22.What are custom visuals in Power BI?<\/strong>
\nUsing Power BI visualizations, you can apply customized visualizations like charts, KPIs, etc. from the rich library of PowerBI\u2019s custom visuals. It refrains the developers from creating it from scratch using JQuery or Javascript SDK. Once the custom visual is ready, it is tested thoroughly. Post testing, they are packaged in .pbiviz file format and shared within the organization.
\nTypes of visuals available in Power BI are:
\nCustom visual files.
\nOrganizational files.
\nMarketplace files.<\/p>\n

23.What are the various type of users who can use Power BI?<\/strong>
\nAnyone and everyone can use PowerBI to their advantage. But even then a specific set of users are more likely to use it viz:
\nBusiness Users: Business users are the ones who constantly keep an eye on the reports to make important business decisions based on the insights.
\nBusiness Analysts: Analysts are the ones who create dashboards, reports, and visual representations of data to study the dataset properly. Studying data needs an analytical eye to capture important trends within the reports.
\nDevelopers: Developers are involved while creating custom visuals to create Power BI, integrating Power BI with other applications, etc.
\nProfessionals: They use Power BI to check the data scalability, security, and availability of data<\/p>\n

24.What is self-service business intelligence?<\/strong>
\nSelf-Service Business Intelligence (SSBI)
\nSSBI is an approach to data analytics that enables business users to filter, segment, and,
\nanalyze their data, without the in-depth technical knowledge in statistical analysis,
\nbusiness intelligence (BI).
\nSSBI has made it easier for end-users to access their data and create various visuals to
\nget better business insights.
\nAnybody who has a basic understanding of the data can create reports to build intuitive
\nand shareable dashboards.<\/p>\n

25.What is Power BI?<\/strong>
\nPower BI is a cloud-based data-sharing environment. Once you have developed reports
\nusing Power Query, Power Pivot, and Power View, you can share your insights with your
\ncolleagues. This is where Power BI enters the equation.<\/p>\n

26.How would you define Power BI as an effective solution?<\/strong>
\nPowerBI is a cloud based Business Intelligence tool to analyze and visualize raw data that can be fetched from a wide range of data sources. It consolidates business analytics with data visualization and helps any organization to make business decisions based on data.<\/p>\n

27.What are the major components of Power BI?<\/strong>
\nPower Query: It is one of the most important components of PowerBI to transform data. Power Query helps to extract data from different data sources like Oracle, SQL, Text\/CSV files, Excel, etc. and even delete data from different sources.<\/p>\n

28.What are the various Power BI versions?<\/strong>
\nPowerBI has three versions currently:
\nMicrosoft PowerBI Free\/ Desktop \u2013 It is for anybody who wants to see their business
\ninsights from the data with visualizations.
\nMicrosoft PowerBI Pro \u2013 It is the full version of PowerBI which enables unlimited viewing,
\nreporting and sharing of reports which PowerBI Desktop doesn\u2019t support.<\/p>\n

29.What is Power BI Desktop?<\/strong>
\nPower BI Desktop is a free desktop application that can be installed right on your own
\ncomputer. Power BI Desktop works cohesively with the Power BI service by providing
\nadvanced data exploration, shaping, modeling, and creating reports with highly interactive
\nvisualizations. You can save your work to a file or publish your data and reports right to your Power BI site to share with others.<\/p>\n

30.What do we understand by Power BI services?<\/strong>
\nPowerBI Services is a cloud based service or SaaS (software as a service). It helps to
\nconnect to your data, analyse, visualize and share business insights with efficiency.<\/p>\n

31.What data sources can Power BI connect to?<\/strong>
\nThe list of data sources for Power BI is extensive, but it can be grouped into the following:
\nFiles: Data can be imported from Excel (.xlsx, xlxm), Power BI Desktop files (.pbix) and Comma Separated Value (.csv).
\nContent Packs: It is a collection of related documents or files that are stored as a group. In
\nPower 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.
\nConnectors to databases and other datasets such as Azure SQL, Database and SQL, Server
\nAnalysis Services tabular data, etc.<\/p>\n

32.Where is the data stored in Power BI?<\/strong>
\nPrimarily, PowerBI uses two repositories to store its data: Azure Blob Storage and Azure
\nSQL Database. Azure Blob Storage typically stores the data that is uploaded by the users.
\nAzure SQL Database stores all the metadata and artifacts for the system itself.<\/p>\n

33.What are Building Blocks in Power BI?<\/strong>
\nThe following are the Building Blocks (or) key components of Power BI:
\nVisualizations: Visualization is a visual representation of data.
\nExample: Pie Chart, Line Graph, Side by Side Bar Charts, Graphical Presentation of the source data on top of Geographical Map, Tree Map, etc.
\nDatasets: Dataset is a collection of data that Power BI uses to create its visualizations.
\nExample: Excel sheets, Oracle or SQL server tables.
\nReports: Report is a collection of visualizations that appear together on one or more pages.
\nExample: Sales by Country, State, City Report, Logistic Performance report, Profit by Products report etc.
\nDashboards: Dashboard is single layer presentation of multiple visualizations, i.e we can integrate one or more visualizations into one page layer.<\/p>\n

34.What is the comprehensive working system of Power BI?<\/strong>
\nPower BI\u2019s working system mainly comprises four steps:
\nData Importing: The first step is to import the data and convert it into a standard format and store it in a staging area.
\nData Cleaning: After assembling the data, it requires transformation or cleaning to remove
\nunimportant values. Data Visualization: Now the data is visually represented on the Power BI desktop as reports and dashboards using powerful visualization tools.
\nSave and Publish: Finally when your report is ready you can save and publish these reports that can be shared across users via mobile apps or web.<\/p>\n

35.What are content packs in Power BI?<\/strong>
\nContent packs for services are pre-built solutions for popular services as part of the Power
\nBI experience. A subscriber to a supported service, can quickly connect to their account
\nfrom Power BI to see their data through live dashboards and interactive reports that have
\nbeen pre-built for them. Microsoft has released content packs for popular services such as
\nSalesforce.com, Marketo, Adobe Analytics, Azure Mobile Engagement, CircuitID, comScore
\nDigital Analytix, Quickbooks Online, SQL Sentry and tyGraph.<\/p>\n

36.What are the available views?<\/strong>
\nThe different views in PowerBI are:
\nReport View : It is the default view which shows the visualization of the data in reports.
\nYou can create multiple report pages here with a wide range of templates and
\nvisualizations.<\/p>\n

37.What are the available formats?<\/strong>
\nPower BI is available in different formats:
\nPower BI desktop: You can download and install PowerBI Desktop on your personal
\ncomputer where you can connect to the data source, transform your data, analyze and
\nvisualize it with templates.
\nPower BI services: It is a cloud based service or SaaS (software as a service). You can
\nconnect to data here as well but the modeling is limited.
\nPower BI mobile app: One can securely access dashboards and reports on any device with
\nthe PowerBI app which is available for iOs, Android and even Windows.<\/p>\n

38.What are the types of visualizations in Power BI?<\/strong>
\nIn PowerBI, we can represent the data in graphs and visualizations. The visualization can be of any type, for example:
\nBar and Column Charts: It is a standard visualization for looking at a specific value across
\nvarious categories. Area Charts( Basic and Stacked ) : It is based on the line chart and the area under the line. It depicts the magnitude of change over time.
\nCard: Card shows aggregate value of a certain datapoint, can be one or more but one per row.
\nDoughnut and Pie Charts: They show the relation in parts of a whole. Doughnut charts have ahollow in the centre while pie charts don\u2019t.
\nMaps: To show categorical and quantitative data with spatial locations.
\nMatrix: It\u2019s a type of table with easier display that shows aggregated data
\nSlicers: Slicer is used to filter other visuals on the page.<\/p>\n

39.What are custom visuals in Power BI?<\/strong>
\nIn PowerBI you can create your own visualizations from the library of custom visualizations.
\nA development project has to be created then test the visual in PowerBI service. Once the
\nvisualization is customized, it is thoroughly checked and tested before posting. After testing, the visualization is saved in .pbiviz file format before sharing. But you need to be a PowerBI Pro user in order to make custom visualizations.<\/p>\n

40.Why and how would you use a custom visual file?<\/strong>
\nA custom visual file is used when none of the pre existing visuals fit the business needs.
\nCustom visual files are generally created by Developers which can be used in the same
\nway as prepackaged files.<\/p>\n

41.What are the various type of users who can use Power BI?<\/strong>
\nPowerBI can be used by anyone for their requirements but there is a particular group of users who are more likely to use it:
\nReport Consumers: They consume the reports based on a specific information they need
\nReport Analyst: Report Analysts need detailed data for their analysis from the reports
\nSelf Service Data Analyst: They are more experienced business data users. They have an in\u0002depth understanding of the data to work with.
\nBasic Data Analyst: They can build their own datasets and are experienced in PowerBI Service Advanced Data Analyst: They know how to write SQL Queries and have hands-on experience on PowerBI. They have experience in Advanced PowerBI with DAX training and data modelling.<\/p>\n

42.What are the critical components of the Power BI toolkit?<\/strong>
\nThe most important components of PowerBI are:
\nPower Query
\nPower View
\nPower Pivot
\nPower Map
\nPower Q&A
\nPower Desktop
\nPower Website
\nPowerBI Mobile App<\/p>\n

43.What is the maximum data limit per client for the free version of Power BI?<\/strong>
\nWith a Power BI Free licence a user can use 10 GB of storage in the cloud for hosting Power BI reports. The maximum size a Power BI report can be used in the cloud is 1GB.<\/p>\n

44.Where do you reshape data in Power BI?<\/strong>
\nThe data can be reshaped in Data Editing of PowerBI.<\/p>\n

45.How can you refresh data in PowerBI?<\/strong>
\nThe data can be refreshed in the Gateway in PowerBI by scheduling refresh.<\/p>\n

46.Which is a single-page canvas that uses visualizations to depict a story?<\/strong>
\nPowerBI service dashboard is a single-page canvas that uses visualizations to depict a story.<\/p>\n

47.Mention some advantages of Power BI?<\/strong>
\nFew advantages of using Power BI are :
\nPowerBI can input a huge quantity of data
\nInformation can be visualized using powerful templates and visualizations
\nUsers get cutting edge intelligence technologies and powerful algorithms that are updated regularly
\nUser can have personalised dashboards which are easy to access and understand
\nUsers can perform queries on reports using DAX language<\/p>\n

48.List out some drawbacks\/limitations of using Power BI.<\/strong>
\nSome disadvantages of PowerBI are:
\nComplex in nature:
\nOne major drawback of PowerBI is it is designed in a complex manner. One needs complete
\nknowledge of PowerBI in order to start working with PowerBI.
\nLarge data:
\nPowerBI cannot handle large supply of data and might time out while processing a large data.
\nPowerBI cannot process data more than 1 GB.<\/p>\n

49.What is DAX?<\/strong>
\nTo do basic calculation and data analysis on data in power pivot, we use Data Analysis Expression (DAX). It is
\na formula language used to compute calculated column and calculated field.
\nDAX works on column values.
\nDAX can not modify or insert data.
\nWe can create calculated column and measures with DAX but we can not calculate rows using DAX.<\/p>\n

50.What are the most common DAX Functions used?<\/strong>
\nBelow are some of the most commonly used DAX function:
\nSUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT
\nIF, AND, OR, SWITCH
\nISBLANK, ISFILTERED, ISCROSSFILTERED
\nVALUES, ALL, FILTER, CALCULATE,
\nUNION, INTERSECT, EXCEPT, NATURALINNERJOIN, NATURALLEFTEROUTERJOIN,
\nSUMMARIZECOLUMNS, ISEMPTY,
\nVAR (Variables)
\nGEOMEAN, MEDIAN, DATEDIFF<\/p>\n

51.What are the three fundamental concepts of DAX?<\/strong>
\nThree fundamental concepts of DAX are:
\nSyntax: Syntax is the formula which includes the functions. If a Syntax is incorrect, it will result in an error.
\nFunctions: Functions are arguments with specific orders to perform. It helps to calculate any particular order as required.
\nContext: Context are of two types: Row Context and Filter Context. Row Context is used when a formula has a Function that applies a filter to identify a row in a table. Filter Context is used when one or more filters are used to get a value.<\/p>\n

52.What are the purpose and benefits of using the DAX function?<\/strong>
\nDAX or Data Analysis Expression is a functional language which can create calculated columns and\/or measures for smarter calculations to limit the data the dashboard has to fetch and visualize.<\/p>\n

53.How is the FILTER function used?<\/strong>
\nThe FILTER function returns a table with a filter condition applied for each of its source table rows. The FILTER function is rarely used in isolation, it\u2019s generally used as a parameter to other functions such as CALCULATE.
\nFILTER is an iterator and thus can negatively impact performance over large source tables.
\nComplex filtering logic can be applied such as referencing a measure in a filter expression.
\nFILTER(MyTable,[SalesMetric] > 500)<\/p>\n

54.What is special or unique about the CALCULATE and CALCULATETABLE<\/strong>
\nfunctions?<\/strong>
\nThese are the only functions that allow you modify filter context of measures or tables.
\nAdd to existing filter context of queries.
\nOverride filter context from queries.
\nRemove existing filter context from queries.
\nLimitations:
\nFilter parameters can only operate on a single column at a time.
\nFilter parameters cannot reference a metric.<\/p>\n

55.What is the common table function for grouping data?<\/strong>
\nSUMMARIZE()
\nMain groupby function in SSAS.
\nRecommended practice is to specify table and group by columns but not metrics.You can use ADDCOLUMNS function.
\nSUMMARIZECOLUMNS
\nNew group by function for SSAS and Power BI Desktop; more efficient.
\nSpecify group by columns, table, and expressions.<\/p>\n

56.What are some benefits of using Variables in DAX ?<\/strong>
\nDAX or Data Analysis Expression is a functional language which can create calculated
\ncolumns and\/or measures for smarter calculations to limit the data the dashboard has to
\nfetch and visualise.<\/p>\n

57.How would you create trailing X month metrics via DAX against a non standard calendar?<\/strong>
\nThe solution will involve:
\nCALCULATE function to control (take over) filter context of measures.
\nALL to remove existing filters on the date dimension.
\nFILTER to identify which rows of the date dimension to use.
\nAlternatively, CONTAINS may be used:
\nCALCULATE(FILTER(ALL(\u2018DATE\u2019),\u2026\u2026.))<\/p>\n

58.What are the different Excel BI add-in?<\/strong>
\nBelow are the most important BI add-in to Excel:
\nPower Query: It helps in finding, editing and loading external data.
\nPower Pivot: Its mainly used for data modeling and analysis.
\nPower View: It is used to design visual and interactively reports.
\nPower Map: It helps to display insights on 3D Map.
\nWant to upskill yourself to get ahead in your career? Check out this video<\/p>\n

59.What is Power Pivot?<\/strong>
\nPower Pivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook. It lets you create
\nrelationships between heterogeneous data, create calculated columns and measures using
\nformulas, build PivotTables and PivotCharts. You can then further analyze the data so that
\nyou can make timely business decisions without requiring IT assistance.<\/p>\n

60.What is Power Pivot Data Model?<\/strong>
\nIt is a model that is made up of data types, tables, columns, and table relations. These data tables are typically constructed for holding data for a business entity.<\/p>\n

61.What is xVelocity in-memory analytics engine used in Power Pivot?<\/strong>
\nThe main engine behind power pivot is the xVelocity in-memory analytics engine. It can
\nhandle large amount of data because it stores data in columnar databases, and in memory
\nanalytics which results in faster processing of data as it loads all data to RAM memory.<\/p>\n

62.What are some of differences in data modeling between Power BI <\/strong>Desktop and Power Pivot for Excel?<\/strong>
\nHere are some of the differences:
\nPower BI Desktop supports bi-directional cross filtering relationships, security, calculated
\ntables, and Direct Query options.<\/p>\n

63.What is GetData in Power BI?<\/strong>
\nWith \u201cGet Data\u201d in PowerBI, you connect to different data sources to import data for
\nanalysis and visualization. You can select from a range of various data sources to
\nimport the desired data.
\nEg. Text\/CSV, Excel, PDF, JSON, Amazon Redshift, SQL Server database, Access
\ndatabase, SAP HANA database, IBM, MySQL, Oracle database, Impala, Google
\nBigQuery,etc.<\/p>\n

64.What is Power Query?<\/strong>
\nPower query is a ETL Tool used to shape, clean and transform data using intuitive interfaces
\nwithout having to use coding. It helps the user to:
\nImport Data from wide range of sources from files, databases, big data, social media data,
\netc.
\nJoin and append data from multiple data sources.
\nShape data as per requirement by removing and adding data.<\/p>\n

65.What are the data destinations for Power Queries?<\/strong>
\nThere are two destinations for output we get from power query:
\nLoad to a table in a worksheet.
\nLoad to the Excel Data Model.<\/p>\n

66.What is query folding in Power Query?<\/strong>
\nQuery folding is when steps defined in Power Query\/Query Editor are translated into SQL and executed by the source database rather than the client machine. It\u2019s important for processing performance and scalability, given limited resources on the client machine.<\/p>\n

67.What are some common Power Query\/Editor Transforms?<\/strong>
\nChanging Data Types, Filtering Rows, Choosing\/Removing Columns, Grouping, Splitting a
\ncolumn into multiple columns, Adding new Columns ,etc.<\/p>\n

68.Can SQL and Power Query\/Query Editor be used together?<\/strong>
\nYes, a SQL statement can be defined as the source of a Power Query\/M function for additional processing\/logic. This would be a good practice to ensure that an efficient database query is passed to the source and avoid unnecessary processing and complexity
\nby the client machine and M function.<\/p>\n

69.What are query parameters and Power BI templates?<\/strong>
\nQuery parameters can be used to provide users of a local Power BI Desktop report with
\na prompt, to specify the values they\u2019re interested in.
\nThe parameter selection can then be used by the query and calculations.
\nPBIX files can be exported as Templates (PBIT files).
\nTemplates contain everything in the PBIX except the data itself.
\nParameters and templates can make it possible to share\/email smaller template files and limit the amount of data loaded into the local PBIX files, improving processing time and experience.<\/p>\n

70.Which language is used in Power Query?<\/strong>
\nA new programming language is used in power query called M-Code. It is easy to use and similar to other languages. M-code is case-sensitive language.<\/p>\n

71.Why do we need Power Query when Power Pivot can import data from mostly<\/strong>
\nused sources?<\/strong>
\nPower Query is a self-service ETL (Extract, Transform, Load) tool which runs as an Excel add-in. It allows users to pull data from various sources, manipulate said data into a form that suits their needs and load it into Excel. It is most optimum to use Power Query over Power Pivot as it lets you not only load the data but also manipulate it as per the users needs while loading.<\/p>\n

72.Name some commonly used tasks in the Query Editor.<\/strong>
\nSome commonly used tasks in the Query Editor are:
\nConnect to Data: Get Data from various sources and Transform data.
\nShape Data: Transform your data according to requirement to clean and shape it
\nGroup Rows: You can group the values of many rows into one single value by summarizing
\nPivot Columns: Pivot columns and create a table with aggregated values<\/p>\n

73.What is Power Map?<\/strong>
\nPower Map is an Excel add-in that provides you with a powerful set of tools to help you
\nvisualize and gain insight into large sets of data that have a geo-coded component. It can help you produce 3D visualizations by plotting upto a million data points in the form of column, heat, and bubble maps on top of a Bing map. If the data is time stamped, it can also produce interactive views that display, how the data changes over space and time.<\/p>\n

74.What are the primary requirement for a table to be used in Power Map?<\/strong>
\nFor a data to be consumed in power map there should be location data like:
\nLatitude\/Longitude pair Street, City, Country\/Region, Zip Code\/Postal Code, and State\/Province, which can be geolocated by Bing<\/p>\n

75.What are the data sources for Power Map?<\/strong>
\nThe data can either be present in Excel or could be present externally. To prepare your data, make sure all of the data is in Excel table format, where each row represents a unique record.
\nYour column headings or row headings should contain text instead of actual data so that
\nPower Map will interpret it correctly when it plots the geographic coordinates.<\/p>\n

76.Difference between Power BI and Tableau?<\/strong>
\nBoth PowerBi and Tableau are business intelligence tools for generating reports and data
\nvisualization but they do have a few significant differences.
\nData Source:
\nPowerBI does not have as wide access to data sources as Tableau when compared. Tableau has a wider range of access to various data sources.<\/p>\n

77.What is Power View?<\/strong>
\nThe following pages provide details about different visualizations available in Power View:
\nCharts
\nLine charts
\nPie charts
\nMaps
\nTiles
\nCards
\nImages
\nTables
\nPower View
\nMultiples Visualizations
\nBubble and scatter charts
\nKey performance indicators (KPIs)<\/p>\n

78.What is Power BI Designer?<\/strong>
\nIt is a stand alone application where we can make Power BI reports and then upload it to
\nPowerbi.com, it does not require Excel. Actually, it is a combination of Power Query, Power
\nPivot, and Power View.<\/p>\n

79.Can we refresh our Power BI reports once uploaded to cloud (Share<\/strong>
\npoint or Powebi.com)?<\/strong>
\nYes we can refresh our reports through Data Management gateway(for sharepoint), and
\nPower BI Personal gateway(for Powerbi.com)<\/p>\n

80.What are the different types of refreshing data for our published reports?<\/strong>
\nThere are four main types of refresh in Power BI. Package refresh, model or data refresh, tile refresh and visual container refresh.<\/p>\n

81.Is Power BI available on-premises?<\/strong>
\nNo, Power BI is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services and other data sources. You can also schedule refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway \u2013 Personal.<\/p>\n

82.What are the data management gateway and Power BI personal gateway?<\/strong>
\nGateway acts a bridge between on-premises data sources and Azure cloud services.<\/p>\n

83.What is Power BI Q&A?<\/strong>
\nPower BI Q&A is a natural language tool that helps in querying your data and getting the
\nresults you need from it. You do this by typing into a dialog box on your Dashboard, which the engine instantaneously generates an answer similar to Power View. Q&A interprets your
\nquestions and shows you a restated query of what it is looking from your data.<\/p>\n

84.What happens when you click the Infocus mode of a tile on the PowerBI<\/strong>
\ndashboard on the browser?<\/strong>
\nWhen you click the Infocus mode of a tile on the PowerBI dashboard on the browser, the
\nselected tile expands and takes the full space<\/p>\n

85.How do you consolidate inquiries in Power BI?<\/strong>
\nJoin Queries are used to consolidate inquiries in Power BI.<\/p>\n

86.What are some ways that Excel experience can be leveraged with Power BI?<\/strong>
\nBelow are some of the ways through which we can leverage Power BI:
\nThe Power BI Publisher for Excel:
\nCan be used to pin Excel items (charts, ranges, pivot tables) to Power BI Service.
\nCan be used to connect to datasets and reports stored in Power BI Service.
\nExcel workbooks can be uploaded to Power BI and viewed in the browser like Excel Services.
\nExcel reports in the Power BI service can be shared via Content Packs like other reports.
\nExcel workbooks (model and tables) can be exported to service for PBI report creation.
\nExcel workbook Power Pivot models can be imported to Power BI Desktop models.<\/p>\n

87.What is a calculated column in Power BI and why would you use them?<\/strong>
\nCalculated Columns are DAX expressions that are computed during the model\u2019s
\nprocessing\/refresh process for each row of the given column and can be used like any other
\ncolumn in the model.<\/p>\n

88.How is data security implemented in Power BI ?<\/strong>
\nA DAX expression is applied on a table filtering its rows at query time.
\nDynamic security involves the use of USERNAME functions in security role definitions.
\nTypically a table is created in the model that relates users to specific dimensions and a role.<\/p>\n

89.What are many-to-many relationships and how can they be addressed in<\/strong>
\nPower BI ?<\/strong>
\nMany to Many relationships involve a bridge or junction table reflecting the combinations of two dimensions (e.g. doctors and patients). Either all possible combinations or those combinations that have occurred. Bi-Directional Crossfiltering relationships can be used in PBIX.
\nCROSSFILTER function can be used in Power Pivot for Excel.
\nDAX can be used per metric to check and optionally modify the filter context.<\/p>\n

90.Why might you have a table in the model without any relationships to other<\/strong>
\ntables?<\/strong>
\nThere are mainly 2 reasons why we would have tables without relations in our model:
\nA disconnected table might be used to present the user with parameter values to be exposed and selected in slicers (e.g. growth assumption.)
\nDAX metrics could retrieve this selection and use it with other calculations\/metrics.
\nA disconnected table may also be used as a placeholder for metrics in the user interface.
\nIt may not contain any rows of data and its columns could be hidden but all metrics are
\nvisible.<\/p>\n

91.What is the Power BI Publisher for Excel?<\/strong>
\nThe user can manage the tiles \u2013 refresh them, remove them, in Excel.
\nPinned items must be removed from the dashboard in the service (removing in Excel only
\ndeletes the connection).
\nThe Power BI Publisher for Excel can also be used to connect from Excel to datasets that are hosted in the Power BI Service.
\nAn Excel pivot table is generated with a connection (ODC file) to the data in Azure.
\nThe Publisher installs all necessary drivers on local machine to establish connectivity .<\/p>\n

92.What are the differences between a Power BI Dataset, a Report, and a<\/strong>
\nDashboard?<\/strong>
\nDataset: The source used to create reports and visuals\/tiles.
\nA data model (local to PBIX or XLSX) or model in an Analysis Services Server
\nData could be inside of model (imported) or a Direct Query connection to a source.
\nReport: An individual Power BI Desktop file (PBIX) containing one or more report pages.
\nBuilt for deep, interactive analysis experience for a given dataset (filters, formatting).
\nEach Report is connected to atleast one dataset
\nEach page containing one or more visuals or tiles.
\nDashboard: a collection of visuals or tiles from different reports and, optionally, a pinned.
\nBuilt to aggregate primary visuals and metrics from multiple datasets.<\/p>\n

93.What are the three Edit Interactions options of a visual tile in Power BI<\/strong>
\nDesktop?<\/strong>
\nThe 3 edit interaction options are Filter, Highlight, and None.
\nFilter: It completely filter a visual\/tile based on the filter selection of another visual\/tile.
\nHighlight: It highlight only the related elements on the visual\/tile, gray out the non-related items.
\nNone: It ignore the filter selection from another tile\/visual.<\/p>\n

94.How does SSRS integrate with Power BI?<\/strong>
\nCertain SSRS Report items such as charts can be pinned to Power BI dashboards.
\nClicking the tile in Power BI dashboards will bring the user to the SSRS report.
\nA subscription is created to keep the dashboard tile refreshed.
\nPower BI reports will soon be able to be published to SSRS portal<\/p>\n

95.What is Power BI Desktop<\/strong>
\nPower BI Desktop is an open-source application designed and developed by Microsoft. Power BI Desktop will allow users to connect to, transform, and visualize your data with ease. Power BI Desktop lets users build visuals and collections of visuals that can be shared as reports with your colleagues or your clients in your organization.<\/p>\n

96.What is Power Pivot?<\/strong>
\nPower Pivot is an add-on provided by Microsoft for Excel since 2010. Power Pivot was
\ndesigned to extend the analytical capabilities and services of Microsoft Excel.<\/p>\n

97.What is Power Query?<\/strong>
\nPower Query is a business intelligence tool designed by Microsoft for Excel. Power Query
\nallows you to import data from various data sources and will enable you to clean, transform
\nand reshape your data as per the requirements. Power Query allows you to write your query once and then run it with a simple refresh.<\/p>\n

98.What are Custom Visuals in Power BI?<\/strong>
\nCustom Visuals are like any other visualizations, generated using Power BI. The only difference is that it developes the custom visuals using a custom SDK. The languages like JQuery and JavaScript are used to create custom visuals in Power BI.<\/p>\n

99.What is GetData in Power BI?<\/strong>
\nGet Data is a simple icon on Power BI used to import data from the source.<\/p>\n

100.Mention some advantages of Power BI.<\/strong>
\nIt helps build an interactable data visualization in data centers
\nIt allows users to transform data into visuals and share them with anyone
\nIt establishes a connection for Excel queries and dashboards for fast analysis
\nIt provides quick and accurate solutions
\nIt enables users to perform queries on reports using simple English words<\/p>\n

101.List out some drawbacks\/limitations of using Power BI.<\/strong>
\nPower BI does not accept file sizes larger than 1 GB and doesn’t mix imported data accessed from real-time connections.
\nThere are very few data sources that allow real-time connections to Power BI reports and
\ndashboards. It only shares dashboards and reports with users logged in with the same email address. Dashboard doesn’t accept or pass user, account, or other entity parameters.<\/p>\n

102.What are some differences in data modeling between Power BI Desktop<\/strong>
\nand Power Pivot for Excel?<\/strong>
\nPower Pivot for Excel supports only single directional relationships (one to many),
\ncalculated columns, and one import mode. Power BI Desktop supports bi-directional cross\u0002filtering connections, security, calculated tables, and multiple import options.<\/p>\n

103.Name the different connectivity modes available in Power BI?<\/strong>
\nThere are three main connectivity modes used in Power BI.
\nSQL Server Import An SQL Server Import is the default and most common connectivity type used in Power BI. It allows you to use the full capabilities of the Power BI Desktop.<\/p>\n

104.What are the various types of refresh options provided in Power BI?<\/strong>
\nPackage refresh – This synchronizes your Power BI Desktop or Excel file between the Power BI service
\nand OneDrive, or SharePoint Online.
\nModel or data refresh – This refreshes the dataset within the Power BI service with data from the original data source.
\nTile refresh – This updates the cache for tile visuals every 15 minutes on the dashboard once data changes.
\nVisual container refresh – This refreshes the visible container and updates the cached report visuals within a report once the data changes.<\/p>\n

105.Name the data sources can Power BI can connect to?<\/strong>
\nSeveral data sources can be connected to Power BI, which is grouped into three main types:
\nFiles<\/strong>
\nIt can import data from Excel (.xlsx, .xlxm), Power BI Desktop files (.pbix) and Comma-Separated<\/strong>
\nValues (.csv).<\/strong>
\nContent Packs<\/strong>
\nThese are a collection of related documents or files stored as a group. There are two types of content packs in Power BI:<\/p>\n

106.What is a dashboard in Power BI?<\/strong>
\nA dashboard is a single-layer presentation sheet of multiple visualizations reports. The main features of the Power BI dashboard are:
\nIt allows you to drill through the page, bookmarks, and selection pane and also lets you create various tiles and integrate URLs
\nA dashboard can also help you set report layout to mobile view.<\/p>\n

107.Explain how relationships are defined in Power BI Desktop?<\/strong>
\nRelationships between tables are defined in two ways:
\nManually – Relationships between tables are manually defined using primary and foreign
\nkeys.
\nAutomatic – When enabled, this automated feature of Power BI detects relationships
\nbetween tables and creates them automatically.<\/p>\n

108.Can you have more than one functional relationship between two tables<\/strong>
\nin a Power Pivot data model?<\/strong>
\nNo. There can be multiple inactive relationships, but only one active relationship
\nbetween two tables in a Power Pivot data model. Dotted lines represent inactive
\nrelationships, and continuous lines represent active relationships.<\/p>\n

109.Can you have a table in the model which does not have any relationship with<\/strong>
\nother tables?<\/strong>
\nYes. There are two main reasons why you can have disconnected tables:
\nThe table is used to present the user with parameter values to be exposed and selected in
\nslicers. It uses the table as a placeholder for metrics in the user interface<\/p>\n

110.What is the CALCULATE function in DAX?<\/strong>
\nThe CALCULATE function evaluates the sum of the Sales table Sales Amount column in a
\nmodified filter context. It is also the only function that allows users to modify the filter
\ncontext of measures or tables.
\nMoving ahead, you will step up to the following Power BI Interview Questions from the
\nIntermediate Level.<\/p>\n

111.Where is data stored in Power BI?<\/strong>
\nMost of the time, power BI gets assisted by the cloud to store the data. Power BI can use a
\ndesktop service. Microsoft Azure is used as the primary cloud service to store the data.
\nAzure SQL Database
\nAzure Blob Storage<\/p>\n

112.What are the different views available in Power BI Desktop?<\/strong>
\nThere are three different views in Power BI, each of which serves another purpose:
\nReport View – In this view, users can add visualizations and additional report pages and publish the
\nsame on the portal.
\nData View – In this view, data shaping can be performed using Query Editor tools.
\nModel View – In this view, users can manage relationships between complex datasets.<\/p>\n

113.What are the various versions of Power BI?<\/strong>
\nPower BI Desktop
\nPower BI service
\nMobile Power BI apps for iOS and Android devices<\/p>\n

114.Explain the building blocks of Microsoft Power BI.<\/strong>
\nThe important building blocks of Power BI are as follows:
\nVisualizations
\nVisualization is the process of generating charts and graphs for the representation of insights on business data.
\nDatasets A dataset is the collection of data used to create a visualization, such as a column of sales figures. Dataset can get combined and filtered from a variety of sources via built-in data plugins.<\/p>\n

115.What are the critical components of the Power BI toolkit?<\/strong>
\nThe critical components of Power BI are mentioned below.
\nPower Query
\nPower Pivot
\nPower View
\nPower Map
\nPower Q&A<\/p>\n

116.What do you mean by the content pack?<\/strong>
\nA content pack is defined as a ready-made collection of visualizations and Power BI reports using your chosen service. You’d use a content pack when you want to get up and running quickly instead of creating a report from scratch.<\/p>\n

117.What are the three fundamental concepts of DAX?<\/strong>
\nSyntax<\/strong>
\nThis is how the formula is written\u2014that is, the elements that comprise it. The Syntax includes functions such as SUM (used when you want to add figures). If the Syntax isn’t correct, you’ll get an
\nerror message.
\nFunctions These are formulas that use specific values (also known as arguments) in a particular order to perform a calculation, similar to the functions in Excel. The categories of functions are date\/time, time intelligence, information, logical, mathematical, statistical, text, parent\/child, and others.<\/p>\n

118.What are some familiar sources for data in the Get Data menu in Power BI?<\/strong>
\nA few familiar data sources are Excel, Power BI datasets, web, text, SQL server, and analysis services.<\/p>\n

119.Why and how would you use a custom visual file?<\/strong>
\nYou will use a custom visual file if the prepackaged files don’t fit the needs of your business.
\nDevelopers create custom visual files, and you can import them and use them in the same way as you would the prepackaged files.<\/p>\n

120.What are the categories of data types?<\/strong>
\nAll
\nFile
\nDatabase
\nPower BI
\nAzure
\nOnline Services
\nOther<\/p>\n

121.Name some commonly used tasks in the Query Editor.<\/strong>
\nConnect to data
\nShape and combine data
\nGroup rows
\nPivot columns
\nCreate custom columns
\nQuery formulas<\/p>\n

122.What do you mean by grouping?<\/strong>
\nPower BI Desktop helps you to group the data in your visuals into chunks. You can, however, define your groups and bins. For grouping, use Ctrl + click to select multiple elements in the visual. Right-click one of those elements and, from the menu that appears, choose Group. In the Groups window, you can create new groups or modify existing ones.<\/p>\n

123.Explain responsive slicers in Power BI.<\/strong>
\nOn a Power BI final report page, a developer can resize a responsive slicer to various sizes
\nand shapes, and the data collected in the container will be rearranged to find a match. If a
\nvisual report becomes too small to be useful, an icon representing the visual takes its place, saving space on the report page.<\/p>\n

124.What is query folding in Power BI?<\/strong>
\nQuery folding is used when steps defined in the Query Editor are translated into SQL and
\nexecuted by the source database instead of your device. It helps with scalability and efficient
\nprocessing.<\/p>\n

125.What is “M language.”<\/strong>
\nM is a programming language used in Power Query as a functional, case-sensitive language
\nsimilar to other programming languages and easy to use.<\/p>\n

126.How is the Schedule Refresh feature designed to work?<\/strong>
\nUsers can set up for an automatic refresh over data based on daily or weekly requirements.
\nUsers can schedule only one refresh maximum daily unless they have Power BI Pro. The
\nSchedule Refresh section uses the pull-down menu choices to select a frequency, time zone,
\nand time of day.<\/p>\n

127.What information is needed to create a map in Power Map?<\/strong>
\nPower Map can display geographical visualizations. Therefore, some location data is needed\u2014for example, city, state, country, or latitude and longitude.<\/p>\n

128.Mention important components of SSAS<\/strong>
\nFollowing are some of the important Components of SSAS:
\nOLP Engine An OLAP Engine is used to extensively run the ADHOC queries at a faster pace by the end-users
\nData Drilling
\nIt describes data Drilling in SSAS as the process of exploring details of the data with multiple
\nlevels of granularity.<\/p>\n

129.What are the three fundamental concepts of DAX?<\/strong>
\nSyntax: This is how the formula is written\u2014the elements that comprise it. The syntax includes functions such as SUM (used when you want to add figures). If the syntax isn’t correct, you’ll get an error message.
\nFunctions: These are formulas that use specific values (also known as arguments) in a certain order to perform a calculation, similar to the functions in Excel. The categories of functions are date\/time, time intelligence, information, logical, mathematical, statistical, text, parent\/child, and others.<\/p>\n

130.Name the variety of Power BI Formats.<\/strong>
\nPower BI is available mainly in three formats, as mentioned below.
\nPower BI Desktop: Open-Source version for Desktop users
\nPower BI Services: For Online Services
\nPower BI Mobile Application: Compatible with mobile devices<\/p>\n

131.What are the different stages in the working of Power BI?<\/strong>
\nThere are three different stages in working on Power BI, as explained below.
\nData Integration
\nData Processing
\nData Presentation
\nData Integration
\nThe primary step in any business intelligence is to establish a successful connection with the data source and integrate it to extract data for processing.<\/p>\n

132.Which professionals use Power BI the most?<\/strong>
\nBeginners and experts prefer Power BI in business intelligence. Power BI is used mainly by the
\nfollowing professionals.
\nBusiness Analysts
\nBusiness Owners
\nBusiness Developers
\nBusiness Analysts
\nA business analyst is a professional who analyses the business data and represents the insights found using visually appealing graphs and dashboards
\nBusiness Owners
\nBusiness owners, decision-makers, or organizations use Power BI to view the insights and
\nunderstand the prediction to make a business decision.
\nBusiness Developers
\nBusiness Developers are just software developers who get hired for business purposes to
\ndevelop custom applications and dashboards to help the business process be smooth.<\/p>\n

133.What is SSBI?<\/strong>
\nSSBI stands as an abbreviation for Self-Service Business Intelligence. SSBI is a breakthrough in business intelligence. SSBI has enabled many business professionals with no technical or coding background to use Power BI and generate reports and draw predictions successfully.<\/p>\n

134.Mention some applications of Power BI<\/strong>
\nThere are multiple applications of Power BI; some of them are as follows:
\nBusiness Analysis
\nData Analysis
\nDatabase Administration
\nIT Professional<\/p>\n

135.How can you depict a story in Power BI?<\/strong>
\nEvery individual chart or visualization report generated is collected and represented on a single screen. Such an approach is called a Power BI Dashboard. A Dashboard in Power BI is used to depict a story.<\/p>\n

136.What are KPIs in Power BI?<\/strong>
\nKPI is abbreviated as Key Performance Indicator. Any professional organization has teams and employees follow the KPI protocols. The organizations set up KPIs for all the employees. These KPIs act as their targets. These KPIs are compared to previous performance and analyze the progress.<\/p>\n

137.What is a Slicer?<\/strong>
\nSlicers are an integral part of a business report generated using Power BI. The functionality
\nof a slicer can be considered similar to that of a filter, but, unlike a filter, a Slicer can display a visual representation of all values and users will be provided with the option to select from the available values in the slicer\u2019s drop-down menu.<\/p>\n

138.Explain Power BI Designer.<\/strong>
\nIt is a combined solution offered to upload the reports and dashboards to the PowerBI.com
\nwebsite for reference. It consists of Power Pivot, Power Query, and Power Table.<\/p>\n

139.How do you reshape data in Power BI?<\/strong>
\nPower BI offers a wide variety of data source connectivity options. Data Editor is one of the
\ntools used to manipulate rows and columns of the data and helps you reshape it according to the requirements.
\nWith that, you have come to an end to this tutorial on \u201cTop 50 Power BI Interview Questions and Answers for 2021\u201d.<\/p>\n

140.What is the use of the \u201cGet Data\u201d icon in Power BI?<\/strong>
\nWhen users in Power BI click on the icon \u201cGet Data\u201d, a drop-down menu displays all data sources from which data can be ingested. Data can directly get ingests from sources such as Excel, XML, PDF, JSON, CSV, and SharePoint folder databases and formats such as SQL, SQL Server Analysis Services, IBM, Access, Oracle, MySQL, and much more.<\/p>\n

141.How to create and manage relationships in Power BI Desktop?<\/strong>
\nAs the name suggests, relationships in Power BI are used to define connections or the relation between two or more tables. To perform analysis on multiple tables, relationships are used. To create and manage relationships in Power BI Desktop:
\nOn the Home tab, select Manage Relationships > New.
\nIn the Create relationship dialog box, in the first table drop-down list, select a table. Select the column you want to use in the relationship.
\nIn the second table drop-down list, select the other table you want in the relationship. Select the other column you want to use, and then choose OK.<\/p>\n

142.Are Power View and Power Query the same?<\/strong>
\nPower View can be used to download data to Excel as well as make nice transformations.
\nExample: Filter, merge multiple sources, calculate, etc.
\nPower View enables you to present the data in reports<\/p>\n

143.Can you tell me what the difference between Power BI personal Gateway<\/strong>
\nand Data Management Gateway is?<\/strong>
\nPower BI Personal Gateway is used for reports that are deployed in Powerbi.com. On the other hand, data management is an app that installs the gateway on source data machines to deploy reports on Sharepoint and schedule to refresh automatically.<\/p>\n

144.Explain DAX<\/strong>
\nDAX stands for Data Analysis Expressions. It is a collection of operators, functions, and
\nconstants used to calculate formulas and return values. In other words, it helps you create new info from data you already have.<\/p>\n

145.SUM() vs SUMX(): What is the difference between the two DAX functions?<\/strong>
\nThe sum function (Sum()) takes the data columns and aggregates them totally but the SumX function (SumX()) lets you filter the data which you are adding.
\nSUMX(Table, Expression), where the table contains the rows for calculation. Expression is a
\ncalculation that will be evaluated on each row of the table.<\/p>\n

146.List the benefits of using variables in DAX.<\/strong>
\nImprove performance
\nImprove readability
\nReduce complexity
\nSimplify debugging<\/p>\n

147.What is the Power Map?<\/strong>
\nPower BI is a business intelligence and Analytics tool for non-technical and
\ntechnical users to manage, analyze, visualize and share data with others. One of
\nits key features is visualization – that is, presenting data and insights using
\nappealing visuals. Among the visuals available in power BI are maps.<\/p>\n

148.How to create and use Maps in Power BI?<\/strong>
\nThere are 4 types of core or built-in map visuals:
\nMap (Basic)
\nFilled Map
\nShape Map
\nArcGIS Maps<\/p>\n

149.Explain the filled map in Power BI?<\/strong>
\nPower BI utilizes two built-in map charts map and a filled map. A filled map shows data points with geospatial areas rather than points on a map. Areas can be continent, country, state, city. Working with a filled map, however, is not as easy and convenient as the map chart is<\/p>\n

150.What data sources can you connect to Power BI?<\/strong>
\nhe Power BI data sources are extensive, which are divided as follows:
\nFiles: Data can be imported from Power BI Desktop files (.pbix), Excel (.xlsx, xlxm), and
\nComma Separated Value (.csv).
\nContent Packs: It refers to the collection of related files or documents that are stored as a
\ngroup. There are two types of content packs in Power BI: those from service providers
\nincluding Google Analytics, Salesforce, or Marketo, and those created and shared by other
\nusers in the organization.
\nConnectors: To connect databases and other datasets, including Database, Azure SQL, and
\nSQL Server Analysis Services tabular data, etc.<\/p>\n

151.Explain about Power BI Desktop<\/strong>
\nPower BI Desktop is a free desktop application that can be installed on your computer. It cohesively works with the Power BI service by providing advanced data modeling, shaping, exploration, and creating reports with highly interactive visualizations. It enables users to save the work to a file or publish their reports and data right to your Power BI site to share with others.
\nBelow are the distinct Excel BI add-ons.
\nPower Query to find, edit and load external data
\nPower View for designing interactive and visual reports
\nPowerPivot to analyze data modeling
\nPower Map for displaying insights in 3D Map<\/p>\n

152.Is Power BI free to use?<\/strong>
\nPower BI is available in two versions: Power BI Free and Power BI Pro.
\nUsers can use Power BI for free. However, the Power BI Pro subscription avails more from
\nMicrosoft Store. The subscription offers an enhanced version of various features available with the free Power BI account. Most business users use the subscribed account as it provides more data refreshers per day and other features than the free version.<\/p>\n

153.How to perform query tasks in Power BI Desktop?<\/strong>
\nPower Query is available in Power BI Desktop through the power query editor. To open the
\npower query editor, select Edit Queries from the Power BI Desktop home tab.
\nThe ribbon in Power Query Editor consists of five tabs – home, transform, add column, view, and help.<\/p>\n

154.Can we store data in Power BI? If so, where does it get stored?<\/strong>
\nPower BI stores data in a few different locations. All the data stays secure through measures such as encryption and password protection. It mainly depends on the channel that you used to import the data. Data is stored in a few places, but it all boils down to one of the main two locations: the cloud and your desktop.<\/p>\n

155.How do you create a group in Power BI?<\/strong>
\nTo perform grouping in power bi, please select the fields you want to group, and right-click on it will open the context menu. Please select the Group option from the menu.
\nOnce you click on the group option, Power BI will automatically group those items, as shown below. That’s it; we did the grouping. If you observe closely, the legend section is replaced by group, and colour is placed in the details section.<\/p>\n

156.What is the current version of Power BI?<\/strong>
\nPower BI Desktop is supported on Windows 8 or newer versions of Windows. Download the
\nPower BI Desktop version that matches the architecture (x86 or x64) of your Windows OS.<\/p>\n

157.Explain what M language is in Power BI?<\/strong>
\nM is a query formula language used in Power BI Query Editor to prepare data before loading in the Power BI model.
\nPower Query works with Excel, Analysis Services, and Power BI workbooks. Its core
\nfunctionality is to filter and combine, i.e., to mash up data from one or more rich collections
\nof supported data sources. Any such data mashup is expressed using Power Query M Formula Language.<\/p>\n

158.Can you explain a few ways of how a Power Query can transform the<\/strong>
\ndata?<\/strong>
\nPower Query is available through getting & Transform in Excel 2016 or Power Pivot.<\/p>\n

159.Which data sets can be used to create dashboards with streaming data tiles?<\/strong>
\nStreaming datasets
\nHybrid Datasets<\/p>\n

160.What are the different views that Power BI Desktop contains?<\/strong>
\nReport View
\nData View
\nRelationship View<\/p>\n

161.What do you know about Row Level Security? And how do you implement it?<\/strong>
\nRow-level security restricts the data that users view and access based on filters. To configure row\u0002level security, users can define rules and roles within Power BI Desktop and publish them to Power BI
\nService. Also, the username() function can restrict data in the table to the current user.
\nHowever, to enable row-level security, a Power BI Pro subscription account is essential, and Excel sheets can be used when converted to the .pbix file format.
\nFollowing are the ways to implement Row Level Security in Power BI:
\nDefine roles and rules in Power BI Desktop
\nValidate the roles within Power BI Desktop
\nManage security on your model
\nValidating the role within the Power BI service<\/p>\n

162.Explain about Bidirectional Cross-Filtering in Power BI?<\/strong>
\nOne of the most important features of Power BI is Bidirectional cross-filtering. This feature
\nallows you to apply filters on both sides of a table relationship, using right-to-left and left-to<\/p>\n

\u0002right options for their calculations. Through this, modelers can know how exactly particularrelationships can work in multiple contexts.<\/p>\n

163.Name some top features of Power BI<\/strong>
\nQuick Insights
\nAcquiring data
\nReal-time information
\nNatural language questions
\nContent the way you want
\nQuick decisions
\nView reports on the Go
\nFreedom for Integration
\nSharing<\/p>\n

164.Explain Power BI Query Editor<\/strong>
\nPower BI Query Editor is used to transform or edit data files before they are loaded. The Query Editor plays the role of an intermediate data container where you can transform data by selecting rows and columns, splitting rows and columns, pivoting and unpivoting columns, etc.
\nThe modifications done by the Query Editor are not reflected in the actual datasheet.<\/p>\n

165.Describe Power BI Designer<\/strong>
\nPower BI is a stand-alone application to make Power BI reports and upload them to
\nPowerbi.com; it does not require excel. It is the combination of Power Pivot, Power View, and Power Query.<\/p>\n

166.What are the different types of gateways available in Power BI? Why would<\/strong>
\nyou use them?<\/strong>
\nThe Gateway acts as an extension between azure cloud administration and on-premise data
\nsources. There are three major types of Gateways listed as follows:
\nOn-premises data gateway Allows multiple users to connect to various on-premises data sources. You can use an on-premises data gateway with all supported services with a single gateway installation. For complex scenarios,
\nthis gateway is best suited.
\nOn-premises data gateway (personal mode)
\nThis data gateway allows one user to connect to sources that can\u2019t be shared with others. This gateway is best suited to scenarios in which you only create reports and don\u2019t need to share any data sources with others.
\nThe virtual network data gateway
\nThis data gateway allows multiple users to connect various data sources that are secured by virtual networks. For complex scenarios in which multiple people access multiple data sources, this data gateway is highly preferred.<\/p>\n

167.Can we create geographic maps using Power BI?<\/strong>
\nYes, Power BI can display geographical visualizations. That\u2019s why some kind of location data is needed.
\nFor example, state, country, or latitude and longitude.<\/p>\n

168.Explain z-order in Power BI?<\/strong>
\nZ-order is a design strategy used to arrange visuals over shapes. It can also be defined as a method applied to implement when reports consist of multiple elements. Moreover, this can also be used to refresh the display when items in a report are changed.<\/p>\n

169.What is the primary requirement for a table to be used in<\/strong>
\nPower BI?<\/strong>
\nIn Power BI, the primary requirement for the table is that it contains unique rows. It must
\nalso contain location data, which can be in a Latitude\/Longitude pair.
\nYou can use address fields instead, such as street, city, etc., which Bing can geolocate.<\/p>\n

170.Name some important tools of Power BI<\/strong>
\nPower BI Desktop
\nPower BI Service
\nPower BI Data Gateway
\nPower BI Report Server
\nPower BI Mobile Apps<\/p>\n

171.Is there any process for refreshing Power BI reports uploaded to the<\/strong>
\ncloud?<\/strong>
\nOf course, Power Bi reports can be refreshed with Data Management Gateway and Power BI
\nPersonal Gateway.<\/p>\n

172.What are content packs in Power BI? And why would you use one?<\/strong>
\nIn Power BI, content packs are used to share objects, such as reports, dashboards, or
\ndatasets with individuals within your organization. The sharing takes place over the Power BI website and can be shared with multiple users. No one can change the original content in the content pack. Also, users have \u201cread-only\u201d access to the Power BI content shared with them.<\/p>\n

173.How is data security implemented in Power BI?<\/strong>
\nPower BI applies models with Row Level Security.
\nDynamix security involves using USERNAME functions in definitions.
\nA DAX expression can be applied to tables filtering their rows at query time.
\nA table is typically created in the model that relates to specific dimensions and roles.<\/p>\n

174.What do you know about many-to-many relationships in Power BI?<\/strong>
\nMany-to-many relationships involve a bridge or junction table that reflects the combinations of two dimensions. Either all possible combinations or those combinations that have occurred.
\nA relationship with many-to-many cardinality in Power BI is composed of three features:
\nComposite models: Allows a report to have two or more data connections, including DirectQuery connections or Import. With composite models, you can establish relationships with a many-many cardinality between tables.
\nRelationships with a many-many cardinality: This approach removes unique values in tables. Storage mode: You can specify which visuals require a query to back-end data sources. This feature improves performance and reduces back-end load.<\/p>\n

175.List some Edit interactions options in Power BI.<\/strong>
\nFilter: It thoroughly filters the visual\/tile based on the filter selection of another variable.
\nHighlight: Highlights only the related elements on the visual
\nNone: Ignores the filter selection from another tile\/visual.<\/p>\n

176.How can you convert SSRS to Power BI?<\/strong>
\nFollowing are the ways to integrate SSRS with Power BI:
\nSSRS report items such as charts can be pinned to Power BI dashboards.
\nBy clicking the tile option in Power BI dashboards will bring users to SSRS reports
\nTo keep the dashboard tile refreshed, a subscription is created.
\nPower BI reports will be published to the SSRS portal.<\/p>\n

177.What is the Time Intelligence function?<\/strong>
\nIt is a function that allows manipulating data using periods.<\/p>\n

178.How do I prepare for Power BI certification?<\/strong>
\nMindmajix instructor-led training completely prepares you for the certification. We
\nprovide two industry-specific projects in the course, which helps you have hands-on
\nexperience on all possible scenarios that are part of certification.<\/p>\n

179.Is Power BI a good career?<\/strong>
\nFive major reasons why Power BI will create a good career path for you:
\nGartner\u2019s framework for the Analytics and BI Magic Quadrant 2021.
\nThere is a big market for Microsoft Power BI Consultants in almost every industry.
\nIn perspective, Qlik and Tableau (both high in Gartner ranking) have a market cap close to 1% of Microsoft.
\nTop companies offering lucrative Power BI career opportunities<\/a>.
\nVariety of job roles available:
\nPower BI Analyst\/Developer
\nData Analyst
\nBusiness Analyst
\nBusiness Intelligence Analyst
\nBusiness Intelligence Developer
\nBusiness Intelligence Manager<\/p>\n

180.What are the Parts of Microsoft’s Self-Service Business Intelligence<\/strong>
\nSolutions?<\/strong>
\nMicrosoft Self-Service BI has two parts:
\nExcel BI Toolkit: Allows users to create reports interactively through data importing from
\ndistinct data sources as well as model data according to the requirement.
\nPower BI: It is an online solution that empowers users for sharing interactive reports and
\nqueries that you have created with Excel BI Toolkit.<\/p>\n

181.What is the Differentiate between Power BI and Power BI Pro?<\/strong>
\nPower BI offers distinct kinds of features to help you get started in searching for data in a
\ncompletely new way. Power BI Pro, on the other hand, caters to some additional features like scheduling data, live data sources, storage capacity, complete interactivity, and much more.<\/p>\n

182.Define Excel BI Toolkit?<\/strong>
\nExcel BI Toolkit allows users for creating an interactive report by importing data from a
\ndistinct range of sources and model data according to requirements.<\/p>\n

183.What is the Cost of Power BI?<\/strong>
\nBoth Power BI Desktop and Power BI are free of cost. For Power BI Pro, users have to pay
\n$9.99 per month after a 60-day free trial.<\/p>\n

184.What are the basics needed for using Power BI?<\/strong>
\nTo use Power BI, you need to have a web browser and a work email address.
\nwork email addresses finishing in .mil and .gov are not supported currently.<\/p>\n

185.What is the need for signing up with a work email?<\/strong>
\nPower BI does not have email addresses provided by telecommunications providers and
\nconsumer email services, thus there is a need of signing up with work email.<\/p>\n

186.Name the work email addresses that are currently supported?<\/strong>
\nWork email addresses that are finishing with .org and .edu are currently supported.<\/p>\n

187.Is there any support by Power BI available for mobile devices?<\/strong>
\nYes, Power BI supports mobile devices. It consists of apps for iOS devices, Windows 10
\ndevices, and Android smartphones. You can install Power BI apps from the below app stores:
\nGoogle Play
\nApple Store
\nWindows Store<\/p>\n

188.What is Visualization?<\/strong>
\nVisualization is a process to represent data in pictorial form like tables, graphs, or charts
\nbased on the specific requirement.<\/p>\n

189.What is a Report?<\/strong>
\nThe report is a Power BI feature that is a result of visualized data from a single data set. A
\nreport can have multiple pages of visualization.<\/p>\n

190.What is Power Pivot and what is the filter written in Power BI?<\/strong>
\nPower Pivot is an in-memory component that enables storing compressed data. It is used to build data models, relationships, create formulas, calculate columns from different resources.
\nFilters are applicable in:
\nVisualization level
\nReport Level
\nPage-Level<\/p>\n

191.What data sources can Power BI connect to?<\/strong>
\nThe following data sources that support DirectQuery in Power BI are as follows:
\nAmazon Redshift
\nAzure Data Explorer
\nAtScale (Beta)
\nAzure SQL Database
\nAzure HDInsight Spark
\nGoogle BigQuery
\nAzure SQL Data Warehouse
\nHDInsight Interactive Query<\/p>\n

192.Why do we need BI?<\/strong>
\nYou can take data and create reports at the click of a button. You can take data and
\ncreate reports with a button click. It helps in attracting new customers to service and
\nmonitor existing customers. You can keep track of information and set your goals
\naccordingly. In general, building an ETL solution (Extraction, Transformation, and
\nLoading) ultimately helps to make better decisions. The ROI is very high Helps to make
\nunwanted data into progressive information.<\/p>\n

193.Does Power BI store data?<\/strong>
\nDatasets are the data sources that are uploaded or connected to databases. These sources
\ninclude Excel workbooks and Power BI Desktop files. The following are also included in your
\ndata capacity. Reporting Services on-premises visualizations are pinned to a Power BI
\ndashboard.<\/p>\n

194.What must be installed to use Power BI?<\/strong>
\nTo use the Power BI service for free, you need a work email and a web browser. With this,
\nyou can explore data as well as create reports in Power BI Desktop. The mobile app can be
\ndownloaded from the following stores:
\nGoogle Play, App Store, and Windows Store.<\/p>\n

195.How one can get started with Power BI?<\/strong>
\nThere are some resources to get assistance and get started with Power BI. They are as follows:
\nWebinars
\nPower BI Blog
\nYou can get started with an article on Power BI
\nYou can get started with a video on YouTube
\nLast but not least, joining a related community and getting answered<\/p>\n

196.What is SSBI?<\/strong>
\nSSBI stands for Self-Service Business Intelligence. It can also be termed as accessing data
\nanalytics to empower business users to divide, clean, and interpret data. SSBI has made
\nit easy for end-users to access their data and create various kinds of visuals to acquire
\nuseful business insights. Anyone who has basic data knowledge can build reports for
\ncreating spontaneous and shareable dashboards.<\/p>\n

197.What is a Dashboard?<\/strong>
\nThe dashboard is used to visualize the strategic data of one or multiple reports at a glance.<\/p>\n

198.What is the CORR function and when is it used?<\/strong>
\nCORR is a correlation function that provides a correlation between two distinct variables ranging
\nfrom -1 to 1.<\/p>\n

199.What are the advantages of Power BI?<\/strong>
\nHere are the main advantages of Power BI
\nPower BI integrates well with the existing application
\nIt contains rich and personalized Dashboards.
\npublishing reports in a secure way
\nQuick accessibility to data means there is no speed and memory issue<\/p>\n

200.What are the data destinations for Power Queries?<\/strong>
\nThere are two destinations for output we get from power query:
\nLoad to a table in a worksheet
\nLoad to the Excel Data Model<\/p>\n

Join in the best institute<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Power BI Interview Questions and Answers 1.What is Power BI? Power BI was introduced by Microsoft to combine the multiple data visualization features into one. Power BI is the new term for the data-driven industry and thus carries a lot of opportunities on its shoulders. It comes as a package of three major components: Power […]<\/p>\n","protected":false},"author":2,"featured_media":328,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-245","post","type-post","status-publish","format-standard","has-post-thumbnail","category-interview-questions"],"_links":{"self":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/posts\/245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/comments?post=245"}],"version-history":[{"count":0,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/posts\/245\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/media\/328"}],"wp:attachment":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/media?parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/categories?post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/tags?post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}