PL-900 · topic practice

Demonstrate the capabilities of Power BI practice questions

Practise Microsoft Power Platform Fundamentals PL-900 Demonstrate the capabilities of Power BI practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
15 questionsDomain: Demonstrate the capabilities of Power BI

What the exam tests

What to know about Demonstrate the capabilities of Power BI

Demonstrate the capabilities of Power BI questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Demonstrate the capabilities of Power BI exam traps

  • Answering from memory before reading the full scenario.
  • Missing a constraint such as cost, availability, security, scope or command context.
  • Choosing a broad answer when the question asks for the most specific fix.
  • Ignoring why the wrong options are tempting.

Practice set

Demonstrate the capabilities of Power BI questions

15 questions · select your answer, then reveal the explanation

A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?

A company uses Power BI to monitor manufacturing efficiency. The dataset includes a column 'RunTime' (in minutes) and 'DownTime' (in minutes). A user wants to calculate 'Availability' as (RunTime / (RunTime + DownTime)) * 100. Which DAX measure should be used?

A financial analyst creates a Power BI report to compare quarterly revenue across years. The data has a 'Date' column and a 'Revenue' column. The analyst wants to display year-over-year growth for each quarter. Which visual and configuration would best achieve this?

A marketing team wants to share a Power BI dashboard with external stakeholders who do not have Power BI licenses. Which sharing method should the team use?

A data analyst notices that a Power BI report takes a long time to load when filtering by a specific date range. The data source is a SQL Server view that contains millions of rows. What is the most effective way to improve performance?

Which TWO of the following are valid ways to connect to data in Power BI Desktop?

Which THREE of the following are features available in Power BI Premium per capacity? (Select three.)

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

Exhibit

Refer to the exhibit.

```
{
  "name": "SalesReport",
  "dataset": "SalesDB",
  "refreshSchedule": {
    "frequency": "Daily",
    "time": "02:00",
    "timeZone": "UTC",
    "days": ["Monday","Tuesday","Wednesday","Thursday","Friday"]
  },
  "dataSources": [
    {
      "type": "Sql",
      "connectionString": "Server=sqlsrv;Database=SalesDB;Integrated Security=SSPI;"
    }
  ]
}
```

Refer to the exhibit. A Power BI report connecting to the SalesDB database is slow. The exhibit shows a SQL Server activity snapshot. What is the most likely cause of the performance issue?

Exhibit

Refer to the exhibit.

```
EXEC sp_who2
```

Output:
```
SPID  Status   Login    HostName  BlkBy  DBName   Command   CPUTime DiskIO  LastBatch
54    sleeping sa       SERVER1   .      SalesDB  AWAITING COMMAND  0       0       2023-03-15 10:00:00.000
55    runnable  user1    CLIENT1   54     SalesDB  SELECT    5000    1200    2023-03-15 10:05:00.000
```

You are a data analyst at a manufacturing company that uses Microsoft 365 and Power BI. The company has a Power BI tenant with Free, Pro, and Premium Per User (PPU) licenses. Your team has created a Power BI report that visualizes production line efficiency from a SQL Server database on-premises. The report is published to a workspace assigned to a PPU capacity. You need to ensure that all 50 users in the production department can view the report on their mobile devices, with data refreshing every 30 minutes. The users have a mix of Free and Pro licenses. The report uses DirectQuery mode to the on-premises SQL Server. You have configured an on-premises data gateway in personal mode. Users report that the report is slow and sometimes fails to load. What should you do to improve performance and reliability while meeting the refresh requirement?

Refer to the exhibit. A Power BI developer imported the JSON data into a Power BI data model. When creating a report, they notice that the 'Sales' table does not display the product name. What is the most likely cause?

Exhibit

Refer to the exhibit.

```
{
  "data": [
    {
      "table": "Sales",
      "columns": ["Date", "ProductID", "SalesAmount", "Region"],
      "rows": [
        ["2024-01-01", 101, 250.00, "North"],
        ["2024-01-01", 102, 150.00, "South"],
        ["2024-01-02", 101, 300.00, "North"]
      ],
      "relationships": [
        {"from": "Sales[ProductID]", "to": "Product[ProductID]"}
      ]
    },
    {
      "table": "Product",
      "columns": ["ProductID", "ProductName", "Category"],
      "rows": [
        [101, "Widget", "Tools"],
        [102, "Gadget", "Electronics"]
      ]
    }
  ]
}
```

Which TWO actions are supported by Power BI to share a report with external users who do not have an Azure Active Directory (Azure AD) account in the tenant?

You are a Power BI administrator for a retail company. The sales team uses a Power BI report that connects to an on-premises SQL Server database via an on-premises data gateway. Recently, several users reported that the report is showing stale data. The report is configured to refresh daily at 8:00 AM. Upon investigation, you find that the scheduled refresh failed last night at 8:00 AM with an error: 'The data source credentials could not be encrypted using the gateway's encryption key.' The gateway is installed on a server that was rebooted for maintenance at 7:30 AM. The gateway service account is a local service account. The data source credentials were configured using a SQL Server authentication login. What should you do to resolve the issue?

Drag and drop the steps to create a connection between Power Automate and a third-party service like Office 365 in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5

Match each Power Automate trigger type to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Starts based on an event (e.g., new email)

Starts manually by a user action

Starts at a specified time or interval

A type of scheduled trigger repeating regularly

Starts from a button in a Power App

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Focused Demonstrate the capabilities of Power BI sessions

Start a Demonstrate the capabilities of Power BI only practice session

Every question in these sessions is drawn from the Demonstrate the capabilities of Power BI domain — nothing else.

Related practice questions

Related PL-900 topic practice pages

Move into related areas when this topic feels solid.

Identify foundational components of Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Power Platform.

Demonstrate capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate capabilities of Power BI.

Describe complementary Microsoft Power Platform solutions practice questions

Practise PL-900 questions linked to Describe complementary Microsoft Power Platform solutions.

Demonstrate the capabilities of Power Automate practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.

Describe the business value of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Describe the business value of Microsoft Power Platform.

Manage the Microsoft Power Platform environment practice questions

Practise PL-900 questions linked to Manage the Microsoft Power Platform environment.

Identify foundational components of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Microsoft Power Platform.

Demonstrate the capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power BI.

Demonstrate the capabilities of Power Apps practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Apps.

Demonstrate the capabilities of Microsoft Copilot Studio practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Microsoft Copilot Studio.

Demonstrate the capabilities of Power Pages practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Pages.

PL-900 fundamentals practice questions

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

Frequently asked questions

What does the PL-900 exam test about Demonstrate the capabilities of Power BI?
Demonstrate the capabilities of Power BI questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Demonstrate the capabilities of Power BI questions in a focused session?
Yes — the session launcher on this page draws every question from the Demonstrate the capabilities of Power BI domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other PL-900 topics?
Use the topic links above to move to related areas, or go back to the PL-900 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the PL-900 exam covers. They are not copied from any real exam or dump site.