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 to the project management app.Which connector should you select?

Microsoft Teams Personal Analytics

You have a Power Bl model that contains the following data. The Date table relates to the Sales table by using the Date columns.The model contains the following DAX measure.Total Sales = SUM(Sales[Sale])You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.Which DAX calculation should you use?

CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))

CALCULATE ([Total Sales], DATESQTD (Date[Date]))

TOTALQTD ([Total Sales], Date[Date])

CALCULATE < [Total Sales], PARALLELPERIOO (Date[Date], 1, QUARTER))

You have a Power Bl model that contains two tables named Population and Date.The Population table contains two columns named Population Amount and Date Key.DateKey contains date values that represent the first day of a year and are used to create a many-toThe Power Bl model contains two measures that have the following definitions.Total Population = Sum ('Population'[Population Amount])2023 Population = CALCULATE ([Total Population]'Date'[Year] = 2023)You create a table visual that displays Date[Year] and [2023 Population].What will the table visual show?

a single row for the year 2023 that contains the related population value

one row per year that contains blank values for every year except 2023

one row per date that contains the population value for the corresponding year repeated in each row

a single row for the year 2023 that contains the related population value

one row per year that contains the same value repeated for each year

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.The finance team at your company is NOT currently a member of any Power B1 workspace roles.You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.What should you do?

Grant the finance team build permissions to the Finance dataset.

Create a row-level security (RLS) role and add the finance team to the role as members.

Provide an Excel workbook that is connected to the Finance dataset.

Grant the finance team write permissions to the Finance dataset.

Grant the finance team build permissions to the Finance dataset.

You have a Power B1 report. The report contains a line chart that displays sales data for several regions.You need to add an element to the report that will enable users to filter the sales data to include only a selected region.Which two elements achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

a Key Performance Indicator (KPI) visual

A user creates a Power B1 report named ReportA that uses a custom themeYou create a dashboard named DashboardA.You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

From DashboardA upload a JSON theme.

Publish ReportA to the Microsoft Power B1 Community theme gallery.

From DashboardA create a custom theme.

From ReportA save the current theme.

You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:* Sales invoices must be exported in a PDF format* The PDF exports must show all columns and rows clearly.What should you create?

a paginated report that contains a table

an interactive report that contains a matrix

a dashboard that contains a table

an inlet active report that contains a table

You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.From Power Bl Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:* Use Analytics views.* Filter data from the cloud.Which connector should you use?

Azure DevOps Server (Boards only)

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.You attempt to refresh the data and receive the following error message.Expression.Error: The Colum 'cost' of the table wasn't found.What is a possible cause of the error?

The Cost column was renamed in the data source.

The data in the Cost column cannot be converted into the target data type.

The privacy level of the data source does not allow combining the data with other data sources.

The source file was moved to a new location.

Microsoft PL-300 Practice Test 9 - Free Online Exam Prep & Questions

HOTSPOT

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft PL-300 Practice Test 9

Question

Microsoft PL-300 Practice Tests

Practice Tests