121. What are Content Packs?
They are collection of related documents and files that are stored as in a set.
Content packs are packaged reports, dashboards, and data sets, which can be shared with other Power BI users in your organization. When a content pack is connected on the Powerbi.com portal, report items are merged into workspace lists. The most notable features of content packs are as follows: Provide access to specific groups or entire organizations can be customized with a title and a description to help users select the right pack Users who have access to the content pack can create new dashboards from the contents
122. What are the different views in Power BI Desktop?
There are three different views in Power BI, each of which serves a different purpose. Report View: Users can add visualizations and additional report pages and publish the same on the portal from here.Data View: Data shaping can be performed through Query Editor Tools. Relationship View: Users can manage relationships between data sets in this view.
123. What is Row-level Security?
Row-level security restricts the data that a user can view and has access to, based on filters. For configuring row-level security, users can define rules and roles within Power BI Desktop and publish the same to Power BI Service. Also, the username () function can be used alongside table relationships to restrict data to the current user. However, for enabling row-level security, a Power BI Pro subscription account is required, and Excel sheets can only be used when they are converted to the .pbix file format.
124. What is DAX? What are the benefits of using Variables in DAX?
DAX or Data Analysis Expressions can be used to query and return data by a table expression. It is a formula language which is used to perform basic calculations and data analysis on data in Power Pivot. Also, it is used to compute calculated columns, calculated fields, and measures. However, data cannot be inserted or modified using DAX.DAX Syntax: Total Sales = SUM(Sales[SalesAmount])Where, Total Sales is a \u2018Measure\u2019; SUM is a \u2018DAX Function\u2019; and Sales[SalesAmount] represents the referenced table and referenced column name.Benefits of using variables in DAX:Variables can be reused in DAX queries, thus avoiding additional queries of source database.Variables make DAX expressions understandable.
125. What is Bidirectional Cross-filtering in Power BI?
Bidirectional cross-filtering in Power BI Desktop allows data modelers to determine how they want filters to flow for data using relationships between tables. With bidirectional cross-filtering, the filter context is propagated to a second related table on the other side of a table relationship. This can help them solve the many-to-many problem without writing complicated DAX formulas. Thus, bidirectional cross-filtering simplifies the job for data modelers.
126. How are relationships defined in Power BI Desktop?
If there are no null values or duplicate rows, relationships between tables can be defined in two ways:Manually: Users can manually define relationships between tables using primary and foreign keys.With the Autodetect feature: When enabled, this inherent feature of Power BI detects relationships between tables and creates them automatically.
127. What do you know about Power BI Query Editor?
By using Power BI Query Editor, users can load data from a wider number of data sources and apply transformations on them, including adding new columns and measures.Power BI Query Editor comprises four tabs:Query Editor Tab Use CaseHomeImport data from Query Editor in New Query groupUse Parameter group to create and manage parametersIncludes\u00a0a\u00a0function\u00a0to\u00a0refresh\u00a0the\u00a0preview\u00a0data\u00a0for\u00a0the current\u00a0table,\u00a0or\u00a0all\u00a0tables, in\u00a0the\u00a0data setManage columns, reduce rows, and sort groupsTransformChange data types of columns, rename columns, replace values, and fix errors in Any Column groupStructured Column group provides options for working with the nested dataRun R Script function enables to run R Queries directly on Power BI Query EditorAdd ColumnUse Add Custom Column to create a new column using a DAX formulaUse\u00a0Conditional\u00a0Column\u00a0to\u00a0add\u00a0a\u00a0column\u00a0based\u00a0on\u00a0the\u00a0values in\u00a0another\u00a0columnUse\u00a0From\u00a0Number\u00a0group\u00a0to\u00a0apply\u00a0statistical,\u00a0standard,\u00a0and scientific\u00a0functions\u00a0to\u00a0numerical\u00a0columns.ViewShow or hide Query Editor SettingsFrom\u00a0here,\u00a0the\u00a0Advanced\u00a0Editor\u00a0window\u00a0can be opened to\u00a0view\u00a0and edit\u00a0the\u00a0query\u00a0code
128. What is Advanced Editor in Power BI?
Advanced Editor can be used to see the query that Power BI runs against data sources to import data. The query is written in M-code, the Power Query Formula Language To view the query code from Power BI Desktop, choose\u00a0Edit Queries from the Home tab From either the Home or the View tab, click on\u00a0Advanced Editor to work on that query The Advanced Editor window opens, displaying the code for the currently selected query When you make transformations to your data in Query Editor, the steps are saved to the Applied Steps in the Query Settings These steps are also applied to the code in the Advanced Editor
129. Why should General Formatting be applied to data in Power BI?
By formatting data, users can help Power BI categorize and identify data, making it much easier to work with. You enter a custom formula to create a new column, including calculations using values from other columns To create a new column, click on Add Custom Column In the new column name box, type the name of the column and add your formula to the custom column formula box; for example, [ShipDate] – [OrderDate]Select a column from the available columns list and click on Insert or double-click to add it to the custom column formula text box. Then, click on OKThe new column is appended to the table, and the formula is visible in the Formula BarCustom Column Formula= Table.AddColumn(#”Sorted Rows\ “DaysOrderToShip\ each [ShipDate] – [OrderDate])The above code is the formula to create a custom column, which calculates the days from when an order was placed to when it got shipped.
130. What are the most common data shaping techniques?
The most common data shaping techniques are: Removing Columns and Rows Adding Indexes Applying a Sort Order.
131. What is the difference between Calculated Columns, Calculated Tables, and Measures?
Calculated Columns Calculated Tables Measures Added to tables by applying DAX formula on the existing dataDAX formula defines values in new columns rather than querying data sources Useful when data sources do not contain data presented in a desired format Created using DAX formula to define values Created in both Report and Data views Work well for intermediate calculations and data that users want to be stored in the model Use other DAX functions to create complex calculations Used for highlighting running totals, comparing sales, sales forecasting, and other purposes as well Created in both Report and Data views.
132. Which In-memory Analytics Engine is used in Power Pivot?
The primary in-memory analytics engine behind Power Pivot is xVelocity. This engine handles large amount of data as it stores data in columnar databases. In in-memory analytics, all data is loaded to RAM memory, and therefore processing speed is really fast.
133. Is it possible to refresh Power BI Reports after they are published to the cloud?
Yes, it is possible. Gateways can be used to do so.For SharePoint: Data Management Gateway for Powerbi.com: Power BI Personal Gateway
134. What are gateways available in Power BI and why use them?
A gateway basically acts as a bridge between on-premise data sources and Azure Cloud Services. Personal Gateway: Data can be imported and valid on Power BI Service only. Also, this gateway can only be used by one person. On-premises Gateway: This gateway is the advanced form of Personal gateway. It supports Direct Query, and multiple users can use this for refreshing data.
135. How can geographic data be mapped into Power BI Reports?
Through map chart and filled map chart, Power BI makes it possible for users to visually map geographic data, both globally and regionally. Power BI integrates with Bing Maps to find default coordinates for locations in a process known as geocoding. This integration means that users do not need to provide longitude and latitude coordinates.
136. What happens when you click on a single data point in one of the multiple visuals in a report?
When you do that, data gets selected and copied to the clipboard. Further, the copied data can be pasted anywhere as per the requirement of the user.
137. What is z-order in Power BI?
Z-order is a design strategy which is used for arranging visuals over shapes. Also, z-order can be defined as an implementation method which can be applied when reports have multiple elements. Further, this can also be used to refresh the display after the order of items in a report is changed.
138. What is the prerequisite for connecting to a database in Azure SQL Database?
There is only one prerequisite for this. Before connecting to a database in Azure SQL Database, users should configure firewall settings to allow remote connections.
139. What are all the types of Content packs?
Two types of content packs. Services providers like Google Analytics, Marketo. Salesforce Shared by other users in your organization.
140. What are the Power BI mobile devices?
Power BI has its own apps for Android phones, iOS devices, and Windows 10 devices. Download Power BI apps from below:
- Apple App Store
- Google Play
- Windows Store
141. How can I buy Power BI?
You can purchase Power BI licenses directly at www.powerbi.com.
142. What is Power Pivot and what is the filter writes in Power BI?
Power Pivot is an in-memory component that enables highly compressed data storage. It is used to build a data model, relationship, creating formulas, calculated columns from various resources. Filters are applicable in: – Visualization level
- Page Level
- Report Level.
143. What are some benefits of using Variables in DAX ?
Below are some of the benefits:Â – By declaring and evaluating a variable, the variable can be reused multiple times in a DAX expression, thus avoiding additional queries of the source database.
- Variables can make DAX expressions more intuitive/logical to interpret.
- Variables are only scoped to their measure or query; they cannot be shared among measures, queries or be defined at the model level.
144. Can SQL and Power Query/Query Editor be used together?
Yes,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 by the client machine and M function.
145. Describe DAX
DAX stands for Data Analysis Expressions. It’s a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.
146. Explain the term ‘M language’.
This is the programming language used in Power Query. It’s a functional, case-sensitive language that’s similar to other programming languages and easy to use.
