Power BI

Features

• architecture
• XMLA read/write
• enable XMLA endpoints
• separation of data and content: Martens
• data gateway
• on-premise
• installation: Microsoft
• add data source: Microsoft
• data visuals
• conditional formatting: DataVibe
• data labels: Update Dec-23
• field parameters
• add measure slicers to a Report: PW
• SELECTEDVALUE: Russo
• dataflows
• best practices: Microsoft
• streaming: Microsoft
• perform in-storage computations
• optimize the use of dataflows
• use incremental refresh with dataflows
• reference other dataflows
• datamarts: Microsoft
• datasets
• push datasets: SQLBI
• parallel loading: Cutler
• architecture
• Power BI enhanced report format (PBIR): Romano
• DAX
• DAX query view: Microsoft
• visual calculations
• calculation groups
• infrastructure
• autoscale
• backup and restore
• multi-geo: Microsoft
• Report Server
• storage
• insights
• semantic models 
• query caching: Microsoft

Actions

• performance tuning
• cheatsheet: DataMozart

DAX Functions

• KEEPFILTERS: Russo
• RANKX: DataVibe, PBIDAX
• SELECTEDVALUE
• field parameters: Russo

Power BI Challenges

• Data DNA
• Maven Analytics
• ZoomCharts
• Workout Wednesday

Power BI Tools

• Acterys Modeller
• ALM Toolkit
• Bravo for Power BI
• Business Ops
• DAX Formatter
• DAX Optimizer
• DAX Studio
• Measure Killer
• Metadata Translator
• PBI Explorer
• PBI Tools
• Power BI Studio
• Report Analyzer
• Tabular Editor

Power Query Functions

• DeltaLake.Table: Microsoft, Webb
• Rank: RadCad

Resources

• usage scenario diagrams: Microsoft
• webcasts
• SSBI Central (EN/RO)
• Explicit Measures (EN, incl. Microsoft Fabric)

References:

• Alberto Ferrari
• Andy Cutler
• Marco Russo
• Pragmatic Works (PW)
• Rui Romano
• Thomas Martens
• RadCad