Power BI prompts
Power BI reports are only useful if they answer a clear question. These prompts help you define metrics, plan data models and visuals, write DAX measures with explanations, design dashboards for an audience and review a report for clarity. Describe your tables and measures to an AI assistant, with sample data anonymised, and ask for DAX or a layout plan. The prompts do not connect to your dataset, so validate every measure against known numbers and check access and sharing settings.
Prompts
-
Power BI Data Model Review for Performance and Correctness
Check relationships, column choices and cardinality.
-
Power BI Measure and DAX Review for Wrong Totals
Find why numbers differ from the source or between visuals.
-
Power BI Report Design and Accessibility Review
Check clarity, consistency and access for all users.
-
Power BI Workspace, Sharing and Data Governance Review (Defensive)
Check who can see datasets and reports and how they are certified.
-
Power BI Refresh Failure and Data Freshness Audit
Look at refresh history and find causes and patterns.
-
Power BI Report Numbers Reconciliation Against Source Systems
Prove that the report agrees with finance or operations.
-
Report Performance and Clutter Audit
Find slow visuals, too many fields and confusing pages.
-
Power BI Dashboard Decision Usefulness and Usage Audit
Check what people actually use.
-
Power BI Dataset Duplication and Certified Source Audit
Find competing versions of the same data.
-
Power BI Row-Level Security Rules Review (Defensive)
Review the row-level security roles on your own Power BI model for gaps, overlaps and test coverage, with a checklist for safe validation.
-
Power BI Date Table and Time Intelligence Check
Check a Power BI model's date table, relationships and year-to-date style measures for gaps and wrong comparisons, with test cases to verify.
-
Power BI Naming Conventions and Field Folder Audit
Review table, column and measure names in a Power BI model for clarity, consistency and hidden clutter, then set a naming standard.
-
Power BI Slicer and Filter Interaction Audit
Check how slicers, page filters and visual interactions in a Power BI report change numbers, to find confusing or misleading filter behaviour.
-
Power BI Gateway and Data Source Credential Hygiene Audit
Review data sources, gateway use and stored credentials behind your Power BI reports for ownership gaps and risk. Defensive review of your own setup.
-
Power BI Calculated Column Versus Measure Usage Audit
Examine calculated columns and measures in your Power BI model to find misplaced logic that bloats size or gives wrong totals, with a move plan.
-
Power BI Report Handover and Documentation Audit
Check that a Power BI report has the owner, sources, definitions and refresh notes a successor needs, and create a one-page documentation template.
-
Power BI Visual Choice and Misleading Chart Audit
Review the charts on a Power BI page for misleading scales, poor chart types and clutter, and suggest clearer visuals matched to each question.
-
Power BI Relationship Cardinality and Ambiguity Check
Examine the table relationships in a Power BI model for wrong cardinality, many-to-many risks and ambiguous paths that inflate or hide totals.
-
Power Query Transformation Steps Audit for Data Quality
Review the Power Query steps behind a Power BI dataset for risky type changes, silent row loss and hard-coded values, with a verification plan.
-
Power BI Star Schema Data Model Plan From Source Tables
Plan fact and dimension tables and relationships before building a report.
-
Power BI DAX Measure Library With Plain-Language Definitions
Write core measures with definitions and checks.
-
Power BI Report Page Layout and Visual Selection Brief
Design a page that answers one question clearly.
-
Power BI Row-Level Security Design Plan
Plan who sees which rows and how to test it.
-
Power BI Refresh Schedule and Gateway Planning Notes
Plan data refresh, ownership and failure handling.
-
Power BI Power Query Transformation Steps for a Messy Source
Plan clean-up steps that can be refreshed.
-
Power BI KPI Card Definitions and Target Logic
Define each headline number so everyone reads it the same way.
-
Power BI Report Narrative and Insight Summary for Executives
Write the story that goes with a dashboard.
-
Power BI Migration Plan From Excel Reports
Move recurring Excel reports into a managed Power BI report.
-
Power BI Date Table and Time Intelligence Walkthrough
Build a calendar and use it for year-to-date and comparisons.
-
Power BI Row Count and Totals Reconciliation Pack for Every Refresh
Build checks into the report.
-
Power BI Report Handover Documentation Template
Document a report so others can maintain it.
-
Power BI Question-Driven Dashboard Refresh for a Finance Team
Redesign a dashboard around decisions.
No prompts match those filters.