Disagreement ranking

PL-300 — most debated topics

Community-voted ranking of 66 topics, sorted by disagreement level. A higher dispute score means more test-takers disagree on the answer.

Full ranking

66 topics · highest disagreement first

  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

  53. Supporting Analysis with Multiple Date Foreign Keys in Power BI

    A-grade Dispute: 0% 64 comments

  54. Power BI Dynamic Customer Segments Visualization

    A-grade Dispute: 0% 43 comments

  55. Power BI Semantic Model Permissions: Analyze in Excel and Build Rights

    A-grade Dispute: 0% 9 comments

  56. Which Connector for a Teams Power Apps Project Report?

    A-grade Dispute: 0% 48 comments

  57. Reuse an Existing Power BI Dataset to Build a New Report?

    S-grade Dispute: 0% 117 comments

  58. Counting Product Categories Sold Using DAX CALCULATE

    A-grade Dispute: 0% 71 comments

  59. Which three actions create monthly star-schema totals with minimal model size?

    S-grade Dispute: 0% 11 comments

  60. Which Components Can You Add to a Live-Connection Power BI Report?

    A-grade Dispute: 0% 3 comments

  61. Does Removing the Salesperson Table Meet Model1's Size Goal?

    A-grade Dispute: 0% 4 comments

  62. Does Removing ProductID Shrink the Model Yet Keep City Analysis?

    A-grade Dispute: 0% 1 comments

  63. Connectors for OneDrive Excel Refresh in Power BI

    S-grade Dispute: 0% 118 comments

  64. Power Query Column Profiling for Text Length Analysis

    S-grade Dispute: 0% 9 comments

  65. Configure Row-Level Security Sequence PL-300

    S-grade Dispute: 0% 11 comments

  66. Merge Customer and Contacts with fuzzy matching in Power BI

    A-grade Dispute: 0% 1 comments

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