PL-300 — Most Debated Topics

Community-voted ranking of 52 topics, sorted by disagreement level. Higher dispute = more test-takers disagree on the answer.

#1
PREVIOUSYEAR returns the full previous year, not the same day of last year
S-Grade Dispute: 62% 7 comments
#2
Northwind Traders semantic model: choosing Import storage mode for the Power BI tables
S-Grade Dispute: 50% 20 comments
#3
Shrinking a Power BI model for monthly transaction totals with a star schema
S-Grade Dispute: 50% 5 comments
#4
Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector
S-Grade Dispute: 49% 41 comments
#5
Push mode for real-time streaming without refreshing or stressing the data source
S-Grade Dispute: 48% 15 comments
#6
Adding an index key and normalizing casing to resolve DirectQuery undefined values
S-Grade Dispute: 45% 15 comments
#7
Monthly semantic model refresh requires Power Automate, not scheduled refresh
S-Grade Dispute: 44% 5 comments
#8
Why model-level aggregations do not reduce gateway traffic for Import mode
S-Grade Dispute: 39% 10 comments
#9
Assigning an RLS role to a Mail-enabled group rather than a Microsoft 365 group
S-Grade Dispute: 38% 20 comments
#10
Configuring tab order for keyboard and screen reader navigation on a report page
S-Grade Dispute: 38% 8 comments
#11
Color-vision-friendly themes: adjusting divergent and sentiment color palettes
S-Grade Dispute: 38% 6 comments
#12
Two report elements that let users filter sales to a single selected region
S-Grade Dispute: 37% 17 comments
#13
Two cloud connectors that refresh a OneDrive-hosted Excel file without a gateway
S-Grade Dispute: 36% 12 comments
#14
Speeding up refresh of referenced Power Query queries by moving Query1 to a dataflow
S-Grade Dispute: 33% 15 comments
#15
Building a rolling 31-day sales total with DATESBETWEEN in DAX
S-Grade Dispute: 32% 12 comments
#16
Publishing an app scopes visibility to RPT1, RPT2, and DB1 while hiding RPT3
A-Grade Dispute: 25% 4 comments
#17
Handling role-playing dates in Power BI with one renamed and two calculated date tables
S-Grade Dispute: 22% 8 comments
#18
Hyperlink the website name column via conditional formatting on a web URL
A-Grade Dispute: 22% 3 comments
#19
Fixing undefined values in a DirectQuery model by normalizing casing in the source query
S-Grade Dispute: 21% 11 comments
#20
Dashboard tile cache frequency has no bearing on gateway data transfer
A-Grade Dispute: 20% 3 comments
#21
A 100% stacked area chart shows quarterly sales mix without extra DAX measures
A-Grade Dispute: 20% 4 comments
#22
Automatic page refresh cannot cut gateway traffic for Import-mode models
S-Grade Dispute: 17% 5 comments
#23
Security groups and Microsoft 365 groups are the shareable group types
A-Grade Dispute: 17% 3 comments
#24
Minimizing effort when reducing a Power Query Date column to just the year
S-Grade Dispute: 16% 8 comments
#25
Data bars for one-click visual comparison with values hidden in a table column
S-Grade Dispute: 12% 10 comments
#26
Averaging item price per country while preserving report filters with a quick measure
S-Grade Dispute: 10% 11 comments
#27
Three ways to repoint a PBIX file to a moved Excel data source
A-Grade Dispute: 0% 14 comments
#28
Implicit type conversion cannot fix case-sensitivity errors in DirectQuery
A-Grade Dispute: 0% 6 comments
#29
Switching the semantic model mode does not resolve case-sensitivity undefined values
A-Grade Dispute: 0% 4 comments
#30
PBIDS files simplify reconnecting another user to the same data source
A-Grade Dispute: 0% 3 comments
#31
Two-minute data freshness from Azure SQL requires DirectQuery connectivity
A-Grade Dispute: 0% 4 comments
#32
Reducing loaded data in Power Query with grouping and column removal
A-Grade Dispute: 0% 5 comments
#33
Incremental refresh reduces gateway traffic by refreshing only new partitions
A-Grade Dispute: 0% 6 comments
#34
INTERSECT returns rows of its first table that appear in the second
A-Grade Dispute: 0% 8 comments
#35
Placing measures in the Values well to build the required matrix visual
A-Grade Dispute: 0% 13 comments
#36
USERELATIONSHIP measures over inactive relationships support all three date roles
A-Grade Dispute: 0% 5 comments
#37
Averaging Sales department salaries with CALCULATE and a department filter
A-Grade Dispute: 0% 8 comments
#38
Replacing null freight amounts with zero to keep per-order averages correct
A-Grade Dispute: 0% 9 comments
#39
Performance analyzer durations: DAX query and visual display metrics
A-Grade Dispute: 0% 4 comments
#40
Only the VNet-hosted Azure SQL database needs an on-premises data gateway
A-Grade Dispute: 0% 4 comments
#41
Paginated reports deliver print-optimized, multi-format quarterly reviews
A-Grade Dispute: 0% 8 comments
#42
Repositioning report visuals by editing their position (X and Y coordinates)
A-Grade Dispute: 0% 13 comments
#43
Unpivoting a wide month-year grid into month, year, and amount columns
A-Grade Dispute: 0% 9 comments
#44
Comparing five regions' monthly sales with a stacked bar chart
A-Grade Dispute: 0% 5 comments
#45
Accessible quota status: shape-differentiated icons for color-deficient users
A-Grade Dispute: 0% 5 comments
#46
Personalize visuals lets each user change a visual type without affecting others
A-Grade Dispute: 0% 6 comments
#47
Dynamic alt text from a DAX measure keeps the card readable by screen readers
A-Grade Dispute: 0% 4 comments
#48
Icons add a color-independent sales status cue for color-deficient users
A-Grade Dispute: 0% 5 comments
#49
Updating the app publishes the new report page to its audience
A-Grade Dispute: 0% 3 comments
#50
Alt text gives screen readers a summary of the bar chart's data
A-Grade Dispute: 0% 3 comments
#51
An on-premises data gateway keeps SSAS tabular data live in the Power BI service
A-Grade Dispute: 0% 3 comments
#52
Member role balances invite rights with least privilege for the Sales group
A-Grade Dispute: 0% 3 comments

Ready to practice?

Access 116 PL-300 questions with instant feedback and detailed explanations.

View PL-300 Practice Questions →

← Back to PL-300 Microsoft Power BI Data Analyst Study Guide