Data Prep

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

• Ben Gribaudo (@bgribaudo) writes Power Query M Primer Part 16: Type System I
• Chris Webb (@cwebb_bi) shares An M Function To Help You Explore Power Query Diagnostics Data
• On the Power BI community blog, Michal Dvorak (@nolockcz) describes How To Convert a Power BI Dataset To a Power BI Dataflow
• Matt Allington (@ExceleratorBI) explains how to Remove Duplicates and Keep the Last Record with Power Query
• Gilbert Quevauvilliers (@GilbertQue) discusses Connecting to Snowflake DB in Power BI
• On the MSSQLTips site, John Miner (@JohnMiner3) writes about a Power Query Source for SQL Server Integration Services

Data Modeling

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

• Joseph Yeates (@FthrsAnalytics) discusses Creating an Income Statement with DAX in Power BI – Part 2
• On the SQLBI blog, Marco Russo (@marcorus) blogs about Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations
• Patrick Leblanc (@GuyInACube) explains how to Create custom keys for your Power BI relationships
• On the Towards Data Science blog, Bruno Bossaerts describes how to Add Category Other to Charts
• Parv Chana (@parvchana) explains how to Restrict number of data points in Power BI visuals
• Imke Feldmann (@TheBIccountant) writes about Dynamic Benford's Law measures in Power BI and Power Pivot
• On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Find a Text Term in a Field in Power BI Using DAX Functions
• On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes Three Ways to Create a Calendar Table
• Phil Seamark (@PhilSeamark) writes about Overriding slicers
• Darren Gosbell (@darrengosbell) wonders Do the ALL() and REMOVEFILTERS() functions always work correctly in DAX?
• Also on the Power BI community blog, Amit Chandak (@amitchandak78) walks through Decoding Direct Query in Power BI Part 1: Time Intelligence in Direct Query : SQL Server
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains how to See Changing Results Using Calculated Columns In Power BI, writes about Common Customer Behavior Analysis Using Power BI and describes how to Use Power BI Analytics To Check If Revenue Growth Is Profitable

Report Design and Visualizations

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

• On the RADACAD blog, Leila Etaati (@leila_etaati) writes about the Decomposition Tree Visual in Power BI- Part Two
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about a Data Visualization Technique in Power BI – Multi Measure Dynamic Visuals
• Devin Knight (@knight_devin) presents Power Platform Quick Tips – Episode 04: Hiding Power BI Visuals Interactivity
• On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Cross Highlight Excel Charts
• Patrick Leblanc (@GuyInACube) presents Want a custom LEGEND for your Power BI visual? WATCH THIS!
• Sebastian Zolg (@sebastianzolg) writes Are You on Track - Communicate Your Strategic Themes on an Interactive Roadmap with No-Code.
• On the Prologika blog, Teo Lachev (@tlachev) blogs about Power BI Slicers and Filters
• On the Visual BI blog, Bhupinder Singh writes about the Waterfall Chart – Advanced Custom Visuals for Power BI
• On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) talks about Layouts for Company Templates

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

• Adam Saxton (@GuyInACube) talks about What you NEED to know about Publish to Web in Power BI
• On the Forsight BI blog, Ahmed Oyelowo writes about the Most Common Power BI Installation Errors And Their Solutions

General

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

• On the Power BI blog, Amit Shuster provides the Power BI Developer community February 2020 update
• David Eldersveld (@dataveld) provides a Quick Tip: Use Windows Shortcuts to Open Power BI with a Default File
• Adam Saxton (@GuyInACube) highlights that Power BI updates have started again... (Roundup | February 3, 2020)
• On the Power BI community blog, Syndicate_Admin writes that The Global Power Platform Boot camp is coming to a city near you
• Prathy Kamasani (@pkamasani) blogs about the Jan 2020, London PowerBI UG DataViz
• Also on the Power BI community blog, Sivakumar Harinath writes about Power BI Training Content
• Also on the Power BI blog, Kelly Kaye highlights a couple of webinars: Top Tips and Tricks from PowerBI.Tips (2019 Edition) by Mike Carlo and covers Self-Service AI in Power BI Desktop
• On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes about the Milwaukee Brew City PUG – Jan 2020
• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 135 - Early February Catch Up