%3CLINGO-SUB%20id%3D%22lingo-sub-1505391%22%20slang%3D%22en-US%22%3ECustomer%20Offerings%3A%20Power%20BI%20Assessment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505391%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1197020500%22%20id%3D%22toc-hId-1197020500%22%3E%3CSTRONG%3EIntroduction%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20this%20series%20of%20articles%2C%20we%20will%20present%20Premier%20Services%20Offerings%26nbsp%3Baround%20Power%20BI.%20In%20this%20one%20we%20will%20present%20the%20%3CSTRONG%3EPower%20BI%20Assessment%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorRomain%20Casteres_9%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PowerBI_Assessment.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203590iA2D666BA62590385%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PowerBI_Assessment.png%22%20alt%3D%22PowerBI_Assessment.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20sure%20that%20your%20Power%20BI%20tenant%20follows%20Microsoft%20Best%20Practices%3F%20Are%20you%20noticing%20performance%20problems%20within%20your%20Premium%20dedicated%20capacity%3F%20Do%20you%20know%20how%20many%20users%20are%20consuming%20your%20reports%3F%20The%20Premier%20Services%20Offerings%20Power%20BI%20Assessment%20can%20answer%20these%20questions%20and%20more.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--610433963%22%20id%3D%22toc-hId--610433963%22%3E%3CSTRONG%3EPower%20BI%20Assessment%20overview%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20BI%20Assessment%20is%20a%20proactive%20service%20delivered%20by%20a%20Microsoft%20accredited%20engineer%20to%20diagnose%20potential%20issues%20with%20your%20Power%20BI%20environment.%20Assessment%20is%20supported%20on%20both%20the%20Power%20BI%20Service%20(cloud)%20and%20Power%20BI%20Report%20Server%20(on%20premises)%20Engineer%20will%20provide%20valuable%20guidance%20on%20recommended%20practices%20to%20improve%20the%20health%20of%20your%20Power%20BI%20environment.%20At%20the%20end%20of%20this%20engagement%2C%20you%20will%20receive%20a%20comprehensive%20Power%20BI%20report%20with%20results%20of%20the%20assessment%2C%20a%20detailed%20best%20practice%20guidance%20deck%20and%20a%20summary%20report%20tailored%20to%20your%20environment.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PowerBIAssessment_Outcomes.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203581i1715519B1915E222%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PowerBIAssessment_Outcomes.png%22%20alt%3D%22PowerBIAssessment_Outcomes.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PowerBIAssessmentAgenda.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203589iDB2A709BD6CC9943%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PowerBIAssessmentAgenda.png%22%20alt%3D%22PowerBIAssessmentAgenda.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CU%3EThe%20deliverables%20include%3A%3C%2FU%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EComprehensive%20Power%20BI%20report%20with%20results%20of%20the%20assessment.%3C%2FLI%3E%0A%3CLI%3EPower%20BI%20best%20practice%20guidance%20slide%20deck%3C%2FLI%3E%0A%3CLI%3EExecutive%20Summary%20report%3C%2FLI%3E%0A%3CLI%3EKnowledge%20transfer%20on%20Power%20BI%20recommended%20best%20practices%3C%2FLI%3E%0A%3CLI%3ERemediation%20planning%20guidance%3C%2FLI%3E%0A%3CLI%3EData%20collection%20scripts%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CEM%3ENote%20that%2C%20the%20assessment%20will%20be%20even%20more%20valuable%20if%20you%20have%20Power%20BI%20Premium...%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3ESome%20Key%20Focus%20Areas%3A%20%3C%2FU%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EPremium%20Capacity%20Metrics%20App%3C%2FLI%3E%0A%3CLI%3EPower%20BI%20Activity%20log%3C%2FLI%3E%0A%3CLI%3EPower%20BI%20Admin%20APIs%20%E2%80%93%20Workspaces%2C%20Reports%2C%20Datasets%2C%20Dashboards%2C%20Embed%20Codes%20and%20more.%3C%2FLI%3E%0A%3CLI%3EPower%20BI%20Tenant%20settings%3C%2FLI%3E%0A%3CLI%3ESecurity%20and%20Governance%3C%2FLI%3E%0A%3CLI%3EPower%20BI%20Report%20Server%20%E2%80%93%20execution%20logs%2C%20catalog%20database%2C%20performance%20counters%20and%20more.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3EScreenshot%20of%20some%20of%20the%20pages%20from%20a%20sample%20output%20repot%20below%3A%3C%2FU%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorRomain%20Casteres_12%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PBIAssessment4.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203584i399B5AEAE4AF4AEA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBIAssessment4.png%22%20alt%3D%22PBIAssessment4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PBIAssessment1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203583i9EE30B7B9E0DD07C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBIAssessment1.png%22%20alt%3D%22PBIAssessment1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PBIAssessment2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203586iC37E2D59B809FF8A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBIAssessment2.png%22%20alt%3D%22PBIAssessment2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PBIAssessment3.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203585i59721D4841C4C495%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBIAssessment3.png%22%20alt%3D%22PBIAssessment3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThis%20service%20has%20already%20been%20delivered%20many%20times%20across%20the%20globe%20and%20received%20positive%20feedback.%20We%20continuously%20improve%20the%20content%20based%20on%20customer%20and%20engineer%20feedback.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PowerBIAssessment_Stats.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203587iDCDAD78E345AECA6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PowerBIAssessment_Stats.png%22%20alt%3D%22PowerBIAssessment_Stats.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1877078870%22%20id%3D%22toc-hId-1877078870%22%3E%3CSTRONG%3ERoad%20Map%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20of%20the%20planned%20improvements%20in%20upcoming%20releases%20listed%20below%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ECollection%20of%20additional%20Premium%20capacity%20metrics%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EInclude%20data%20collection%20and%20metrics%20for%20Dataflows%3C%2FLI%3E%0A%3CLI%3EInclude%20data%20collection%20and%20metrics%20for%20all%20Gateways%20in%20the%20tenant%3C%2FLI%3E%0A%3CLI%3EOther%20general%20improvements%20in%20data%20collection%20and%20reporting%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-69624407%22%20id%3D%22toc-hId-69624407%22%3E%3CSTRONG%3EFollow%20up%20and%20feedback%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20further%20information%2C%20please%20contact%20your%20Microsoft%20Account%20Representative%2C%20Technical%20Account%20Manager%20(TAM)%20or%20Service%20Delivery%20Manager%20(SDM).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20improve%20our%20workshop%2C%20we%20always%20consider%20feedback%20from%20you.%20At%20Microsoft%2C%20achieving%20a%20high%20level%20of%20satisfaction%20among%20our%20customers%20and%20partners%20around%20the%20world%20is%20a%20core%20component%20of%20our%20business.%20For%20that%20reason%2C%20don%E2%80%99t%20hesitate%20to%20complete%20the%20surveys%20and%20provide%20feedback.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3ESpecial%20thanks%20and%20credits%20to%20the%26nbsp%3Bdevelopment%20team%3A%20%3C%2FU%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EBatuhan%20Yildiz%2C%20PM%2C%20ASD%20from%20USA%3C%2FLI%3E%0A%3CLI%3ERaghu%20Prasad%20B%20R%2C%20Data%20%26amp%3B%20AI%20PFE%20from%20USA%3C%2FLI%3E%0A%3CLI%3ERick%20Meijvogel%2C%20Data%20%26amp%3B%20AI%20PFE%20from%20Netherlands%3C%2FLI%3E%0A%3CLI%3ERomain%20Casteres%2C%20Data%20%26amp%3B%20AI%20PFE%20from%20France%3C%2FLI%3E%0A%3CLI%3ESajas%20Salahuddeen%2C%20Data%20%26amp%3B%20AI%20PFE%20from%20USA%3C%2FLI%3E%0A%3CLI%3ETincy%20Elias%2C%20Data%20%26amp%3B%20AI%20PFE%20from%20UAE%3C%2FLI%3E%0A%3CLI%3EViktor%20Radu%2C%20Data%20%26amp%3B%20AI%20PFE%20from%20USA%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-right%22%3E%3CSPAN%3E%3CEM%3EThanks%20to%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3CSPAN%3E%3CEM%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fsajas-salahuddeen%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESajas%20Salahuddeen%3C%2FA%3E%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3CSPAN%3E%3CEM%3Eand%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3CSPAN%3E%3CEM%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fraghuprasadbr%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERaghu%20Prasad%20B%20R%3C%2FA%3E%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3CSPAN%3E%3CEM%3Efor%20this%20article%20review.%3C%2FEM%3E%3C%2FSPAN%3E%3CSPAN%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-right%22%3E%3CSPAN%3E%3CEM%3EAuthor%3A%26nbsp%3B-ERR%3AREF-NOT-FOUND-Romain%26nbsp%3BCasteres%2C%20Senior%20Data%20%26amp%3B%20AI%26nbsp%3BPremier%20Field%20Engineer%20based%20in%20Paris%2C%20France.%26nbsp%3B%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-right%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1505391%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20this%20series%20of%20articles%2C%20we%20will%20present%20Premier%20Services%20Offerings%20around%20Power%20BI.%20In%20this%20one%20we%20will%20present%20the%20Power%20BI%20Assessment.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECustomer%20Offerings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERomainCasteres%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

 

Introduction

 

In this series of articles, we will present Premier Services Offerings around Power BI. In this one we will present the Power BI Assessment.

 

PowerBI_Assessment.png

 

Are you sure that your Power BI tenant follows Microsoft Best Practices? Are you noticing performance problems within your Premium dedicated capacity? Do you know how many users are consuming your reports? The Premier Services Offerings Power BI Assessment can answer these questions and more.

 

Power BI Assessment overview

 

Power BI Assessment is a proactive service delivered by a Microsoft accredited engineer to diagnose potential issues with your Power BI environment. Assessment is supported on both the Power BI Service (cloud) and Power BI Report Server (on premises) Engineer will provide valuable guidance on recommended practices to improve the health of your Power BI environment. At the end of this engagement, you will receive a comprehensive Power BI report with results of the assessment, a detailed best practice guidance deck and a summary report tailored to your environment.

 

PowerBIAssessment_Outcomes.png

 

PowerBIAssessmentAgenda.png

The deliverables include:

  • Comprehensive Power BI report with results of the assessment.
  • Power BI best practice guidance slide deck
  • Executive Summary report
  • Knowledge transfer on Power BI recommended best practices
  • Remediation planning guidance
  • Data collection scripts

Note that, the assessment will be even more valuable if you have Power BI Premium...

 

Some Key Focus Areas:

  • Premium Capacity Metrics App
  • Power BI Activity log
  • Power BI Admin APIs – Workspaces, Reports, Datasets, Dashboards, Embed Codes and more.
  • Power BI Tenant settings
  • Security and Governance
  • Power BI Report Server – execution logs, catalog database, performance counters and more.

 

Screenshot of some of the pages from a sample output repot below:

 

PBIAssessment4.png

 

PBIAssessment1.png

 

PBIAssessment2.png

 

PBIAssessment3.png

 

 

This service has already been delivered many times across the globe and received positive feedback. We continuously improve the content based on customer and engineer feedback.

 

PowerBIAssessment_Stats.png

 

Road Map

 

Some of the planned improvements in upcoming releases listed below:

  • Collection of additional Premium capacity metrics 
  • Include data collection and metrics for Dataflows
  • Include data collection and metrics for all Gateways in the tenant
  • Other general improvements in data collection and reporting

 

Follow up and feedback

 

For further information, please contact your Microsoft Account Representative, Technical Account Manager (TAM) or Service Delivery Manager (SDM).

 

To improve our workshop, we always consider feedback from you. At Microsoft, achieving a high level of satisfaction among our customers and partners around the world is a core component of our business. For that reason, don’t hesitate to complete the surveys and provide feedback.

 

Special thanks and credits to the development team:

  • Batuhan Yildiz, PM, ASD from USA
  • Raghu Prasad B R, Data & AI PFE from USA
  • Rick Meijvogel, Data & AI PFE from Netherlands
  • Romain Casteres, Data & AI PFE from France
  • Sajas Salahuddeen, Data & AI PFE from USA
  • Tincy Elias, Data & AI PFE from UAE
  • Viktor Radu, Data & AI PFE from USA

 

Thanks to Sajas Salahuddeen and Raghu Prasad B R for this article review. 

Author: Romain Casteres, Senior Data & AI Premier Field Engineer based in Paris, France.