Power BI Questions:
1. What kinds of tasks have you completed with the Power Query Editor?
2. Why do we use DAX and M Query, and what are their differences?
3. List the different graphs and charts you use.
4. Have you created any custom charts?
5. What are many-to-many relationships and how do you handle them?
6. What is the purpose of an active and inactive relationship?
7. How do you create bookmarks, and what are they?
8. When and how do you perform an incremental refresh?
9. What are the different types of row-level security?
10. What is the purpose of the Gateway in Power BI?
1. What is Power BI?
Power Bi is a very powerful Data Visualization and Business Analytics tool provided by Microsoft. It help us to provide interactive visualizations, dashboard & Bi Reports with self-service capabilities.
2. Power BI components?
Power BI Desktop, Power BI Gateway, Power BI Mobile Apps, and Power BI Service
3. Power-Bi Building Blocks?
Visualizations, Datasets, Reports, Dashboards, Tiles
4. Power BI-supported DataSource
File: Excel, Text/CSV, XML, JSON, PDF etc.
Database: SQL Server, Oracle, MySQL, PostgreSQL, SAP HANA, etc.
Azure: Azure SQL, Azure SQL Data warehouse, Azure Blob Storage, etc.
5. Data Type in Power Bi?
Number type: Decimal Number, Fixed Decimal Number, Whole Number
Date/time types: Date/Time, Date, Time, Date/Time/Timezone, Duration
Text type: Text
Binary type: True/false
6. What is a Report?
The Reports is a Power BI feature which is a result of visualized data from a single data set. A report can have multiple pages of visualization.
7. What is a Dashboard?
The Dashboards is used to visualize the strategic data of one or multiple reports in a glance.
8. Measures Vs Quick Measures
Measures: In Power Bi Desktop you can create your own measures to using Data Analysis Expressions (DAX) formula language to perform Aggregation level of Calculations such as COUNTS, AVERAGE, SUM, MAX, MIN & many more.
Quick measures are pre-built or you can say readymade measures. You don’t have to write DAX formula for this, it’s done for you based on input you provide in a quick measure dialog box.
9. Bookmarks in Power BI?
Bookmarks capture the present configured view of a report page, including filters, slicers, and the state of visuals. When you select a bookmark, Power BI takes you back to that view. There are two types of bookmarks – those you create yourself and those created by report designers.
10. Slicers in Power Bi?
Slicer is a canvas visual filters. It is used to sort or filter visuals data according to user selection.
11. DAX in Power Bi?
DAX stands for Data Analysis Expressions. It is a library of functions and operators to using them we can build formulas and expressions.
12. Power Bi Data Connectivity mode?
Direct Query mode
Import mode
13. What is the difference between SUM() and SUMX()?
SUM is a simple aggregation function. It summarizes a value based on a filter context.
Syntax: SUM(<ColumnName>)
SUMX() is an iterator function. Returns the sum of an expression evaluated for each row in a table.
Syntax: SUMX(<table>, <expression>)
14. What is the difference between COUNT() and COUNTX()?
The COUNT function counts the number of cells in a column that contain non-blank values.
Syntax: COUNT(<column>)
The COUNTX function counts only values, dates, or strings. If the function finds no rows to count, it returns a blank. Syntax: COUNTX (<Table>, <Expression>)
15. Types of Power Bi Filters?
Visual level Filters: The filters applied to visual level are applied directly on individual visualizations. Such filters are applied both to the data and the calculation conditions used within a visualization.
Page level Filters: Power BI Page level Filters are used to filter the visuals present in the page.
Report level Filters: The report-level filters are the filters that you use to apply a filter condition on the entire report.
Drillthrough level filter: Drillthrough allows users to navigate to different report pages within a report.
16. What are Power Bi Tooltips?
Tooltips are a very cool feature of Power Bi Desktop; they help us explore our visuals more deeply, and they are very easy to use. Tooltips appear when the cursor is hovering over a visual.
17. What is Power BI Cross-report?
Cross-report Drill through is a feature in Power BI that enables users to drill through from the data of one report to another separate report
18. What are the types of DAX functions in Power BI?
Aggregate DAX functions: MIN, MAX, Average, SUM, SUMX
Counting Functions: DISTINCTCOUNT, COUNT, COUNTA, COUNTROWS, COUNTBLANK
Logical Functions: AND, OR, NOT, IF, IFERROR
TEXT Functions: REPLACE, SEARCH, UPPER, FIXED, CONCATENATE
DATE Functions: DATE, HOUR, WEEKDAY, NOW, EOMONTH
19. Power BI Report Performance technique
Limit the number of visuals in dashboards and reports.
To improve Power BI report performance, remove unnecessary interactions between visuals, by default it is enable.
Use Microsoft AppSource certified custom visuals where applicable.
If possible avoid to use hierarchical filters
Remove unused tables or columns from dataset, where possible.
Use integers instead of strings, where possible.
Used Performance analyzer, This new tool lets you analyze the speed of your dashboard and will point out the bottlenecks.
20. What is Edit Interactions in PowerBI?
Power Bi provides you to very cool features of visual Interaction, by default this feature is enable, that’s means when you select any slicer value or click any visual by default all visuals get filtered on the basis of click or select value. And we can control this feature to using Edit Interactions.
21. What is a power pivot?
It allows us to connect multiple sources. We can load the data & create relationship between the data.
22. What is Power View?
With the help of power view, we can create visualization.
23. What is Power Query?
It will perform transformations, SQL operations can be performed in power bi with query. Direct query is a direct connection to data source, data will not be stored in power bi model. Power bi will be a visualizations layer, then query the data from data source every time (Table name, Column Name, Relationship) but not the data.
Example: SQL SERVER, SAP HANA, AZURA SQL DATABASE, AMAZON REDSHIFT
24. Name some Commonly used tasks in the query editor?
Connect to data
Shape and combine data
Group rows
Pivot columns
Create custom columns
Query formulas
25. What is data size in power BI?
The file size limit is 1GB in PRO and 10GB for premium members/users.
26. How many records are we able to see on your PowerBI desktop?
1 Million
27. What are the different sources that you worked on?
Excel, SQL Server, CSV Files, JSON file and Azure SQL Server.
28. Can we delete datasets in Pro from Workspace?
Yes
29. What is Relationship? How many types of relationships exist?
When you import multiple tables, you are going to analysis data using those tables.
Relationship between those table are necessary in order to accurate calculate result and display the correct information in your reports.
Power BI desktop makes creating those relationships easy. The auto detect feature can do it for you. If you query two or more table at the sometime, when the data is loaded, power bi desktop attempts to find and create relationship for you.
Cardinality, cross filter direction and active properties are automatically set.
Types of Relationships
Active Relationship: This means the relationship service as the active, default relationship. Where there is more than one relationship provides a way of power bi desktop to automatically create visualizations that include both table.
In-active Relationship: Suppose you have two tables, 1- Sales Table, 2- Date Table, under Sales table that has two columns Order Date & Ship Date and in Date table there is one Date column.
Suppose you created a relationship between the date table date column and the table order date and date columns. So in that scenario, one relationship will be active and the second will be inactive; that is called an active relationship.
30. What is Cardinality?
The cardinality of the relationship means having unique or multiple instances per value for the joining field between two tables.
Cardinality defined by the relationship. Cardinality refers to the relationship between two tables.
1. Many to One
2. One to Many
3. Many to Many
31. What type saving power BI file is saving?
Power BI file format is. pbix
32. How many types of joins are there in power BI?
Right Join 2. Left Join 3. Inner Join 4. Full outer Join
33. What is Button?
The Buttons are used to pop-up of multiple pages in a report.
34. What is a custom sort?
Custom sort allows you to define a specific order for displaying data. It is an easy way to predefine your own order for displaying data.
35. Can we delete datasets in Pro from Workspace?
Yes
36. Can we create a dashboard from visuals from multiple pages within the report?
Yes, we can create a dashboard from multiple pages .
37. Can we create a dashboard from visuals from multiple reports?
Yes, we can create a dashboard from visuals from multiple reports.
38. Can we create reports in service?
Yes, we can create reports in service.
39. Can we create Calculated columns and measures in Service?
No, we cannot create calculated columns and measures in service
40. Using the username() or userprincipalname() DAX function?
username() will return a user in the format of DOMAIN\User. userprincipalname() will return a user in the format of user@abc.com. In Power BI service, username() and userprincipalname() will both return the user’s User Principal Name (UPN). This looks similar to an email address.
41. What is RLS?
Row level security is the ability to filter content based on a user’s role. Both Direct Query and data imported to the model support RLS
42. Can we use RLS to limit the columns or measures accessible by my users?
No. If a user has access to a particular row of data, they can see all the columns of data for that row.
43. Does RLS let me hide detailed data but give access to data summarized in visuals?
No, you secure individual rows of data but users can always see either the details or the summarized data.
44. What is Static RLS?
Static RLS is simple. It is used when there is a requirement to restrict a specific user group to see the only same part of the data. For example, you may want to restrict INDIA salespeople to only view INDIA data.
Power BI Desktop > Test Roles in Desktop Publish to Power BI Service > Add Users to Power BI Service
45. What is Dynamic RLS?
Static RLS is about creating roles manually. If we have too many roles to create, static RLS is not an option. Thus comes the Dynamic RLS.
Example: if you want to restrict the user based on the state then we need to create Role for each state.
46. Can we delete datasets in Pro from Workspace?
Yes
47. Can we create a dashboard from visuals from multiple pages within the report?
Yes, we can create a dashboard from multiple pages .
48. Can we create a dashboard from visuals from multiple reports?
Yes we can create a dashboard from visuals from multiple reports.
49. Can we create reports in service?
Yes we can create reports in service.
50. Can we create calculated columns and measures in Service?
No, we cannot create calculated columns and measures in service.
Data Analytic Group 