DP-500
Microsoft Certified: Power BI Data Analyst Associate (DP-500)
More study resources
Cheat sheet
Keep the key ideas within reach.
ExploreKey terms
Get comfortable with the vocabulary.
ExploreStudy plan
Give each week a clear focus.
ExploreCommon mistakes
Understand the traps and how to avoid them.
ExploreCase studies
Put your knowledge to work in context.
ExploreExam-day guide
Prepare for the day ahead.
ExploreAbout this exam
DP-500, now titled Microsoft Certified: Power BI Data Analyst Associate (historically Azure Enterprise Data Analyst Associate), is a certification for analysts and BI developers who build and govern analytics at organizational scale rather than single-report authors. It targets people comfortable with Power BI Desktop, DAX, and either T-SQL or a lakehouse/warehouse engine, who now need to design shared semantic models, secure and govern data, and tune performance. The exam spans five weighted domains: enterprise-scale analytics solution design (25%), governance and security (20%), enterprise data models (20%), Power BI implementation (20%), and monitoring and optimization (15%). Expect multiple choice, multiple response, drag-and-drop, case studies, and lab-style tasks where you configure something rather than recall a definition. Preparation works best in layers: solidify DAX evaluation context and model relationships; practice deployment pipelines, workspace roles, row-level security, and sensitivity labels in a tenant you can administer; then work through performance tuning with DAX Studio, query diagnostics, and aggregate tables. Microsoft publishes the current skills outline, scheduling logistics, fees, and scoring details on its official certification page; confirm those figures there, as they change. This page is independent study material and is not affiliated with or endorsed by Microsoft.
What you'll study
About DP-500 preparation
What is the current exam format?
Microsoft lists the format, item types, and delivery options on the official exam page. Candidates commonly report a mix of multiple choice, multiple response, drag-and-drop, case studies with shared scenario context, and lab-style configuration tasks. Confirm the current structure on Microsoft's site before scheduling, since item types evolve.
How long is the exam and how many questions are there?
Microsoft publishes the current duration and question count on its official certification and exam pages; those details are revised periodically, so check there rather than relying on secondhand reports. Practically, budget time for case studies, which consume more reading time than standalone items, and flag uncertain lab steps for review if the platform allows it.
What score do I need to pass, and what does it cost?
Passing scores and exam fees are set and published by Microsoft on the official exam page; they vary by country and currency and are updated over time. This independent page does not state them. Check Microsoft's site for the current fee in your region and the score report explanation before you book.
If I fail, can I retake it, and how soon?
Microsoft defines retake eligibility and waiting periods in its certification policy, including limits on attempts and any required waiting interval after a failed attempt. The exact rules are published on Microsoft's site and can change. Review your score report by domain first, since it shows where to focus before rebooking.
How difficult is DP-500 compared with PL-300?
DP-500 assumes PL-300-level report and model skills and adds architecture: shared semantic models, deployment pipelines, governance, and performance tuning. Candidates with only report-authoring experience typically find the security, pipeline, and optimization content hardest. Expect to practice in a tenant where you can assign workspace roles and apply labels.
What study order do you recommend?
Start with DAX evaluation context, star schema design, and relationship cardinality. Then move to workspace roles, row-level security, sensitivity labels, and deployment pipelines in a live tenant. Finish with monitoring and tuning: DAX Studio, query diagnostics, aggregations, and gateway or capacity considerations. Case studies reward this order because they combine modeling and governance.
Which tools should I be hands-on with?
Power BI Desktop and the Power BI service are essential. Add DAX Studio and Tabular Editor for model inspection and calculation work, and either Azure Synapse, Databricks, or SQL Server for the data-engineering side. Know how to read a query plan, run query diagnostics, and interpret a capacity metrics app report rather than just recognizing the names.
What are the most common failure modes?
Candidates lose points by confusing row-level security with object-level permissions, misreading case-study requirements, and guessing at pipeline stage behavior instead of practicing it. Another frequent gap is tuning: knowing that aggregations exist but not when the engine hits them. Read each case study's constraints twice and eliminate options that violate stated governance rules.
Does the certification expire, and how do I renew?
Microsoft publishes certification validity and renewal rules on its official certification pages, including free online renewal assessments for many role-based credentials. The specific policy and renewal window are set by Microsoft and may change, so confirm the current terms on its site before your anniversary date.
Do I need production admin access to prepare?
No, but a trial or sandbox tenant helps enormously. You need enough rights to create workspaces, assign roles, publish semantic models, and apply sensitivity labels. Many governance features cannot be learned from reading alone, so arrange a development environment where you can safely test row-level security and deployment pipeline promotion.