Power BI 778 Test 1

Question 1

In Power BI Desktop, you create a KPI visualization using the month as the trend axis. However, you realize that the data is not sorted by month. The visualization's sort order must be changed.

What should you start with?

Accepted Answer

Remove the trend axis from the visualization.

Answer

To change the sort order of the trend axis in a KPI visual when it's not sorting correctly by month, you first need to remove the existing trend axis. This allows you to then re-add the month field and ensure it's sorted correctly (e.g., by a hidden month number column) before it's used as the trend axis. Without removing it, Power BI might retain the incorrect sorting behavior or not allow direct modification of the sort order for the trend axis within the KPI visual's properties.

Question 2

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?

Accepted Answer

Add a folder data source and use the Combine Files command

Answer

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.

Question 3

You have an app workspace with a report in it. The report contains confidential information.

You must verify that the report can be embedded into a bespoke application that will be used by external users. There will be no Microsoft Azure Active Directory user accounts or Power BI licenses for external users.

Solution: Purchase Power BI Premium P1 and set up the app workspace to operate in dedicated mode.

Is this achieving the goal?

Accepted Answer

Correct

Answer

Embedding Power BI content for external users who do not have Power BI licenses or Azure Active Directory accounts requires Power BI Premium capacity. Purchasing Power BI Premium P1 and configuring the app workspace to operate in dedicated mode enables 'Embed for your customers' scenarios. This allows the bespoke application to authenticate and display the report without requiring individual user licenses, as the Premium capacity handles the rendering and sharing.

Question 4

You are importing sales data into Power BI Desktop from a Microsoft Excel file named Sales.xlsx. You need to create a bar chart that shows the total sales amount by region. When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region. You must modify the query to ensure that the data appears correctly.

What are your options?

Accepted Answer

Add a calculated column to Query Editor that totals the sales amount column.

Answer

When a sales amount column displays a count instead of a sum in Power BI, it often indicates that the column's data type is not numeric, causing Power BI to default to counting non-numeric entries. While changing the data type directly is a common fix, if the column contains mixed data or requires complex parsing (e.g., extracting numbers from text), adding a calculated column in the Query Editor (Power Query) is a robust solution. This new column can be designed to correctly extract and convert sales values into a clean numeric format, ensuring it can be accurately summed in visualizations.

Question 5

You've uploaded a Microsoft Excel workbook to Microsoft SharePoint Online. Several Power View sheets are included in the workbook.

In the Power BI service, you must replicate the Power View sheets into reports.

Solution: Get the data from SharePoint Online using the Power BI service, then choose Import.

Is this achieving the goal?

Accepted Answer

Correct

Answer

To replicate Power View sheets from an Excel workbook into Power BI service reports, the correct approach is to use the 'Get data' feature in the Power BI service. By choosing to 'Import' the Excel workbook from SharePoint Online, Power BI reads the entire workbook, including its data model and any embedded Power View sheets, and automatically creates corresponding datasets and reports in the Power BI service. This method effectively migrates the Power View content.

Power BI 778 Practice Test

Power BI 778 Practice Test

Power BI 778 Test 1