Courseiva
← Back to Microsoft Power BI Data Analyst PL-300 questions

Scenario-based practice

Refer to the Exhibit Practice Questions

Practise Microsoft Power BI Data Analyst PL-300 practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

Start full practice testRead exam guide
15
scenario questions
PL-300
exam code
Microsoft
vendor

Scenario guide

How to approach refer to the exhibit practice questions

Practise exhibit-style questions that ask you to read a topology, table, command output or diagram before choosing the best answer.

Quick answer

Exhibit-style questions test whether you can read a topology, command output, diagram or table before choosing the best answer.

How to extract the relevant detail from an exhibit.

How topology, command output or routing information affects the answer.

How to avoid answering from memory before reading the evidence.

How to map the exhibit back to the exam objective.

Related practice questions

Related PL-300 topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Prepare the data practice questions

Practise PL-300 questions linked to Prepare the data.

Deploy and maintain assets practice questions

Practise PL-300 questions linked to Deploy and maintain assets.

Model the data practice questions

Practise PL-300 questions linked to Model the data.

Visualize and analyze the data practice questions

Practise PL-300 questions linked to Visualize and analyze the data.

Manage and secure Power BI practice questions

Practise PL-300 questions linked to Manage and secure Power BI.

PL-300 fundamentals practice questions

Practise PL-300 questions linked to PL-300 fundamentals.

PL-300 scenario practice questions

Practise PL-300 questions linked to PL-300 scenario.

PL-300 troubleshooting practice questions

Practise PL-300 questions linked to PL-300 troubleshooting.

Practice set

Practice scenarios

Question 1hardmultiple choice
Full question →

You are reviewing the deployment configuration for a Power BI dataset. The exhibit shows a JSON snippet of the dataset settings. You need to ensure that data is refreshed twice a day at 6:00 AM and 6:00 PM UTC. However, the refresh fails at both scheduled times. What is the most likely cause?

Exhibit

Refer to the exhibit.

{
  "version": "1.0",
  "datasetSettings": {
    "refreshSchedule": {
      "frequency": "Daily",
      "times": ["06:00", "18:00"],
      "enabled": true,
      "localTimeZone": "UTC"
    },
    "directQuery": {
      "enableDirectQuery": false
    }
  },
  "dataSources": [
    {
      "name": "SalesDB",
      "connectionString": "Server=sqlsrv01;Database=Sales;Integrated Security=SSPI;",
      "credentialType": "Windows",
      "gatewayId": "gateway-cluster-01"
    }
  ]
}
Question 2hardmultiple choice
Full question →

A Power BI administrator reviews the JSON configuration for a dataset named SalesDataset. The dataset is deployed to a Premium capacity workspace. The data source is an on-premises SQL Server. The administrator notices that the dataset has never refreshed successfully. Based on the exhibit, what is the most likely cause of the refresh failure?

Exhibit

Refer to the exhibit.

```json
{
  "dataset": {
    "name": "SalesDataset",
    "defaultMode": "Push",
    "refreshSchedule": {
      "enabled": true,
      "frequency": "Weekly",
      "days": ["Monday"],
      "times": ["02:00"]
    },
    "dataSources": [
      {
        "type": "Sql",
        "connectionString": "Server=sqlserver01;Database=SalesDB;Integrated Security=SSPI"
      }
    ]
  }
}
```
Question 3hardmultiple choice
Full question →

Refer to the exhibit. The Power Query M code imports a CSV file. The import succeeds, but the 'OrderDate' column shows some dates as null even though they appear valid in the CSV. What is the most likely cause?

Exhibit

Refer to the exhibit.

let
    Source = Csv.Document(File.Contents("C:\Data\Sales.csv"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"OrderDate", type date}, {"Amount", type number}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","null",null,Replacer.ReplaceValue,{"Product"}),
    #"Filtered Rows" = Table.SelectRows(#"Replaced Value", each [Amount] > 0)
in
    #"Filtered Rows"
Question 4hardmultiple choice
Full question →

You are reviewing a Power BI data source configuration in the data source settings. The exhibit shows the JSON representation of a data source. Which issue might arise from this configuration?

Exhibit

Refer to the exhibit.
```json
{
  "dataSources": [
    {
      "name": "SalesDB",
      "connectionDetails": {
        "server": "sqlsrv-prod.database.windows.net",
        "database": "SalesDB",
        "authenticationKind": "Key",
        "options": {
          "CommandTimeout": 600,
          "CreateNavigationProperties": false
        }
      }
    }
  ]
}
```
Question 5hardmultiple choice
Full question →

You are debugging a Power Query that imports a CSV file. The exhibit shows the M code. The CSV file contains a header row and data. Some rows have a comma inside a quoted field (e.g., "Smith, John"). What issue will arise from this code?

Exhibit

Refer to the exhibit.
```
let
    Source = Csv.Document(File.Contents("C:\data\sales.csv"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"OrderDate", type datetime}, {"Amount", type number}})
in
    #"Changed Type"
```
Question 6hardmultiple choice
Full question →

Refer to the exhibit. You are reviewing a Power Query script. The script fails with a 'DataSource.Error: Microsoft SQL: Login failed for user' error. Which step should you check first?

Exhibit

Refer to the exhibit.

// Power Query M code
let
    Source = Sql.Database("server", "database"),
    dbo_Orders = Source{[Schema="dbo",Item="Orders"]}[Data],
    #"Filtered Rows" = Table.SelectRows(dbo_Orders, each [OrderDate] > #date(2024,1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"CreditCardNumber"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"OrderDate", type date}})
in
    #"Changed Type"
Question 7hardmultiple choice
Full question →

Refer to the exhibit. You are reviewing a Power BI data source privacy configuration. The SalesSQL data source is set to 'Organizational' and the MarketingCSV is set to 'Private'. You plan to combine these two sources in a query. What will happen when the query is executed?

Exhibit

Refer to the exhibit.

{
  "dataSources": [
    {
      "name": "SalesSQL",
      "connectionString": "Data Source=sqlserver01;Initial Catalog=AdventureWorks;Integrated Security=SSPI;"
    },
    {
      "name": "MarketingCSV",
      "connectionString": "C:\\Data\\Marketing.csv"
    }
  ],
  "privacyLevels": {
    "SalesSQL": "Organizational",
    "MarketingCSV": "Private"
  }
}
Question 8hardmultiple choice
Full question →

Refer to the exhibit. You are configuring a Power BI dataset with row-level security (RLS) using a JSON policy. The exhibit shows an RLS configuration. A user 'analyst@contoso.com' has access to the 'Orders' table. However, when the user views the report, no data is displayed. What is the most likely cause?

Exhibit

Refer to the exhibit.
```json
{
  "dataSources": [
    {
      "name": "SalesDB",
      "connectionString": "Data Source=sqlserver01;Initial Catalog=Sales;Integrated Security=SSPI;"
    }
  ],
  "permissions": [
    {
      "user": "analyst@contoso.com",
      "dataSources": ["SalesDB"],
      "tables": ["Orders"]
    }
  ]
}
```
Question 9easymultiple choice
Full question →

Refer to the exhibit. You are configuring a scheduled refresh for a Power BI dataset. The exhibit shows the refresh schedule settings. The dataset is in a workspace in a Premium capacity. The scheduled refresh runs at 5:00 AM UTC daily. However, the refresh is failing consistently. What is the most likely cause?

Exhibit

Refer to the exhibit.
```json
{
  "refreshSchedule": {
    "frequency": "Daily",
    "time": "05:00",
    "timeZone": "UTC",
    "notifyOption": "OnFailure",
    "notifyEmail": "admin@contoso.com"
  }
}
```
Question 10hardmultiple choice
Full question →

You are analyzing a DAX query as shown in the exhibit. You need to determine the result set. The model contains tables: Date, Product, and Sales with relationships. Which statement accurately describes the output?

Exhibit

Refer to the exhibit.
```dax
EVALUATE
SUMMARIZECOLUMNS(
    'Date'[Year],
    'Product'[Category],
    "Total Sales", CALCULATE(SUM('Sales'[Amount]), FILTER('Sales', 'Sales'[Amount] > 100))
)
```
Question 11mediummultiple choice
Full question →

Refer to the exhibit. You write this Power Query M code to import data. What does the final step do?

Exhibit

Refer to the exhibit.

M code snippet:
let
    Source = Sql.Database("Server", "Database"),
    SalesTable = Source{[Schema="dbo",Item="Sales"]}[Data],
    #"Filtered Rows" = Table.SelectRows(SalesTable, each [Amount] > 100)
in
    #"Filtered Rows"
Question 12mediummultiple choice
Full question →

Refer to the exhibit. A user is a member of both 'Manager' and 'Executive' roles. Which rows will the user see?

Exhibit

{
  "name": "RLS Policy",
  "roles": [
    {
      "roleName": "Manager",
      "filterExpression": "[Department] = \"Sales\""
    },
    {
      "roleName": "Executive",
      "filterExpression": "[Department] = \"Sales\" OR [Department] = \"Marketing\""
    }
  ]
}
Question 13hardmultiple choice
Full question →

Refer to the exhibit. You are reviewing a DAX measure for month-over-month sales growth. The measure returns BLANK for all months. What is the likely issue?

Exhibit

Refer to the exhibit.

```dax
DEFINE
    VAR SelectedDate = MAX('Date'[Date])
    VAR PriorDate = DATEADD('Date'[Date], -1, MONTH)
    VAR PriorSales = 
        CALCULATE(
            SUM(Sales[Amount]),
            FILTER(ALL('Date'), 'Date'[Date] = PriorDate)
        )
    RETURN
        IF(
            PriorSales = 0,
            BLANK(),
            ( SUM(Sales[Amount]) - PriorSales ) / PriorSales
        )
```

You are reviewing a DAX measure for month-over-month sales growth. The measure returns BLANK for all months. What is the likely issue?
Question 14hardmultiple choice
Full question →

Refer to the exhibit. You are implementing row-level security (RLS) in Power BI. The JSON policy above is applied to the 'Sales' table. The user is in the 'SalesRegion' role. Which rows will the user see?

Exhibit

{
  "name": "policy1",
  "policyType": "TableLevel",
  "roles": [
    {
      "roleName": "SalesRegion",
      "filterExpression": "[Region] = \"North\""
    }
  ],
  "tables": ["Sales"],
  "filterExpression": "[Region] = \"South\""
}
Question 15hardmultiple choice
Full question →

Refer to the exhibit. The DAX measure 'Sales YTD' is defined as shown. The model has a Date table marked as a date table and a relationship to Sales[OrderDate]. However, the measure returns BLANK for all months except December. What is the most likely cause?

Exhibit

Refer to the exhibit.

```dax
Sales YTD = 
CALCULATE(
    SUM(Sales[Amount]),
    DATESYTD('Date'[Date])
)
```

The model has a Date table marked as a date table and a relationship to Sales[OrderDate]. However, the measure returns BLANK for all months except December. What is the most likely cause?

These PL-300 practice questions are part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style PL-300 questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.