PL-300 Exam Questions

You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you...

You have a Power BI report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden. You need to create a solution that will enable users to quickly navigate from th...

You have a Power BI report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In R...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error. You need to resolve the error. What...

You have a PBIX file that contains sensitive information. You need to secure the information to meet the following requirements: - Only internal users must be able to open the file...

You have a Fabric workspace named Workspace1 that contains two Power BI reports named Report1 and Report2. You create a workspace app that contains both reports. You need to ensure...

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects t...

For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model conta...

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: - Customer ID - Customer Name - Phone - Email Address -...

Drag and Drop Question In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product. Every Product has a ProductSubCategory. Not every Produ...

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. A...

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the...

You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string leng...

You have the Power BI model shown in the following exhibit. A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requiremen...

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an import...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You are building a data model for a Power BI report. You have data formatted as shown in the following table. You need to create a clustered bar chart as shown in the following exh...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

A user creates a Power BI report named ReportA that uses a custom theme. You create a dashboard named DashboardA. You need to ensure that DashboardA uses the custom theme. The solu...

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order. You add the following fields to the Explain By field: - Customer C...

You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaini...

You are building a Power BI report. Users will view the report by using their mobile device. You need to configure the report to display data based on each user's location. Which t...

In Power BI Desktop, you have a dataset that contains a table. You create a table visual on a Power BI report page as shown in the following exhibit. You need to configure the visu...

You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refr...

You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity. Which two actions will cause the...

Case Study 4 - Contoso Ltd 2 Overview Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts m...

Case Study 4 - Contoso Ltd 2 Overview Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts m...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 4 - Contoso Ltd 2 Overview Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts m...

Case Study 4 - Contoso Ltd 2 Overview Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts m...

Case Study 4 - Contoso Ltd 2 Overview Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts m...

You are creating a query to be used as a Country dimension in a star schema. A snapshot of the source data is shown in the following table. You need to create the dimension. The di...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an import...

You have a Power BI data model that contains a table named Employees. The table has the following columns: - Employee Name - Email Address - Start Date - Job Title You are implemen...

You have a Power BI data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custom columns. Later, you a...

You have a Power BI model that contains a table named Sales. The Sales table contains the following columns: - Order Line ID - Product ID - Unit Price - Order ID - Quantity Orders...

You have a Power BI data model that contains a table named Employees. The table has the following columns: - Employee Name - Email Address - Start Date - Job Title You are implemen...

You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements: - Sales invoices must be exported in a PDF format. - The PDF exp...

You have a Power BI report that contains a page. The page contains the following: - A shape named Shape1 - A card named Sales Summary - A clustered bar chart named Sales by Region...

In Power BI Desktop, you are creating a report that will contain three pages. You need to create a custom tooltip page and prepare the page for use. Which three actions should you...

You have a Power BI report named ReportA. You have a Power BI tenant that allows users to export data. You need to ensure that consumers of ReportA cannot export any data from visu...

You have a Power BI report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do?

You need to create a visual that compares profit across 10 product categories for a selected quarter. What is the best visual to use to achieve the goal?

You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You ne...

From Power Query Editor, you attempt to execute a query and receive the following error message. Datasource.Error: Could not find file. What are two possible causes of the error? E...

You have data in a Microsoft Excel worksheet as shown in the following table. You need to use Power Query to clean and transform the dataset. The solution must meet the following r...