Power BI 778 Test 1 — Questions and Answers
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. <br> <br> What should you start with?
- Remove the trend axis from the visualization. (Correct answer)
- Convert the visualization to a different type
- Modify the drillthrough filters
- Modify the visual level filters
Correct answer: Remove the trend axis from the visualization.
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. <br> <br> What are your options?
- Add a folder data source and use the Merge Queries command
- Add text/CSV data sources and use the Append Queries command
- Add a folder data source and use the Combine Files command (Correct answer)
- Add a Microsoft Excel data source and use the Merge Queries command
Correct 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.
Question 3: You have an app workspace with a report in it. The report contains confidential information. <br> <br> 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. <br> <br> Solution: Purchase Power BI Premium P1 and set up the app workspace to operate in dedicated mode. <br> <br> Is this achieving the goal?
- Incorrect
- Correct (Correct answer)
Correct answer: Correct
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. <br> <br> What are your options?
- Add a calculated column to Query Editor that totals the sales amount column. (Correct answer)
- Remove the query, then import the data into Microsoft SQL Server.
- Refresh the data model
- Change the sales amount column's data type to Numeri
Correct answer: Add a calculated column to Query Editor that totals the sales amount column.
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. <br> <br> In the Power BI service, you must replicate the Power View sheets into reports. <br> <br> Solution: Get the data from SharePoint Online using the Power BI service, then choose Import. <br> <br> Is this achieving the goal?
- Incorrect
- Correct (Correct answer)
Correct answer: Correct
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.
Question 6: In Power BI Desktop, you have two queries: Query1 retrieves a table named SMB Customers from a Microsoft SQL Server database, while Query2 retrieves a table named Enterprise Customers from an Oracle database. Both tables have the identical columns. The data from SMB Customers and Enterprise Customers must be combined. <br> <br> Which command do you need to use?
- Merge Columns
- Combine Files
- Append Queries (Correct answer)
- Merge Queries
Correct answer: Append Queries
When you have two or more tables with identical columns and you need to combine their rows vertically into a single table, the 'Append Queries' command in Power Query (Query Editor) is the appropriate tool. This operation stacks the data from one query on top of another, consolidating all the customer records from both SMB and Enterprise sources into a unified dataset. 'Merge Queries,' in contrast, combines tables horizontally based on matching column values.
Question 7: App1 is the name of your Power BI app. The App1 app workspace's privacy is set to Private. <br> <br> App1 does not exist in the My organization AppSource, according to User1. <br> <br> For your account, App1 appears in the My organization AppSource. User1 must be able to see App1 from the My organization AppSource. <br> <br> What are your options?
- Add a member from the workspace settings in the app
- Update app, configure the Access setting, and then click Update app from the app workspace. (Correct answer)
- Update app, configure the Content settings, and then click Update app from the app workspace
- Share the dashboard from the app workspace
Correct 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.
Question 8: You're working on a Power BI Desktop report with many bar charts and a date slicer, and you need to make a slide show that can be seen via the Power BI service. The charts must be filtered for a different year on each slide. <br> <br> Before you publish the report, what should you do?
- Create bookmarks after filtering the bar charts with the slicer (Correct answer)
- Create groups using the List group type after configuring report level filters
- Create groups using the Bin group type after configuring page level filters.
- Select Selection Pane after configuring drillthrough filters for each bar chart
Correct answer: Create bookmarks after filtering the bar charts with the slicer
To create a slideshow where bar charts are filtered for different years on each 'slide' (or view), Power BI bookmarks are the ideal solution. Bookmarks capture the current state of a report page, including all applied filters, slicer selections, and visual configurations. By setting the date slicer to a specific year and then creating a bookmark for that state, you can define multiple views that can then be played sequentially as a slideshow in the Power BI service.
Question 9: You've uploaded a Microsoft Excel workbook to Microsoft SharePoint Online. Several Power View sheets are included in the workbook. <br> <br> In the Power BI service, you must replicate the Power View sheets into reports. <br> <br> Solution: Click Publish to Power BI and then Export from Excel. <br> <br> Is this achieving the goal?
- Incorrect (Correct answer)
- Correct
Correct answer: Incorrect
The solution of clicking 'Publish to Power BI' and then 'Export from Excel' is incorrect for replicating Power View sheets into Power BI service reports. The 'Publish to Power BI' option in Excel primarily uploads the Excel workbook itself to the Power BI service, either for viewing in the browser or to create a dataset from its data model. It does not automatically transform Power View sheets into native Power BI reports. The correct method involves using the 'Get data' and 'Import' options directly within the Power BI service, as described in Q2.
Power BI 778 Test 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?