Power BI Weekly
Issue #184 - 29th November 2022
Absolutely no word from the Power BI team this week, so we'll jump straight into the community content. Last week Paul Turley began a series of articles regarding Developing Large Power BI Datasets, and has now followed up the first article with two more great articles related to Partitioning and Detail Tables. Bas Dohmen has shown how we can use the dynamic Y axis functionality to achieve 100% Axis Control in Power BI, and Greg Deckler has taken a step back discussing the topic of Planning Power BI Projects.
Finally, we've published our Accessible Data Storytelling: World Bank Heath and Wealth Report to the Power BI Data Stories Gallery, which has been an internal project to highlight how to create compelling data stories with an accessible colour palette to assist users with Colour Vision Deficiency. If you're creating a Power BI report that has an audience larger than 12 people, statistically you need to take into account Colour Vision Deficiency. We've also produced two videos which provide A walkthrough of the World Health and Wealth Data Story and Custom Report Design: An Array of Design Concepts and Accessible Colours for Power BI.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about How Much Data Can You Load Into Power BI?
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Power Query Optimization: Reducing Decimal Numbers
- Chandeep Chhabra (@chandeep2786) explains how to Remove Change Type Errors in Power Query
- Marcus Wegener (@PowerBIler) explains how to Calculate ISO 8601 Calendar Week in Power Query with SQL Query Folding
- James Andrew (@MatadorSoftware) talks about Fixing a Common Issue with Dates in Power BI | Add Leading Zero in Power Query
- Purna (Chandoo) Duggirala (@r1c1) describes How to connect to a single file on SharePoint from Power Query (Fix Unable to Connect Error)
- Laura Graham-Brown (@Laura_GB) writes about Power BI Connecting to Google Analytics
- Gaelim Holland (@_EnterpriseDNA) describes How To Create A Forecast Model In Power BI With Python
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into Filters based on content of other tables in Power BI – Unplugged #44
- Sam McKay (@_EnterpriseDNA) describes When To Use The CALCULATETABLE Function - DAX Function Techniques [2022 Update]
- Pat Mahoney (@mahoneypa) covers Handling Ties with TOPN
- Paul Turley (@paul_turley) writes Developing Large Power BI Datasets – Part 2 – Partitioning and Part 3 – Detail Tables
- Marc Lelijveld (@MarcLelijveld) explains how to Connect the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services
- Jason Cockington (@JasonCockington) describes Five Essential Power Tools for Power BI Desktop
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) talks about 100% Axis Control in Power BI and describes Smart Data Labels
- Greg Deckler (@GregDeckler) talks about Dueling Tooltips In Power BI
- Leila Gharani (@LeilaGharani) explains how to Rename Clunky Fields in Power BI
- Darren Gosbell (@darrengosbell) blogs about Power BI – Using Field Parameters in Paginated Reports
- James Andrew (@MatadorSoftware) describes how to Use Python to Create a Correlation Heatmap Visual in Power BI
- Sam McKay (@_EnterpriseDNA) describes Creating P&L Statements In Power BI - Financial Reporting Example [2022 Update]
- Daniel Marsh-Patrick (@the_d_mp) writes about Happy 1st birthday, Deneb!
🚀 Deployment, Security and Operations
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about 4 + 2 Security features in Power BI
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Row Level Security & Object Level Security In Power BI DAX Studio
- Shabnam Watson (@ShbWatson) describes Exploring Automatic Partition Maintenance in Power BI datasets with Incremental Refresh, using EffectiveDate parameter
- Gilbert Quevauvilliers (@GilbertQue) blogs about Testing Power BI REST APIs with Try it
- Also on the Towards Data Science blog, Nikola Ilic (@DataMozart) explains how to Identify Data Loading Bottlenecks in Power BI
- Laura Graham-Brown (@Laura_GB) describes how to Power BI – Take over a Dataset
- On the phData, Gavin Pedersen (@gavin_PD) describes How to Create a Power BI App
- Ignacio Barrau (@ignacho_07) covers Power BI Apps contenido por audiencia [Spanish]
- Audrée Pellerin covers La sécurité des applications Power BI [French]
- On Acuity Training, Ben Richardson (@AcuityTraining) describes Sharing Reports & Dashboards In Power BI
🌐 General
- On the Enterprise DNA blog, Greg Deckler (@GregDeckler) writes about Power BI Project Planning: Discovery & Ingestion and walks through Planning Power BI Projects
- Rahim Zulfiqar Ali (@rahimzulfiqar) covers 15 Microsoft Power BI Tips for Better Dashboards
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 211