Microsoft Power BI Data Analyst practice questions

Try 25 supported questions from the 358-question bank. Check each answer when you are ready and keep this preview’s progress privately in your browser.

Back to the PL-300 exam guide Switch to a timed mock

Free preview

25 of 358 questions are open

This sample includes answers, available explanations, official references and curated community discussion. An Exam Pass unlocks the private complete bank for this exam.

See Exam Pass pricing

Answer support

What is available on this page

9 contested answers

Questions: 25
Explanations: 25
Candidate context: 25
Question citations: 25

25 questions in this bank

Question 1 of 25
Select 2
You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset. You need to ensure that the dataset can be refreshed in powerbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer
Correct answer: D, E
How others answered
DE78%
Explanation
We can import an excel file from multiple connectors (excel workbook, folder, web, sharepoint) but if we must refresh the data from the service with no gateways then We must use web and sharepoint connectors
Adapted from community discussion by Fer079 · 2022-09-29 · 89 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 1 Report an issue
Candidate context
Question 1 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
F
Fer079
2022-09-29
Selected D, E89 upvotes
We can import an excel file from multiple connectors (excel workbook, folder, web, sharepoint) but if we must refresh the data from the service with no gateways then We must use web and sharepoint connectors
F
fred92
2022-10-04
Selected D, E37 upvotes
A, B, C: wrong! Would work technically, but the connection will be only to the local copy of the file, no refresh from the online version stored on OneDrive D: correct, but more complicated than option E E: correct, this is the best option to import from OneDrive
V
venupurna
2023-11-06
28 upvotes
This was in the exam today. I passed the exam with 911 score. My answer : SharePoint Folder and Web
F
Fer079
2022-10-17
18 upvotes
I tried both and they work perfectly, and of course, you need the path (in this case the URL of the excel file on One Drive) of the file, so I don´t see the problem you say...
Question 2 of 25
A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day. What should you do?
Show answer
Correct answer: C
How others answered
C92%
Explanation
Correct Answer C Based on the requirements mentioned, the best option would be to choose option C: Create a dataflows connection that has Import mode selected and schedule a daily refresh. Option A is not the best choice as it requires online processing operations, which goes against one of the requirements. Option B is not necessary since the SQL Server is on-premises and not in a cloud environment. Gateway connections are typically used for cloud-based data sources that require access to on-premises data. Option D refreshes the data too frequently and might lead to unnecessary processing operations, which goes against one of the requirements. Therefore, the best approach is to use Import mode with daily scheduled refreshes to include data from the current year, up to and including the previous day. This would minimize online processing operations and also reduce calculation times and render times for visuals. No confusion, and no need to discuss further
Adapted from community discussion by SanaCanada · 2023-04-05 · 50 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 2 Report an issue
Candidate context
Question 2 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
S
SanaCanada
2023-04-05
Selected C50 upvotes
Correct Answer C Based on the requirements mentioned, the best option would be to choose option C: Create a dataflows connection that has Import mode selected and schedule a daily refresh. Option A is not the best choice as it requires online processing operations, which goes against one of the requirements. Option B is not necessary since the SQL Server is on-premises and not in a cloud environment. Gateway connections are typically used for cloud-based data sources that require access to on-premises data. Option D refreshes the data too frequently and might lead to unnecessary processing operations, which goes against one of the requirements. Therefore, the best approach is to use Import mode with daily scheduled refreshes to include data from the current year, up to and including the previous day. This would minimize online processing operations and also reduce calculation times and render times for visuals. No confusion, and no need to discuss further
I
IxIsa
2022-09-28
44 upvotes
C, because one of the requirements is 'Minimize online processing operations'. Although the dataflow uses DirectQuery, the Dataset can be refreshed with Import.https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery
D
Dovoto
2022-10-10
18 upvotes
The BI developer has already created the dataflow, so the gateway must be present. Import and daily scheduled refresh should do the trick.
I
Igetmyrole
2023-09-04
7 upvotes
The correct answer is C. It is because: Import mode allows us to load and store the data from the DirectQuery source in the Power BI service. This minimizes online processing operations, as calculations are performed during data refresh rather than in real-time during report rendering. Scheduling a daily refresh ensures that our dataflow data is up to date while minimizing the frequency of refresh operations. Since we only need data up to and including the previous day, a daily refresh is sufficient.
Question 3 of 25
HOTSPOT - You are using Power BI Desktop to connect to an Azure SQL database. The connection is configured as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct solution is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
10min Only tables with data If navigate using full hierarchy is unchecked you can see only tables(rows n columns) with data. Otherwise you can see all tables
Adapted from community discussion by Sushvij · 2023-01-10 · 74 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 3 Report an issue
Candidate context
Question 3 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
S
Sushvij
2023-01-10
74 upvotes
10min Only tables with data If navigate using full hierarchy is unchecked you can see only tables(rows n columns) with data. Otherwise you can see all tables
G
GuerreiroJunior
2023-01-10
31 upvotes
The defaut time out is 10 minutes, but if it takes more than it you can enter another value in minutes to keep the connection open longer. 1. 10 minutes 2. All the tables Reference: https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase
P
ppt_powerbi
2023-01-21
30 upvotes
Only tables with data. From your reference link, under Connect using advanced options, it clearly shows that "Navigate using full hierarchy If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data."
H
Hansen_G
2023-01-11
15 upvotes
Navigate using full hierarchy is unchecked. Only table with data will be displayed.
Question 4 of 25
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use?
Show answer
Correct answer: A
How others answered
A71%
B27%
Only 71% agreed on this answer — treat it as contested rather than settled.
Explanation
It should be dataset, because the case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.
Adapted from community discussion by Nomios · 2024-09-20 · 140 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 4 Report an issue
Candidate context
Question 4 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
N
Nomios
2024-09-20
140 upvotes
It should be dataset, because the case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.
T
TopCat1583
2023-03-16
11 upvotes
B is the correct answer. you have to take the data from the data source. How is a data set in power BI a data source? The data source is the excel document.
H
Hoeishetmogelijk
2022-11-28
9 upvotes
The question is confusing because it doesn't tell clearly that there are two reports. So the second report can reuse the dataset of the first one.
V
visionary4ever
2023-06-20
Selected A5 upvotes
A. Power BI dataset The Power BI dataset would be the best option in this scenario. If you've already published a Power BI report that imports data from an Excel file located in SharePoint and the data model contains several measures, you can simply use the existing Power BI dataset to create a new report. This would significantly minimize the development effort as you wouldn't need to import and transform the data again or recreate the measures. In Power BI Desktop, you can select "Power BI Datasets" as your data source and then select the published dataset you want to use. This method allows you to create multiple reports from a single dataset, enabling dataset reusability and consistency across reports. Options B, C, and D would require additional data loading and transformation efforts, which are not necessary in this case as the dataset has already been created and published.
Question 5 of 25
You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps. From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements: • Use Analytics views. • Filter data from the cloud. Which connector should you use?
Show answer
Correct answer: D
How others answered
D51%
B29%
A20%
Only 51% agreed on this answer — treat it as contested rather than settled.
Explanation
I think it is B because this link - has this point - Select Get Data > Online Services, Azure DevOps (Boards only) for cloud services or select Azure DevOps Server (Boards only) for on-premises. Then select Connect. Analytics views only support queries against work items and test cases. I am assuming this is about DevOps on the cloud
Adapted from community discussion by Tex02 · 2024-09-05 · 23 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 5 Report an issue
Candidate context
Question 5 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
T
Tex02
2024-09-05
23 upvotes
I think it is B because this link - has this point - Select Get Data > Online Services, Azure DevOps (Boards only) for cloud services or select Azure DevOps Server (Boards only) for on-premises. Then select Connect. Analytics views only support queries against work items and test cases. I am assuming this is about DevOps on the cloud
B
BIFakeGuru
2024-12-26
Selected D6 upvotes
D. OData Feed Azure DevOps Analytics views expose data through OData feeds. Using the OData Feed connector allows Power BI to pull data from Azure DevOps Analytics while leveraging its built-in filtering capabilities. Why not the other options? A. OData Queries: While this is a generic term, Power BI uses the "OData Feed" connector to interact with OData sources. B. Azure DevOps (Boards only): This connector is designed specifically for Azure Boards data but doesn't support Analytics views or advanced filtering. C. Azure DevOps Server (Boards only): This connector is for on-premises Azure DevOps Server and not the cloud version.
M
MANANDAVEY
2025-01-15
Selected D4 upvotes
To create a bug tracking dashboard in Power BI that pulls data from Analytics in Azure DevOps, you should use the OData Feed connector. Here's why: Use Analytics Views: Analytics in Azure DevOps provides data through OData endpoints. The OData Feed connector allows Power BI to access these endpoints and utilize Analytics views. Filter Data from the Cloud: The OData Feed connector supports querying and filtering data directly from the cloud source, reducing the amount of data imported into Power BI.
3
3433bf6
2024-10-09
4 upvotes
Changed my mind, it's still B, this is the only one mentioned analytics views and in the sample part it mentioned the data can be filtered in analytics view. "Return to the view under the Analytics view in the web portal and adjust the filters to decrease the size of the dataset." This line explains all. https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops
Question 6 of 25
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You add an index key and normalize casing in the data source. Does this meet the goal?
Show answer
Correct answer: A
How others answered
A55%
B45%
Only 55% agreed on this answer — treat it as contested rather than settled.
Explanation
I think the answer is A. adding the index key won't fix the problem by itself but you are also normalising the case which will resolve it.
Adapted from community discussion by Tex02 · 2024-09-05 · 11 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 6 Report an issue
Candidate context
Question 6 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
T
Tex02
2024-09-05
11 upvotes
I think the answer is A. adding the index key won't fix the problem by itself but you are also normalising the case which will resolve it.
L
leah.pring
2024-10-06
4 upvotes
According to Copilot, the answer is A. Here is the explanation I got: Yes, adding an index key and normalizing the casing in the data source can help resolve the issue of undefined values and errors in a Power BI semantic model in DirectQuery mode. Here’s why: Index Key: Adding an index key can improve query performance and ensure that each row is uniquely identifiable, which helps in avoiding errors related to duplicate or missing data1. Normalizing Casing: Normalizing the casing ensures consistency in the data, which can prevent mismatches and errors that arise from case sensitivity issues1. These steps should help in cleaning up the data and making it more reliable for analysis in Power BI. https://learn.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance
N
NadeemSalam
2025-02-11
Selected A2 upvotes
Yes, is the right answer. Adding an index key (e.g., a unique identifier) ensures that each row in the data source is uniquely identifiable, even if the text values are the same after normalizing casing. This helps maintain data integrity and avoids ambiguity in the semantic model. By normalizing the casing (e.g., converting all text to uppercase or lowercase) in the data source, you eliminate case sensitivity issues. This ensures that values like "Apple" and "apple" are treated as the same, resolving undefined values and errors in the Power BI semantic model. Since the semantic model is in DirectQuery mode, all transformations and data preparation must be handled at the data source level. Normalizing casing and adding an index key in the data source ensures that Power BI receives consistent and unambiguous data, resolving the issue without requiring transformations in Power BI.
P
Pitxunet
2025-02-04
Selected A1 upvote
The answer is "Yes". I found the following in the Microsoft documentation: "Because the engine that stores and queries data in Power BI is case insensitive, take special care when you work in DirectQuery mode with a case-sensitive source. Power BI assumes that the source has eliminated duplicate rows. Because Power BI is case insensitive, it treats two values that differ only by case as duplicate, whereas the source might not treat them as such. In such cases, the final result is undefined. To avoid this situation, if you use DirectQuery mode with a case-sensitive data source, normalize casing in the source query or in Power Query Editor." Source: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types Therefore, the solution is to normalize casing at the source.
Question 7 of 25
HOTSPOT - You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
No - Azure SQL Server, therefore no need for an on-premise Gateway as Service and Azure are in the cloud. No - DirectQuery mode for the DB connection, so no need to schedule a refresh. DirectQuery is a live connection. No - Azure SQL supports the following connections from Power BI: Windows, Database and Microsoft Account. (Basic is reserved for Power Query Online. Do not confuse Database with Basic.): https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect
Adapted from community discussion by NotMeAnyWay · 2022-10-28 · 24 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 7 Report an issue
Candidate context
Question 7 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
F
fdsdfgxcvbdsfhshfg
2022-09-18
75 upvotes
No (it's Azure SQLDB; cloud based) No (we need Direct Query) No (we use Azure AD; OAuth2)
N
NotMeAnyWay
2022-10-28
24 upvotes
No - Azure SQL Server, therefore no need for an on-premise Gateway as Service and Azure are in the cloud. No - DirectQuery mode for the DB connection, so no need to schedule a refresh. DirectQuery is a live connection. No - Azure SQL supports the following connections from Power BI: Windows, Database and Microsoft Account. (Basic is reserved for Power Query Online. Do not confuse Database with Basic.): https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect
Z
zerone72
2022-10-12
8 upvotes
1- You definitely don't need a gateway as Azure SQL is could based. 2- The question says that "transactions must be updated within 5 minutes". Therefore, (unless you plan to create a composite model) you should connect to the DB in direct query mode, hence you don't need to schedule any refresh. 3- Azure SQL allow to use OAuth2. This doesn't mean that you can't use basic authentication anymore. The question asks if you CAN use basic authentication and you can still use it, even though you have the option to use azure authentication. In my opinion the answer is : NO, NO , YES !
A
AzureJobsTillRetire
2022-12-22
5 upvotes
Box1: No Here below is directly copied from PowerBI service gateway connection configuration page for a dataset that comes out of an Azure SQL database. "You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect". The question asks if gateway is needed. No you do not need a gateway, but you can use a gateway. Box2: No Again, you do not "need" to configure a scheduled refresh of the dataset if DirectQuery is used, but nothing stops you doing so. Box3: Yes There are two authentication methods, being basic and OAuth2, you might use on the dataset to connect to the database/data. With basic authentication method, you will be asked for user name and password. If you use database credential here, you can use the Basic Authentication method. You can use basic authentication but it does not mean you have to use it.
Question 8 of 25
DRAG DROP - You plan to create a report that will display sales data from the last year for multiple regions. You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions. To define security roles, follow these steps. 1. Import data into your Power BI Desktop report (Step 1) 2. From the Modeling tab, select Manage Roles. 3. From the Manage roles window, select Create. (Step 2) 4. Under Roles, provide a name for the role. 5. Under Tables, select the table to which you want to apply a DAX rule. 6. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ג€Valueג€(Step 3) 7. After you've created the DAX expression, select the checkmark above the expression box to validate the expression. 8. Select Save. Step 3: Assign Users to the role. You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service. After you've created your roles, test the results of the roles within Power BI Desktop. Step 4: Publish the report. Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Adapted from community discussion by vanessa1923 · 2023-02-10 · 17 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 8 Report an issue
Candidate context
Question 8 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
O
OGESSIUSER
2022-09-11
275 upvotes
Import data create the roles on power bi Publish the report Assign Users to the role.
R
RickyAnd
2022-09-15
30 upvotes
Import data create the roles on power bi Publish the report Assign Users to the role. https://docs.microsoft.com/en-us/training/modules/row-level-security-power-bi/2-static-method
V
vanessa1923
2023-02-10
17 upvotes
"You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service. You can enable dynamic security within Power BI Desktop by making use of the username() or userprincipalname() DAX functions and having the proper relationships configured." from https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls OGESSIUSER is correct
L
lizbette
2023-04-30
10 upvotes
their answer is wrong 1) first need to import the data into PBI 2) create roles 3) publish report 4) assign users to role step 1 makes sense because you first need to get the data into PBI before you can do anything step 2: at this point, if you publish the report, then everyone will already have access so you can't do publish. therefore, you need to create roles in PBI step 3: you can't assign users to the role yet because the Power BI desktop doesn't have that ability--it needs to be done in the workspace service online and that can only happen after the report is published to that workspace. therefore step 3 has to be to publish step 4: after publishing, you can then choose the report and the users to assign to the role
Question 9 of 25
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 - If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
Show answer
Correct answer: A
How others answered
A85%
Explanation
Answer should be A, from the Microsoft documentation (https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance): "When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters." This means that you would see all data where either Role1 OR Role2 applies, so the answer is A not D.
Adapted from community discussion by ThariCD · 2022-09-12 · 53 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 9 Report an issue
Candidate context
Question 9 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
T
ThariCD
2022-09-12
Selected A53 upvotes
Answer should be A, from the Microsoft documentation (https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance): "When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters." This means that you would see all data where either Role1 OR Role2 applies, so the answer is A not D.
C
Churato
2022-10-26
46 upvotes
"Multiple role mappings can result in unexpected outcomes. When a report user is assigned to multiple roles, RLS filters become ADDITIVE. It means report users can see table rows that represent the UNION of those filters." Source : https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance
C
cnmc
2022-12-28
33 upvotes
Yes it's simple OR/AND, and you simply don't understand how RLS works. Read Microsoft's doc, and pay attention to this sentence: "Take care: Should a report user map to both roles, they'll see all Payroll table rows." https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance That means different rules don't "merge" to become the most restrictive of the component rules. In the context of this question, IF I want to restrict this user to see ONLY Kentucky IN the year 2020, then I'd set up a RLS that has both of those conditions...
M
md_sultan
2022-12-15
32 upvotes
I have tried and I was able to see for the year 2020 and area , so D should be correct
Question 10 of 25
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?
Show answer
Correct answer: B
How others answered
B54%
A46%
Only 54% agreed on this answer — treat it as contested rather than settled.
Explanation
A, should be correct. We have concept of Query Folding. If we apply the steps and it can be converted to Native Query then it will execute as is. By development process it might mean by building Power BI Report, the view might be production view and as it is having 100 Million record. We cannot update the view for Power BI development.
Adapted from community discussion by BiLearn · 2023-04-10 · 28 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 10 Report an issue
Candidate context
Question 10 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
H
H_E_Z
2022-09-12
32 upvotes
I think query folding can push the filter into the query so A yes
B
BiLearn
2023-04-10
28 upvotes
A, should be correct. We have concept of Query Folding. If we apply the steps and it can be converted to Native Query then it will execute as is. By development process it might mean by building Power BI Report, the view might be production view and as it is having 100 Million record. We cannot update the view for Power BI development.
B
BiLearn
2023-04-10
16 upvotes
Great Explanation by Sana Correct Answer A Yes, when you use Power Query Editor to import a table with a filter in Power BI, only the filtered data is imported into the data model. The Power Query Editor is used to transform and shape the data before it is loaded into the data model. When you apply a filter step to the query in Power Query Editor, it will only select the records that meet the filter criteria, and exclude the records that do not. This filtered data is then loaded into the data model.
D
Denjarus
2022-10-28
14 upvotes
B is correct. This will load the entire table in the first step when you import. Instead add a WHERE clause to the SQL statement
Question 11 of 25
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?
Show answer
Correct answer: A
How others answered
A100%
Explanation
Option A (Publish the reports in an app and grant the HR managers access permission) would be the best option to provide the HR managers with access to the reports while restricting them from modifying the layout. By publishing the reports in an app and granting the HR managers access permission, you can assign them specific roles and permissions that restrict their access to the underlying data while allowing them to view and interact with the reports. The RLS configuration can be set up to ensure that the HR managers can only see data from their own sales region.
Adapted from community discussion by RazaTheLegend · 2024-10-03 · 29 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 11 Report an issue
Candidate context
Question 11 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
G
GPerez73
2022-09-08
39 upvotes
I would say it is correct since an app would prevent to change the layout
R
RazaTheLegend
2024-10-03
Selected A29 upvotes
Option A (Publish the reports in an app and grant the HR managers access permission) would be the best option to provide the HR managers with access to the reports while restricting them from modifying the layout. By publishing the reports in an app and granting the HR managers access permission, you can assign them specific roles and permissions that restrict their access to the underlying data while allowing them to view and interact with the reports. The RLS configuration can be set up to ensure that the HR managers can only see data from their own sales region.
S
svg10gh
2023-01-05
8 upvotes
correct ans looks as A because in the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access. and RLS is used to restrict access to data not to layout of the report. Members are allowed to change the report layout.
S
Snow_28
2022-09-23
5 upvotes
A. would be the answers because in the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Question 12 of 25
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: ✑ Due Date ✑ Order Date ✑ Delivery Date You need to support the analysis of sales over time based on all the date foreign keys. Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date. Does this meet the goal?
Show answer
Correct answer: A
How others answered
A62%
B38%
Only 62% agreed on this answer — treat it as contested rather than settled.
Explanation
I dont understand What micorsoft hopes to achieve with trick questions. If questions leave so much to the analysts assumptions then the questions isnt testing the candidates knowledge
Adapted from community discussion by junaid2107 · 2023-04-27 · 128 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 12 Report an issue
Candidate context
Question 12 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
J
junaid2107
2023-04-27
128 upvotes
I dont understand What micorsoft hopes to achieve with trick questions. If questions leave so much to the analysts assumptions then the questions isnt testing the candidates knowledge
L
legionairemax
2022-09-17
23 upvotes
The answer is correct. However, I believe the alternate solution given is wrong. I would say that 3 relationships for each date respectively would be made from the Date table to the Sales table. One being active and the other two inactive. Thus, allowing to filter by a specific date column The solution suggested is not required, as the report does not require any output that involves all 3 dates. It requires only sales over one date column at a time. Moreover, being date tables, they can significantly increase the size of the model (considering that the table is sales related).
I
Igetmyrole
2023-09-05
7 upvotes
B is the correct answer. No, this solution does not meet the goal of supporting the analysis of sales over time based on all the date foreign keys. Renaming the date query as "Due Date" and referencing it twice in Power Query Editor does not create relationships between the sales table and the date table based on the difference date foreign keys (Due Date, Order Date, and Delivery Date).
M
MoxieTT
2023-05-19
8 upvotes
I keep reading "trick" questions when reading peoples' experiences recently of PL-300.
Question 13 of 25
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: ✑ Due Date ✑ Order Date ✑ Delivery Date You need to support the analysis of sales over time based on all the date foreign keys. Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. Does this meet the goal?
Show answer
Correct answer: A
How others answered
A83%
B17%
Explanation
NO is the Answer. To be able to create the calculations you need the Relationships. They are NOT stated in this suggestion.
Adapted from community discussion by poujor · 2022-11-02 · 21 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 13 Report an issue
Candidate context
Question 13 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
F
fred92
2022-10-21
Selected A28 upvotes
Yes, that will meet the goal. It will increase the model size, but that was not the question.
P
poujor
2022-11-02
21 upvotes
NO is the Answer. To be able to create the calculations you need the Relationships. They are NOT stated in this suggestion.
H
Hoeishetmogelijk
2022-11-22
Selected A9 upvotes
Definitely YES You should follow this refactory methodology: Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query. This question is about an IMPORT table. So the use of a calculated table is recommended. Source: https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
P
PREM77
2023-05-24
4 upvotes
Answer is No. Renaming the date table as "Due Date" and creating calculated tables for "Order Date" and "Delivery Date" will not provide the necessary functionality for analyzing sales over time. To achieve the goal, you would typically create relationships between the date table and the sales table based on the respective date foreign keys. This allows Power BI to perform time-based analysis by using the relationships to filter and aggregate data. Instead of renaming the date table, you should keep it as a separate table, typically named "Date" or "Calendar." Then, you would establish relationships between the date table and the sales table using the respective date foreign keys: Due Date, Order Date, and Delivery Date.
Question 14 of 25
Select 2
You have a Power BI query named Sales that imports the columns shown in the following table.
Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer
Correct answer: A, E
How others answered
AE71%
AD29%
Only 71% agreed on this answer — treat it as contested rather than settled.
Explanation
A, only records with state finished are used D, personally I would transform the column to a date format and not split it since only the date part is used Not E, All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value
Adapted from community discussion by bjornopjemic · 2022-09-19 · 123 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 14 Report an issue
Candidate context
Question 14 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
B
bjornopjemic
2022-09-19
123 upvotes
A, only records with state finished are used D, personally I would transform the column to a date format and not split it since only the date part is used Not E, All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value
E
evipap
2022-11-08
Selected A, E65 upvotes
It says: You need to reduce the LOAD times of the query without affecting the analysis. Only answers A and E can reduce the load times. D may reduce only the time needed to process the data. Someone said that E is not the answer because: "All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value". You must read again the decription cause it says " Each answer presents a COMPLETE solutiuon" not part of a solution.
F
Fer079
2022-10-17
34 upvotes
The option A is clear. Regarding D or E, I understand your point of view and it makes sense, however if we split the date column into two columns then we will have new data types for these columns and maybe it will affect the model and the analysis that we have currently, and one of the requirements is "You need to reduce the load times of the query without affecting the analysis." so we should discard the option D, therefore we should go ahead with the E option
P
prikha16
2023-06-11
19 upvotes
See this, splitting Datetime column has huge impact on size of data model. it is one of the best practices for optimizing performance.
Question 15 of 25
Select 2
You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.
You need to resolve the error. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer
Correct answer: A, B
How others answered
AB100%
Explanation
A reduces the amount of results that you're getting back, therefore reduces query time, and reduces the chances of a timeout occuring. B basically does the same, and is a solution for when you really need al columns and rows: instead of getting one large table back, you'll get multiple smaller ones, then you can combine those after loading. C does exactly the opposite, making the resulting table even larger. D will not help either, as query folding basically expands on the 'select * from ' that Power BI fires to the database. It can, for instance, add a where-clause to that statement if you're filtering in Power Query. That also reduces query time. Source for query folding: https://learn.microsoft.com/en-us/power-query/power-query-folding
Adapted from community discussion by semauni · 2023-04-26 · 23 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 15 Report an issue
Candidate context
Question 15 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
M
milk97
2023-02-26
32 upvotes
This link helps explain query timeout and how to work around it. https://learn.microsoft.com/en-us/training/modules/get-data/9-import-errors
S
semauni
2023-04-26
23 upvotes
A reduces the amount of results that you're getting back, therefore reduces query time, and reduces the chances of a timeout occuring. B basically does the same, and is a solution for when you really need al columns and rows: instead of getting one large table back, you'll get multiple smaller ones, then you can combine those after loading. C does exactly the opposite, making the resulting table even larger. D will not help either, as query folding basically expands on the 'select * from ' that Power BI fires to the database. It can, for instance, add a where-clause to that statement if you're filtering in Power Query. That also reduces query time. Source for query folding: https://learn.microsoft.com/en-us/power-query/power-query-folding
1
1sourabhpatel1
2023-03-18
6 upvotes
Disabling query folding on long running queries is not a recommended solution for resolving the error. Query folding is an optimization technique used by Power Query to translate transformations into optimized SQL statements. Disabling query folding may lead to less optimized query execution plans, which could result in longer query execution times and higher resource consumption.
R
RazaTheLegend
2023-04-12
Selected A, B4 upvotes
Exactly! The answer is correct. https://learn.microsoft.com/en-us/training/modules/get-data/9-import-errors
Question 16 of 25
Select 2
You have a Power BI data model that analyzes product sales over time. The data model contains the following tables.
A one-to-many relationship exists between the tables. The auto date/time option for the data model is enabled. You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Show answer
Correct answer: A, C
How others answered
AC83%
Explanation
AC is the correct answer. According to https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables, marking a table as a Date Table automatically removes the auto-generated date table.
Adapted from community discussion by glenman0202 · 2023-02-17 · 62 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 16 Report an issue
Candidate context
Question 16 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
G
glenman0202
2023-02-17
Selected A, C62 upvotes
AC is the correct answer. According to https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables, marking a table as a Date Table automatically removes the auto-generated date table.
U
UlyUkr
2023-04-30
9 upvotes
This is the tricky question. If I could, I would go with A, B and C. As, first, you'll need to create a date table and mark it as the Date Table. Second you'll need to create the relationship between this table and the Sales table. And lastly, you will need to disable auto date and time option, as per this article, it will decrease the model size. Option A and C does not decrease the model size. Marking a table as a Date table does not automatically remove the auto-hierarchies in other tables, which makes your data model bigger, so you DO need to disable the auto date/time option.
R
RazaTheLegend
2023-04-12
Selected A, C4 upvotes
The correct actions to perform to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter are: A. Create a relationship between the Date table and the Sales table. C. Create a Date table and select Mark as Date Table. Explanation: A. Creating a relationship between the Date table and the Sales table will enable you to analyze product sales by month and quarter, while still maintaining the ability to filter and group the data based on the date. C. Creating a separate Date table and marking it as the Date Table will provide greater control over the data model and reduce its size, as well as enabling the use of time intelligence functions like TOTALYTD, TOTALQTD, and TOTALMTD. B, D, and E are incorrect because they either remove functionality or do not address the need to analyze product sales by month and quarter. No confusion, and no need to discuss further
E
ewelaela
2023-01-15
Selected A, C4 upvotes
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases
Question 17 of 25
You have a Power BI model that contains a table named Employee. The table contains the following data.
Each employee has one manager as shown in the ParentEmployeeID column. All reporting paths lead to the CEO at the top of the organizational hierarchy. You need to create a calculated column that returns the count of levels from each employee to the CEO. Which DAX expression should you use?
Show answer
Correct answer: A
How others answered
A95%
Explanation
Answer A is correct - tested Although for CEO it returns 1 - so I personally would substract 1 from this PATHLENGTH when creating the report, as I think numbers of levels from CEO to CEO is 0, formanagaers directly under CEO it is 1 etc
Adapted from community discussion by ewelaela · 2023-01-15 · 25 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 17 Report an issue
Candidate context
Question 17 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
S
svg10gh
2023-01-11
35 upvotes
A is correct answer. This video proves all https://www.youtube.com/watch?v=uE0G6gLz7WM
E
ewelaela
2023-01-15
Selected A25 upvotes
Answer A is correct - tested Although for CEO it returns 1 - so I personally would substract 1 from this PATHLENGTH when creating the report, as I think numbers of levels from CEO to CEO is 0, formanagaers directly under CEO it is 1 etc
G
gaikwpa
2023-07-07
17 upvotes
PATH will give this - ToTop 100 100|101 100|102 100|101|103 100|101|103|104 100|101|103|105 100|102|106 PATHLENGTH(PATH...) will give this 1 2 2 3 4 4 3
G
glenman0202
2023-02-17
Selected A7 upvotes
According to https://learn.microsoft.com/en-us/dax/path-function-dax, PATH returns a string containing "the identifiers of all the parents to the current identifier", whereas PATHLENGTH returns "the number of items that are parents to the specified item."
Question 18 of 25
Select 2
You have the Power BI model shown in the following exhibit.
A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements: ✑ The managers must only see the data of their respective country. ✑ The number of RLS roles must be minimized. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer
Correct answer: A, C
How others answered
AC68%
AD22%
Only 68% agreed on this answer — treat it as contested rather than settled.
Explanation
The given answer is correct. A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function. C.For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
Adapted from community discussion by Nurgul · 2022-10-06 · 41 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 18 Report an issue
Candidate context
Question 18 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
N
Nurgul
2022-10-06
Selected A, C41 upvotes
The given answer is correct. A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function. C.For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
C
Churato
2022-10-26
33 upvotes
Ok, I agree with A and C but, "Each correct answer presents a complete solution" ? I believe that A and C are each one a part of solution not a complete solution... Am I worng?
T
ThariCD
2022-09-14
19 upvotes
In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service.
H
HBerg_002
2024-02-26
13 upvotes
I believe the given answer is not correct. Furthermore, I believe the most selected answer is incorrect as each option selected should be a complete solution. As mentioned in some other comments, the questions says that each solution should be a COMPLETE solution. If you in isolation performs option C, it would not lead to any RLS being applied in the model. If the question were asking for two alternatives that together were a complete solution, A and C would be correct. Hence, one should opt you alternative A and D where A is dynamic RLS and D is static RLS (credit to the individual(s) mentioning this prior to this comment).
Question 19 of 25
You are reviewing a Power BI data model. You have a calculated table that has the following definition. ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB ) You need to identify the results of the DAX expression. Which rows will be returned in ProductList?
Show answer
Correct answer: C
How others answered
C100%
Explanation
The INTERSECT function in DAX is order-independent. It returns the common rows between two tables, regardless of the order in which you specify the tables. both a and c are correct.
Adapted from community discussion by iamamantrivedi · 2024-03-11 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Permanent link to question 19 Report an issue
Candidate context
Question 19 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
I
INDEAVR
2024-02-28
Selected C13 upvotes
C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB
I
iamamantrivedi
2024-03-11
4 upvotes
The INTERSECT function in DAX is order-independent. It returns the common rows between two tables, regardless of the order in which you specify the tables. both a and c are correct.
S
Stehi
2024-02-28
3 upvotes
Would not A and C be both correct? ince INTERSECT finds rows that exist in both tables, the statement is correct from the perspective of either table—whether you're looking for matches in ProductsGroupA against ProductsGroupB or vice versa. The result is a table with rows that are common to both.
R
rajukg
2024-03-05
2 upvotes
Intersect is not commutative. In general, Intersect(T1, T2) will have a different result set than Intersect(T2, T1). Duplicate rows are retained. If a row appears in table_expression1 and table_expression2, it and all duplicates in table_expression_1 are included in the result set.
Question 20 of 25
DRAG DROP - You have a Microsoft Excel spreadsheet named Excel1 that contains survey results. You have a Power BI dashboard named DashboardA that has Q&A enabled. You need to ensure that users who can access DashboardA can ask questions based on the contents of Excel1 and pin visuals based on their queries to DashboardA. The solution must minimize development time. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Step 1: From powerbi.com, upload Excel1. Upload your Excel file to the Power BI service. The Power BI service connects to many data sources, including Excel files that live on your computer. 1. Sign in to the Power BI service. 2. In My workspace, select New > Upload a file. 3. Select Local File, browse to where you saved the Financial Sample Excel file, and select Open. 4. On the Local File page, select Import. Now you have a Financial Sample dataset. Power BI also automatically created a blank dashboard. If you don't see the dashboard, refresh your browser. Step 2: From powerbi.com, import Excel1 as a dataset. Step 3: From powerbi.com, add a tile for the Excel1 dataset to DashboarA. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-from-excel-to-stunning-report
Adapted from community discussion by RickyAnd · 2022-09-19 · 102 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 20 Report an issue
Candidate context
Question 20 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
R
RickyAnd
2022-09-19
102 upvotes
"The solution must minimize development time", so: 1. format the data as a table 2. Import as a dataset (upload involves scheduling updates, whereas with import it updates automatically) 3. add a tile for the dataset to dashbard
P
PinkZebra
2022-10-06
37 upvotes
1. From Power BI, Upload Excel 2. Format Table 3. Pin Instruction video from Microsoft Youtube Channel: https://www.youtube.com/watch?v=l8JoB7w0zJA
9
9f73003
2024-04-18
26 upvotes
This is incorrect, there is no option for XLSX files to create a tile in pbi service! 1- From Excel, Formet the data in Excel1 as a table 2- From powerbi.com, upload Excel1 3- From powerbi.com, pin a range from Excel1 to DashboardA https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel
M
MoxieTT
2023-05-23
14 upvotes
If you have a look at the free, 50-question paper on Microsoft's website and also their 4-part prep video series for PL-300 located in the "readiness zone", they allude to the Ctrl+T shortcut to convert to table, in order to avoid an error when ingesting an Excel file. Also, if you read the difference between Upload and Import here: (https://biuniversity.wordpress.com/2017/03/08/powerbi-upload-excel-import-excel-differences/), it becomes clear, upload is the correct choice. 1. Format as table 2. Upload as Excel file 3. Pin tiles to DashboardA
Question 21 of 25
You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?
Show answer
Correct answer: A
How others answered
A52%
C47%
Only 52% agreed on this answer — treat it as contested rather than settled.
Explanation
The correct answer is C. Option A, enabling report readers to personalize visuals, allows users to customize the look of visuals but does not provide the option to switch between different types of visuals. Option B, creating a separate report page for users to view the column chart, requires additional development effort and maintenance to maintain two separate pages with similar data. Option D, creating a mobile report that contains a column chart, is not necessary for the given scenario and may not provide an optimal experience for desktop users. Option C, adding a column chart, a bookmark, and a button for users to choose a visual, is the best solution to enable users to switch between different visualizations. This solution minimizes development and maintenance effort by using existing report elements and only requires the addition of a button and bookmark to toggle between visuals.
Adapted from community discussion by Loesf · 2023-02-15 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 21 Report an issue
Candidate context
Question 21 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
M
Manikom
2022-09-14
Selected A48 upvotes
Also C is correct but I guess the key is 'The solution must minimize development' so A should be the correct one
N
Newb007
2023-04-15
13 upvotes
I disagree question says "choose between viewing the report as a line chart or a column chart" C gives the user only those 2 options. I guess A does also... this question is tricky... but I think "Minimize dev work" is trying to steer you away from the B and D. I hate questions like these.
L
Loesf
2023-02-15
10 upvotes
The correct answer is C. Option A, enabling report readers to personalize visuals, allows users to customize the look of visuals but does not provide the option to switch between different types of visuals. Option B, creating a separate report page for users to view the column chart, requires additional development effort and maintenance to maintain two separate pages with similar data. Option D, creating a mobile report that contains a column chart, is not necessary for the given scenario and may not provide an optimal experience for desktop users. Option C, adding a column chart, a bookmark, and a button for users to choose a visual, is the best solution to enable users to switch between different visualizations. This solution minimizes development and maintenance effort by using existing report elements and only requires the addition of a button and bookmark to toggle between visuals.
P
PinkZebra
2022-10-06
7 upvotes
Agreed. https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals?tabs=powerbi-service#enable-personalization-in-a-report
Question 22 of 25
You have a Power BI report. You have a table named Data1 that contains 10 million rows. Data1 is used in the following visuals: ✑ A card that shows the number of records ✑ A bar chart that shows total transaction amount by territory ✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals. What should you do?
Show answer
Correct answer: C
How others answered
C78%
B21%
Explanation
This question requires "modification" of the scatter plot and what high-density sampling essentially does is to employ methods that capture and represent the underlying data more effectively and eliminates overlapping points. Remember that the table named Data1 contains 10 million rows. How do you represent all that data in a scatter plot in a meaningful pattern for easy understanding and analysis? by use of high density sampling. "By definition, high-density data is sampled to create visualizations reasonably quickly that are responsive to interactivity. Too many data points on a visual can bog it down, and can detract from the visibility of trends". This link explains it more: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-high-density-scatter-charts#how-high-density-scatter-charts-work
Adapted from community discussion by shakes103 · 2022-11-11 · 47 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 22 Report an issue
Candidate context
Question 22 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
S
shakes103
2022-11-11
Selected C47 upvotes
This question requires "modification" of the scatter plot and what high-density sampling essentially does is to employ methods that capture and represent the underlying data more effectively and eliminates overlapping points. Remember that the table named Data1 contains 10 million rows. How do you represent all that data in a scatter plot in a meaningful pattern for easy understanding and analysis? by use of high density sampling. "By definition, high-density data is sampled to create visualizations reasonably quickly that are responsive to interactivity. Too many data points on a visual can bog it down, and can detract from the visibility of trends". This link explains it more: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-high-density-scatter-charts#how-high-density-scatter-charts-work
C
Clodia
2022-10-20
Selected C11 upvotes
The correct answer should be C - Enable high-density sampling on the scatter plot. Trend line is only available if the X axis is time and type is "Continuous", in this case the option is not available.
K
KobeData
2022-11-04
Selected C6 upvotes
When using the High Density Sampling algorithm for scatter charts, accurate distribution of the data is the goal, and implied visual density is not the goal. For example, you might see a scatter chart with lots of circles that overlap (density) in a certain area, and imagine many data points must be clustered there; since the High Density Sampling algorithm can use one circle to represent many data points, such implied visual density (or "clustering") will not show up. To get more detail in a given area, you can use slicers to zoom in. Would go with C on this one, B would be to spot a trend. C would be accurate since it makes users more likely to spot patterns.
M
Mobita3000
2023-03-03
3 upvotes
The correct solution to modify the scatter plot to make it easier for users to identify meaningful patterns without affecting the accuracy of the other visuals would be to enable high-density sampling on the scatter plot. Therefore, the correct answer is C. Enabling high-density sampling allows you to plot a representative subset of the data in the scatter plot without losing significant information. This will help reduce the clutter in the scatter plot caused by a large amount of data and make it easier for users to identify patterns and trends. Adding a count field of the transaction amount to the size bucket of the scatter plot (option A) would make the scatter plot more informative but may also add more clutter to the plot, making it harder to identify patterns. Adding a trend line to the scatter plot (option B) would show the overall trend in the data, but it may not be useful in identifying patterns across different territories. Applying a row filter to the Data1 query in Power Query Editor (option D) would reduce the number of rows in the dataset but would also affect the accuracy of all the visuals using the Data1 table, including the card and bar chart. Therefore, it's not a recommended solution.
Question 23 of 25
You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do?
Show answer
Correct answer: A
How others answered
A97%
Explanation
To enable the finance team to use Microsoft Excel to analyze the Finance dataset, you need to provide them with an Excel workbook that is connected to the dataset. This can be done by installing the Power BI publisher for Excel add-in, connecting to the Finance dataset, and then importing the data into Excel. Once the data is in Excel, the finance team can use all of Excel's analytical capabilities to analyze and visualize the data. Granting build permissions (A) or write permissions (D) to the Finance dataset would allow the finance team to modify the dataset, which is not necessary for their analysis needs. Creating a row-level security (RLS) role and adding the finance team as members (C) would only be necessary if you needed to restrict access to specific rows of data in the Finance dataset based on user roles or permissions.
Adapted from community discussion by sa56 · 2023-04-04 · 23 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 23 Report an issue
Candidate context
Question 23 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
M
Maverick7513
2023-04-24
Selected A26 upvotes
you have to have at least build permissions on the dataset https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel
S
sa56
2023-04-04
23 upvotes
To enable the finance team to use Microsoft Excel to analyze the Finance dataset, you need to provide them with an Excel workbook that is connected to the dataset. This can be done by installing the Power BI publisher for Excel add-in, connecting to the Finance dataset, and then importing the data into Excel. Once the data is in Excel, the finance team can use all of Excel's analytical capabilities to analyze and visualize the data. Granting build permissions (A) or write permissions (D) to the Finance dataset would allow the finance team to modify the dataset, which is not necessary for their analysis needs. Creating a row-level security (RLS) role and adding the finance team as members (C) would only be necessary if you needed to restrict access to specific rows of data in the Finance dataset based on user roles or permissions.
S
Shalaleh
2023-04-27
4 upvotes
The finance team would need to be a member of the Power BI workspace containing the Finance dataset in order to access the dataset from Excel. The question mentions that the finance team is not currently a member of any Power BI workspace roles, which means they do not have any access to the workspace or the datasets within it. However, it's important to note that in order to connect to the dataset from Excel, the user must also have the appropriate permissions to the dataset itself. This can be achieved either by being a member of a workspace role with appropriate permissions to the dataset or having Build permissions to the dataset directly. So, to summarize, the finance team needs to be a member of the Power BI workspace containing the Finance dataset and have appropriate permissions to the dataset itself in order to connect to it from Excel
J
jaume
2024-11-22
Selected A1 upvote
In the URL shared by Maverick7513 is perfectly explained. Several prerequisites to connect PBI Semntic Models (former dataset) to excel: live connection tenant setting must be enabled, SMLA endpoints and Analyze in Excel with on-premises datasets tenant setting to be enabled…... …but the most important prerequisite for this scenario is "you must have Build permission to the PBI Semantic model ot have at least Contributor role in PBI workspace containing te Semantic Model. It has some sense a workspace has limited access, the dataset has also some security settings… you cannot bypass all these restrictions just by sharing an excel workbook connected to the dataset, it would be a back door to your data model
Question 24 of 25
HOTSPOT - You have a dataset that has the permissions shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: use Analyze in Excel - Build permission applies to datasets. When you give users Build permission, they can build new content on your dataset, such as reports, dashboards, pinned tiles from Q&A, paginated reports, and Insights Discovery. Users also need Build permissions to work with the data outside Power BI: To export the underlying data. To build new content on the dataset such as with Analyze in Excel. To access the data via the XMLA endpoint. Box 2: grant the Read permission for The Corp group has read, share and rebuild permissions. As a property of the Power BI App, you can allow users to share the app and underlying dataset with share permissions. Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions https://data-marc.com/2021/07/30/transform-a-local-into-a-global-power-bi-solution-request-access-to-content/
Adapted from community discussion by fred92 · 2022-10-24 · 73 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 24 Report an issue
Candidate context
Question 24 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
F
fred92
2022-10-24
73 upvotes
- Analyze in Excel - Grant build permission see: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions "Say you have Reshare and Build permission on a dataset. When you share a report or dashboard built on that dataset, you can specify that the recipients also get Build permission for the underlying dataset."
H
Hongzu13
2022-11-04
14 upvotes
I took this from Ms documentation: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions "Ways to give Build permission": (...) Say you have Reshare and Build permission on a dataset. When you share a report or dashboard built on that dataset, you can specify that the recipients also get Build permission for the underlying dataset. So the answer is: - Analyze in Excel - Grant build permission
W
Wadyba
2022-12-21
6 upvotes
Users with read permission can not grant Build access, so the answer is Read permission.
S
steladoynova
2022-10-23
4 upvotes
Answer is Correct. "Users can create Sensitivity labels in the Microsoft 365 compliance center. Access to this feature in the Microsoft 365 compliance center is available for admins of the Microsoft 365 of your organization." So first is not sensitivity labels, and is not delete. "Dataset owners can assign Build permission to specific users or security groups on the Manage permissions page. See Manage dataset access permissions for detail." So secons is not Build.
Question 25 of 25
You need to create the dataset. Which dataset mode should you use?
Show answer
Correct answer: C
How others answered
C51%
A49%
Only 51% agreed on this answer — treat it as contested rather than settled.
Explanation
Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly. In this case, Composite fits perfect. Source1 is 2GB, which is relatively too large for daily updates and way larger than Source2 which is only 5MB.
Adapted from community discussion by shakes103 · 2022-11-13 · 26 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 25 Report an issue
Candidate context
Question 25 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by PL-300 or CertExamHQ.
S
shakes103
2022-11-13
Selected C26 upvotes
Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly. In this case, Composite fits perfect. Source1 is 2GB, which is relatively too large for daily updates and way larger than Source2 which is only 5MB.
G
glenman0202
2023-04-19
Selected C12 upvotes
C is the right answer. This is both because of what others have mentioned (Source1 is 2GB and Source2is only 5MB) and because of this one sentence: "The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements." Ergo, we know by default that A cannot be the correct answer, as Importing a 2GB file makes the dataset much larger than just using DirectQuery. However, we cannot just use pure DirectQuery, because of the following requirement: "The reports must provide fast response times when users interact with a visualization." Visualizations would be extremely slow if we were forced to query the 2GB file every time we wanted to interact with a visual that uses Source2. As such, we are forced to use a composite model: It allows both DirectQuery for the larger SQL database, while enabling import for the smaller Excel spreadsheet. Additionally, data caching may be used to speed up interactions with the SQL database.
Y
YokoSumiGaeshi
2022-11-25
10 upvotes
Another key sentence is "The reports must provide fast response times when users interact with a visualization." Using DirectQuery increases the latency when interacting with a viz, because the data needs to be fetched from the source at every refresh, an issue which doesn't exist when the data is imported. A is correct.
P
powerbibuddy
2022-11-19
9 upvotes
Capacity for import is 1 GB, so How can we use Import for 2GB data

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

About this question bank

Community-contributed

Compiled from exam discussions posted publicly by other people on ExamTopics. Copyright in each contribution rests with its original author; it is reproduced here for study. Not verified by us — most items carry no explanation. To request removal, see our content policy.

Compiled from ExamTopics community discussions

Compiled from publicly posted community exam discussions. Contributed by third parties rather than written here, so accuracy varies and most items carry no explanation.

Across the private full bank: 297 explanations, 357 questions with candidate context and 130 questions with direct citations.

Version 1.0.0 · bank updated 2026-08-29. How we source questions