Power BI Weekly
Issue #28 - 8th October 2019
Only a couple of blogs from the Power BI blog this week: Announcing Power BI updates at the Microsoft Business Applications October Virtual Launch Event (tune in if you want to get a first-hand look at new updates), and Increase Business Impact with Power BI and Azure Analytics (find analysis of Forrester's recent findings). From the Azure blog, we've been told about the SQL Server Data Tools support for 1500 compatibility level, which includes Calculation Groups and Many-to-Many relationships.
Elsewhere, Phil Seamark has joined Adam Saxton to talk about Debugging a slow Power BI report with Phil Seamark, and Erik Svensen has written about PowerQuery - Control the expand columns so it includes new columns.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) discusses Power BI And Case Sensitivity
- Erik Svensen (@donsvensen) blogs about PowerQuery – Control the expand columns so it includes new columns
- On the Power BI community blog, Imke Feldmann (@TheBIccountant) writes about a Bug warning for Table.Sort and removing duplicates in Power Query
- Patrick Leblanc (@GuyInACube) blogs about Power BI dataflows: Where does it fit in? (Matthew Roche schools Patrick)
- Matthew Roche (@SQLAllFather) talks about Importing model.json to create a new dataflow and writes about Power BI workspace lineage
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Change the T-SQL Script of a Power BI Table without Add/Remove from the Model
- Eugene Meidinger (@sqlgene) provides a Query folding workaround for Azure Devops and Power BI
- Also on the Power BI community blog, Michal Dvorak (@nolockcz) writes about a Time Dimension in Power Query
- Chandeep Chhabra (@chandeep2786) explains how to Calculate Age in Years and Months in Power BI
- On the Data Bear blog, Edward Van Der Merwe discusses Data Preparation Part 1 – The Basics
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes Creating a Table in Power BI Using DAX Table Constructor and writes about Why My Values are Not Showing Correctly in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about Quick Measures – How To Use Them in Power BI Models, explains how to Build A Comprehensive Date Table in Power BI Really Fast, describes how to Measure Averages Per Day Using AVERAGEX With DAX and describes How To Work With Multiple Dates In Power BI
- Adam Saxton (@GuyInACube) talks about Debugging a slow Power BI report with Phil Seamark
- Phil Seamark (@PhilSeamark) blogs about DAX: Bitwise calculations and discusses DAX: Base conversions
- Matt Allington (@ExceleratorBI) covers REMOVEFILTERS in DAX
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Naming temporary columns in DAX
- On the Power BI Tips and Tricks blog, Steve Campbell blogs about a Custom Sort Order Within a DAX Measure
- On the Power BI community blog, Nathaniel_C walks through Using EARLIER with a SMART INDEX.
- The Azure updates team writes about the SQL Server Data Tools support for 1500 compatibility level
- Imke Feldmann (@TheBIccountant) writes about Parent-Child Hierarchies with multiple parents in Power BI with Power Query
⚙️ Report Design and Visualizations
- Craig Porteous (@CPorteous) covers Visualising Forms data with Power BI
- Patrick Leblanc (@GuyInACube) talks about A way to get rid of the pie chart in Power BI Desktop?!?
- Darrin Kinney provides an Engineering Progress Report – PowerBI
🚀 Deployment, Security and Operations
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) writes about Power BI datasets: A Method to the Madness
- Gilbert Quevauvilliers (@GilbertQue) writes Did you know you can use the Scheduled Cache Refresh for LiveConnections in Power BI to tell you if it is down?
🌐 General
- On the Power BI blog, Miguel Martinez (@maikelson) writes Announcing Power BI updates at the Microsoft Business Applications October Virtual Launch Event
- Also on the Power BI blog, Arun Ulag (@arunulag) covers Increase Business Impact with Power BI and Azure Analytics
- Adam Saxton (@GuyInACube) delves into Power BI performance tuning, grouping and Power BI Report Server... (Roundup | September 30, 2019)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 119 Power Platform 2019 Roadmap Wave 2 Plan and Episode 120 Power BI News update
- On the Power BI community blog, sivah highlights some Power BI Training Content
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the First Ever Power BI & DAX Masterclass Event From Enterprise DNA