Mixed Deck — All Power BI 778 Topics Flashcards

Which cardinality setting should you use when one row in Table A matches exactly one row in Table B?

Answer: One-to-one

A one-to-one relationship means each row in Table A has exactly one corresponding row in Table B.

What does 'Promote Headers' do in Power Query?

Answer: Uses the first row of data as the column headers

Promote Headers takes the first row of the dataset and converts it into the column header names.

What Power BI feature allows you to group numerical data into ranges for analysis?

Answer: Binning

Binning in Power BI groups continuous numerical data into defined ranges (bins) to simplify distribution analysis.

App1 is the name of your Power BI app. The App1 app workspace's privacy is set to Private. App1 does not exist in the My organization AppSource, according to User1. For your account, App1 appears in the My organization AppSource. User1 must be able to see App1 from the My organization AppSource. What are your options?

Answer: Update app, configure the Access setting, and then click Update app from the app workspace.

For users to see a published Power BI app in the 'My organization AppSource' (now typically just 'Apps' in the Power BI service), the app's access settings must be explicitly configured to include those users or groups. Simply adding a user to the app workspace does not automatically grant them access to the published app. Therefore, you must update the app, navigate to its 'Access' settings, specify the intended audience, and then click 'Update app' to apply these changes and make it visible to User1.

You have a Power BI dashboard that shows several sales representations for your company. On the dashboard, you enable Q&A. When using Q&A, you should present users with sample questions to ask. From the Power BI Settings, which settings should you change?

Answer: Datasets

The Q&A feature in Power BI is powered by the underlying datasets that feed the dashboard. To present users with sample questions and improve the overall Q&A experience, you need to configure these settings at the dataset level. Within the dataset's properties in the Power BI service, you can define suggested questions, add synonyms, and manage other Q&A-related options to guide users in their natural language queries.

What does the Power BI Admin Portal allow tenant administrators to manage?

Answer: Tenant-wide settings, user permissions, audit logs, and feature controls

The Admin Portal gives Power BI tenant admins control over organization-wide settings, including export controls, sharing policies, and audit logs.

Which DAX function returns the number of distinct values in a column?

Answer: DISTINCTCOUNT

DISTINCTCOUNT counts the number of unique, non-blank values in a column.

You intend to import 100 CSV files into Power BI Desktop, each containing data from a separate store. The files are identical in structure and are kept on a network share. You must combine the CSV files into a single table. The solution must require the least amount of administrative effort. What are your options?

Answer: Add a folder data source and use the Combine Files command

The most efficient way to combine multiple CSV files with identical structures from a single location is to use the 'Folder' data source connector in Power Query. Once connected to the folder, Power Query automatically detects the files and offers a 'Combine Files' command. This intelligently appends all files into a single table with minimal manual effort, automating the process of reading and appending each file.

What is the purpose of a 'Parameter' in Power Query?

Answer: A variable value that can be used dynamically within query steps

A Power Query Parameter is a reusable variable that can be used in query steps, source paths, or filter conditions.

What happens when you set a query's load setting to 'Enable Load' off in Power Query?

Answer: The query runs but its results are not loaded into the data model

Disabling 'Enable Load' keeps the query available as a staging or reference query without adding its data to the final model.

What is the purpose of the 'Unpivot Columns' transformation in Power Query?

Answer: Converts multiple columns into attribute-value row pairs

Unpivot Columns rotates selected columns into rows, creating an attribute column and a value column for each combination.

What does the 'Drill Down' feature in Power BI visuals allow users to do?

Answer: Navigate from a higher level of a hierarchy to a more detailed level

Drill Down lets users click into a visual to explore deeper levels of a data hierarchy, such as going from Year to Quarter to Month.

What is Azure Active Directory (AAD) used for in Power BI?

Answer: Authenticating users and managing access permissions to Power BI resources

Azure Active Directory handles authentication and authorization for Power BI, controlling who can access what content based on identity.

Which column characteristic allows the VertiPaq engine to achieve the highest compression ratio?

Answer: Low-cardinality integer columns

VertiPaq compresses columns based on cardinality; integer columns with few distinct values achieve the highest compression because the engine stores only a small dictionary plus a compressed index.

What does enabling 'Export to Excel' in Power BI tenant settings allow users to do?

Answer: Download underlying data from Power BI visuals into Excel spreadsheets

When enabled, this setting permits report consumers to export the data behind Power BI visuals into Excel files.

To display data from a PubNub source, you must create a dashboard in the Power BI service. What are your options?

Answer: A custom streaming data tile can be added to a dashboard

To display real-time data from a streaming source like PubNub directly on a Power BI dashboard, the appropriate method is to add a custom streaming data tile. Power BI supports streaming datasets that can connect to various real-time data feeds. These tiles are specifically designed to visualize constantly updating data streams directly on a dashboard, providing immediate insights without needing a full report.

Which Power Query transformation splits a column into multiple columns based on a delimiter?

Answer: Split Column

Split Column divides a column into multiple columns using a specified delimiter like a comma, space, or custom character.

What does 'Dual' storage mode mean for a table in Power BI?

Answer: The table can act as either Import or DirectQuery depending on the query

Dual mode allows a table to behave as Import or DirectQuery depending on whether the query requires cached or live data.

Which visual is most appropriate for displaying part-to-whole relationships as percentages?

Answer: Pie or donut chart

Pie and donut charts show how individual parts contribute to a total whole, making them ideal for percentage breakdowns.

What is a 'dataflow' in Power BI?

Answer: A reusable set of Power Query transformations stored in the Power BI Service

Dataflows store reusable Power Query ETL logic in the cloud, allowing multiple datasets and reports to share the same transformation logic.