Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. PL-300

Microsoft PL-300 Exam
Microsoft Power BI Data Analyst (Page 11 )

Updated On: 9-Feb-2026
Page 11 of 68
PDF with 371 Questions

You have a Microsoft Power BI Desktop report named Report1 that uses an Azure SQL database as a data source.
A user named User1 plans to create a report by using the same data source as Report1.
You need to simplify the connection to the data source for User1.
Which type of file should you create?

  1. PBIDS
  2. XLSX
  3. PBIT
  4. PBIX

Answer(s): A



HOTSPOT (Drag and Drop is not supported)
You have a Power BI semantic model.
You discover that the semantic model contains values that display as errors.
You need to use data profiling features in Power Query to preview the data and identify the issues.
What should you select to gain insight into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1.
Model1 must show updated data within two minutes of the data being updated in DB1.
You need to select a connectivity mode for the connection to DB1.
What should you choose?

  1. DirectQuery
  2. live connection
  3. import

Answer(s): A



You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements:
• The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.
• The orders must be filtered to the selected CustomerID value.
• Users must select the CustomerID value from a list.
• The list of customers must come from an OData source.
Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. an Orders query that has a filter on CustomerID
  2. a Customers query that has a filter on CustomerID
  3. an Orders query that has a single column containing a list of customers
  4. a Customers query that has a single column containing a list of customer IDs
  5. a parameter for CustomerID that uses a query to populate the suggested values
  6. a parameter for CustomerID that uses manually entered values to populate the suggested values

Answer(s): A,D,E



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 lengths in col1. The solution must not affect the size of the model.
What should you do?

  1. In the report, add a DAX calculated column that calculates the length of col1
  2. In the report, add a DAX function that calculates the average length of col1
  3. From Power Query Editor, add a column that calculates the length of col1
  4. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer(s): D






Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:

Join the PL-300 Discussion