Describe the business value of Microsoft Power Platform →mediumMultiple ChoiceObjective-mapped

PL-900 Practice Question: Describe the business value of Microsoft Power Platform

Exhibit

{
  "name": "Sales Dashboard",
  "dataSources": [
    {
      "type": "SQL Server",
      "connectionString": "Server=myserver.database.windows.net;Database=SalesDB;..."
    },
    {
      "type": "Excel",
      "path": "https://sharepoint.com/sites/sales/Shared%20Documents/Report.xlsx"
    }
  ],
  "refreshSchedule": {
    "frequency": "Daily",
    "time": "02:00"
  }
}

Refer to the exhibit. A Power BI dashboard is configured with the shown data sources. The dashboard fails to refresh automatically. What is the most likely cause?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The SQL Server data source requires an on-premises data gateway

The dashboard refreshes automatically but fails. The data sources shown are an Excel file stored on SharePoint (supported, no gateway needed) and an on-premises SQL Server (server name indicates on-premises). For Power BI service to access on-premises data, an on-premises data gateway must be installed and configured. Without it, the SQL Server connection will fail during refresh. Options A and D are incorrect because daily frequency and using two data sources are not issues. Option B is incorrect because SharePoint is a supported location for Excel files. Therefore, the most likely cause is that the SQL Server data source requires an on-premises data gateway.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The refresh frequency is set to daily, which is too infrequent
Why it's wrong here
Daily refresh is a valid frequency.
✗
The Excel file is stored in an unsupported location
Why it's wrong here
SharePoint is a supported location for Excel files.
✓
The SQL Server data source requires an on-premises data gateway
Why this is correct
The SQL Server is on-premises (no azure in server name), so a gateway is needed for cloud refresh.
✗
The dashboard uses two data sources, but only one is allowed
Why it's wrong here
Power BI dashboards can have multiple data sources.

Go deeper

PL-900 Practice Question: Describe the business value of Microsoft Power Platform

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question