Episodes

  • [PL-300] 39, Creating Reports and Narratives with Copilot

    [PL-300] 39, Creating Reports and Narratives with Copilot
    Oct 8 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - Prerequisites for using Copilot in Power BI including Fabric F64 or Premium capacity requirements and tenant settings. - How Copilot generates report pages and dynamic narrative visuals based on semantic model metadata. - Techniques for validating Copilot narrative output against underlying DAX measures and model figures. - How to fix inaccurate AI outputs by optimizing semantic models, adding synonyms, and defining explicit DAX measures. - How Copilot strictly enforces Row-Level Security and Object-Level Security permissions in Power BI reports. For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    4 mins
  • [PL-300] 38, Configuring Report Pages and Refresh Behavior

    [PL-300] 38, Configuring Report Pages and Refresh Behavior
    Oct 7 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - Setting page size to Tooltip creates lightweight overlay canvases for hover cards and drillthrough targets. - Hiding a report page removes tab navigation but does not restrict security or data access for users. - Automatic Page Refresh (APR) requires DirectQuery or Live Connection and is not supported on Import mode datasets. - Remember the mnemonic: Import stays asleep, DirectQuery ticks the clock for real-time automatic page refresh. - Capacity minimum refresh intervals configured by tenant admins can override and throttle user-defined APR frequencies. For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    4 mins
  • [PL-300] 37, Slicers, Filters, and Filter Scope

    [PL-300] 37, Slicers, Filters, and Filter Scope
    Oct 6 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - How visual-level, page-level, and report-level filters differ in scope and evaluation hierarchy - Configuring Sync Slicers to propagate filter selections across report pages without requiring visual display - Adjusting Edit Interactions to switch visual behaviors between filtering, highlighting, and none - Setting up Top N and relative date filters in the Filter pane including required field placements - Troubleshooting unexpected filter behavior caused by visual interactions, locked filters, or DAX measure overrides For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    4 mins
  • [PL-300] 36, Themes and Conditional Formatting

    [PL-300] 36, Themes and Conditional Formatting
    Oct 5 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - How report themes establish global design consistency across Power BI reports using built-in presets and custom JSON files. - How to apply gradient, rule-based, and field-value conditional formatting to background colors, font colors, icons, and data bars. - How to avoid the common exam trap of confusing percentage vs number settings in rule-based conditional formatting. - How to use DAX measures returning hex color codes paired with field value conditional formatting for dynamic visual logic. - How to distinguish report-level theme architecture from measure-driven conditional emphasis on the PL-300 exam. For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    4 mins
  • [PL-300] 35, Formatting and Configuring Visuals

    [PL-300] 35, Formatting and Configuring Visuals
    Oct 4 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - How implicit field aggregations differ from explicit DAX measures in visual configurations - Techniques for optimizing axis limits, legend visibility, and layout readability to prevent clutter - How to use small multiples for synchronized side-by-side categorical comparisons - Adding dynamic Analytics pane reference lines such as constant and average benchmarks - Configuring matrix totals and applying measure-driven conditional formatting and dynamic titles For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    4 mins
  • [PL-300] 34, Choosing the Right Power BI Visual

    [PL-300] 34, Choosing the Right Power BI Visual
    Oct 3 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - How to match core business requirements like trends, correlation, composition, and distribution to specific Power BI visuals for the PL-300 exam. - The distinction between line charts for continuous time series, bar charts for discrete categories, and scatter charts for numerical correlation. - Best practices for part-to-whole analysis, including category limits on pie charts, benefits of treemaps, and when to choose stacked bar charts. - Key exam scenarios for specialized visuals including Decomposition Trees, KPI visuals, Gauges, Matrices, and Geographic maps. - Major exam traps regarding custom visuals, misleading chart choices, and selecting built-in options to fulfill requirements efficiently. For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    4 mins
  • [PL-300] 33, Optimizing Model and DAX Performance

    [PL-300] 33, Optimizing Model and DAX Performance
    Oct 2 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - How removing unnecessary rows and columns improves VertiPaq columnar compression in PL-300 - Techniques for reducing granularity and high cardinality, such as splitting datetime columns - Why star schemas with single-direction relationships perform best on the exam compared to bi-directional options - How to use Performance Analyzer to isolate bottlenecks between DAX query, Visual display, and Other metrics - Methods for diagnosing and rewriting slow measures using DAX Query View to eliminate costly iterators For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    3 mins
  • [PL-300] 32, Semi-Additive Measures, Quick Measures, and Calculation Groups

    [PL-300] 32, Semi-Additive Measures, Quick Measures, and Calculation Groups
    Oct 1 2026
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams. In this episode you will learn: - How semi-additive measures aggregate across spatial dimensions but require last-nonblank patterns over time. - How to apply LASTNONBLANKVALUE logic to prevent incorrect summing of inventory or account balances. - The operational limits of quick measures and when explicit DAX measures are required for complex logic. - How calculation groups use the SELECTEDMEASURE function to apply dynamic logic across multiple metrics. - Criteria for choosing between reusable calculation groups and standalone explicit measures in Power BI models. For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    Show More Show Less
    3 mins