Exam PL-300: Microsoft Power BI Data Analyst questions and
answers 2026\2027 A+ Grade
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a
dataset named DS1.
You need to implement an incremental refresh of DS1.
What should you do first?
A. In Power BI Desktop, define filter parameters.
B. In Power BI Desktop, define the incremental refresh policy.
C. Publish the dataset to the Power BI service.
D. Upgrade the Power BI workspace to the Premium SKU.
- correct answer A. In Power BI Desktop, define filter parameters; To implement an incremental refresh
of the dataset, you first need to define an incremental refresh policy, which, in turn, requires defining
filter parameters.
You manage a Power BI workspace.
You need to delegate the task to schedule data refreshes. The solution must use the principle of least
privilege.
Which role should you use?
Select only one answer.
A. Admin
B. Contributor
C. Member
D. Viewer
- correct answer B. The Contributor role is the least privileged role that grants permissions to schedule
data refreshes. The Viewer role does not grant the permissions to schedule data refreshes.
,You need to assign an app workspace role for users who consume reports.
Users should only have permissions to examine the report.
Which role should you assign to users?
Select only one answer.
A. Admin role
B. Contributor role
C. Member role
D. Viewer role
- correct answer D. The Viewer role only has reader access to view reports and dashboards. The
Contributor role can create, update, or publish content. The Member role has many edit permissions in
a workspace, similar to an admin. The Admin role has all the edit permission in a workspace.
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
Select only one answer.
A. OneDrive for Business
B. Personal OneDrive account
C. SharePoint Online Team Sites
D. Shared folder on a local network
- correct answer D. The shared folder on a local network will require a gateway as it is not available to
the internet. SharePoint Online, OneDrive, and OneDrive for Business all can be refreshed as cloud data
sources without a gateway.
You plan to get data for a Power BI dataset from flat files.
You need to select a location for the files. The location must provide the ability to configure scheduled
refresh for the dataset by using Microsoft 365 credentials.
, Which two location types should you recommend? Each correct answer presents a complete solution.
Select all answers that apply.
A. local file
B. OneDrive for Business
C. Personal OneDrive account
D. SharePoint - Team Sites
- correct answer B. and D.: A personal OneDrive account provides the ability to automatically
synchronize flat files residing in a user's OneDrive and Power BI datasets. Since it relies on OneDrive
access, it requires the user's credentials of the corresponding Microsoft account. The OneDrive -
Business option uses Azure Active Directory credentials. The SharePoint - Team Sites option uses the
same Azure Active Directory credentials as the ones used to access SharePoint Online.
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in the Power Query interface? Each
correct answer presents a complete solution.
Select all answers that apply.
A. adding a column
B. clearing permissions
C. editing permissions
D. modifying the file path
E. renaming a column
- correct answer B. clearing permissions
C. editing permissions
D. modifying the file path
Any structural changes to a file, such as adding, removing, or renaming columns are not supported by
the Data Source Settings in the Power Query interface.
answers 2026\2027 A+ Grade
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a
dataset named DS1.
You need to implement an incremental refresh of DS1.
What should you do first?
A. In Power BI Desktop, define filter parameters.
B. In Power BI Desktop, define the incremental refresh policy.
C. Publish the dataset to the Power BI service.
D. Upgrade the Power BI workspace to the Premium SKU.
- correct answer A. In Power BI Desktop, define filter parameters; To implement an incremental refresh
of the dataset, you first need to define an incremental refresh policy, which, in turn, requires defining
filter parameters.
You manage a Power BI workspace.
You need to delegate the task to schedule data refreshes. The solution must use the principle of least
privilege.
Which role should you use?
Select only one answer.
A. Admin
B. Contributor
C. Member
D. Viewer
- correct answer B. The Contributor role is the least privileged role that grants permissions to schedule
data refreshes. The Viewer role does not grant the permissions to schedule data refreshes.
,You need to assign an app workspace role for users who consume reports.
Users should only have permissions to examine the report.
Which role should you assign to users?
Select only one answer.
A. Admin role
B. Contributor role
C. Member role
D. Viewer role
- correct answer D. The Viewer role only has reader access to view reports and dashboards. The
Contributor role can create, update, or publish content. The Member role has many edit permissions in
a workspace, similar to an admin. The Admin role has all the edit permission in a workspace.
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
Select only one answer.
A. OneDrive for Business
B. Personal OneDrive account
C. SharePoint Online Team Sites
D. Shared folder on a local network
- correct answer D. The shared folder on a local network will require a gateway as it is not available to
the internet. SharePoint Online, OneDrive, and OneDrive for Business all can be refreshed as cloud data
sources without a gateway.
You plan to get data for a Power BI dataset from flat files.
You need to select a location for the files. The location must provide the ability to configure scheduled
refresh for the dataset by using Microsoft 365 credentials.
, Which two location types should you recommend? Each correct answer presents a complete solution.
Select all answers that apply.
A. local file
B. OneDrive for Business
C. Personal OneDrive account
D. SharePoint - Team Sites
- correct answer B. and D.: A personal OneDrive account provides the ability to automatically
synchronize flat files residing in a user's OneDrive and Power BI datasets. Since it relies on OneDrive
access, it requires the user's credentials of the corresponding Microsoft account. The OneDrive -
Business option uses Azure Active Directory credentials. The SharePoint - Team Sites option uses the
same Azure Active Directory credentials as the ones used to access SharePoint Online.
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in the Power Query interface? Each
correct answer presents a complete solution.
Select all answers that apply.
A. adding a column
B. clearing permissions
C. editing permissions
D. modifying the file path
E. renaming a column
- correct answer B. clearing permissions
C. editing permissions
D. modifying the file path
Any structural changes to a file, such as adding, removing, or renaming columns are not supported by
the Data Source Settings in the Power Query interface.
