Power BI Weekly
Issue #34 - 19th November 2019
Last week we were given the Power BI Desktop November 2019 Feature Summary, which included things like the Decomposition tree visual, numerous visualization updates and an introduction to the new AI functions in Power Query. However, the one that most people are talking about is the Updated Ribbon Experience for Power BI Desktop. What do people think? Do we like the convergence towards the rest of the Office products, or did we like that Power BI was 'different'? We've also now been told how we can Analyze LinkedIn Sales Navigator usage data in Power BI with the new connector.
Elsewhere, Alberto Ferrari has written an interesting blog about the importance of star schemas in Power BI, and Konstantinos Ioannou has described How to create R custom visual (html) in Power BI.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) talks about Troubleshooting Web Service Refresh Problems In Power BI With The Power Query Diagnostics Feature
- David Eldersveld (@dataveld) talks about Managing Credentials for AI Transforms in Power BI Desktop
- Paul Turley (@paul_turley) writes about Next Level Power BI – M Language Basics
- Matthew Roche (@SQLAllFather) provides a Quick Tip: Working with dataflow-created CDM folders in ADLSg2 and provides a Power BIte: Creating dataflows by attaching external CDM folders
- Imke Feldmann (@TheBIccountant) describes how to Dynamically create types from text with Type.FromText in Power Query and Power BI
- The Azure updates team highlights the Azure Stream Analytics – Managed Identity authentication with Power BI
- Mimoune Djouallah (@mim_djo) explains How to Export data from PowerQuery to BigQuery
- Adam Saxton (@GuyInACube) talks about the New Artificial Intelligence capabilities in Power BI Desktop with Sarina Stevens
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Find The Data Value using LookupValue DAX Function in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains how to Predict Future Profitability within Power BI DAX Functions, How To Use The EARLIER Function In Power BI – A DAX Tutorial and describes DAX Calculations: Total Of Average Results
- Adam Saxton (@GuyInACube) blogs about Where's my measure??? (Power BI Paginated)
- Lars Schreiber (@SchreiberLars) explains How does the filter context in DAX apply?
- Chandeep Chhabra (@chandeep2786) lists some Books on Power BI
- Phil Seamark (@PhilSeamark) writes about Creative Aggs Part VI : Shadow Models and writes about Mixed Grain aggregations
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about The importance of star schemas in Power BI
- Patrick Leblanc (@GuyInACube) describes How do you even use VertiPaq Analyzer with Power BI with Marco Russo
⚙️ Report Design and Visualizations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Power BI Data Bars In Table Visualisations
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) explains how to Consolidate Report Pages Easily with Visual Grouping
- Devin Knight (@knight_devin) presents Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
- On the Power BI Community blog, Aditya Vighne writes about the New Visual – Decomposition Tree: November 2019
- Konstantinos Ioannou (@IoannouKonstan) describes How to create R custom visual (html) in Power BI
⚙️ Data Exploration
- On the Power BI blog, Rebar Niemi explains how to Analyze LinkedIn Sales Navigator usage data in Power BI
- On the MSSQLTips site, Scott Murray discusses the Power BI Filter Pane
- LC talks about Power BI: Pareto Analysis
- Carl de Souza (@carldesouza) checks out the New Look and Navigation of the Power BI Mobile App
🚀 Deployment, Security and Operations
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about What is Common Data Service (CDS) and why it is important for you if you use Power Apps or Power BI?
- Kasper de Jonge (@kjonge) explains how to Find all queries to Azure AS from a Power BI report or dataset
- Marc Lelijveld (@MarcLelijveld) talks about Versioning and CI/CD for Power BI with Azure DevOps
- John White (@diverdown1964) provides A low cost approach for paginated report subscriptions in Power BI
- Gilbert Quevauvilliers (@GilbertQue) discusses Getting automatically notified for Power BI Support Issues
🌐 General
- Also on the Power BI blog, Amanda Cofsky (@MissAmandaN) provides the Power BI Desktop November 2019 Feature Summary
- On the Power BI blog, Tessa Hurr (@tessahurr) writes about the Updated Ribbon Experience for Power BI Desktop
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 126 - November 2019 Power BI Desktop Update
- Darrin Kinney provides a Construction Progress Report
- On the Power BI community blog, EStieg writes Time is Running Out - Reserve Your Spot Today for the Exclusive Ask Amir Anything on 11/20
- Adam Saxton (@GuyInACube) delves into the Killer Power BI updates at MS Ignite with John White and Jason Himmelstein (Roundup | November 11, 2019)