Data Prep

Covering: Power Query (M), Dataflows, Data connectors, Analysis Services

• 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

Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX

• 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

Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes

• 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

Data Exploration

Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through

Deployment, Security and Operations

Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK

• 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

Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications

• 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