Power BI Weekly
Issue #22 - 27th August 2019
A very exciting update this week is the new custom branding capability for the top nav in the Power BI Service, allowing you to insert your company logo, change the theme colour, and add a cover image. We've also been told about What's new for SQL Server 2019 Analysis Services RC1, and about the Change to Summarized Data Export behavior with Build permission. Elsewhere, Paul Turley has written a detailed blog about Power BI Project Good and Best Practices, and Alberto Ferrari has written about the mysterious Blank row in DAX.
🛠️ Data Prep
- On the Power BI community blog, Michal Dvorak (@nolockcz) writes about a Lookup Table in Power Query
- Brett Powell (@BrettPowell76) writes about a Time Dimension Table via Power Query
- Chandeep Chhabra (@chandeep2786) explains how to Combine Data from Multiple Sheets in a Single Sheet
- Chris Webb (@cwebb_bi) discusses Setting Azure Analysis Services Server Properties Not Visible In SQL Server Management Studio
- On the Power BI blog, Christian Wade (@_christianWade) describes What's new for SQL Server 2019 Analysis Services RC1
- Gilbert Quevauvilliers (@GilbertQue) describes Using Azure Analysis Services to connect via an ODBC Source Redshift
- Roberto Stefanetti (@robstefane) writes about The power of queries to map Business Central entities into Power BI
🧩 Data Modeling
- Mimoune Djouallah (@mim_djo) explains how to Build asymmetrical Pivot table in Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about the Blank row in DAX
- On the Blue Granite blog, Eric Lofstrom talks about The Art of the Disconnected Table
- Chandeep Chhabra (@chandeep2786) highlights a DAX Puzzle
- Daniil Maslyuk (@DMaslyuk) writes about the New DAX functions: CONVERT and REMOVEFILTERS
- Matt Allington (@ExceleratorBI) describes how to Dynamically Show Completed Months in Power BI
- Adam Saxton (@guyinacube) explains how to Connect to Power BI Desktop with 3rd party tools and writes about 2 ways to reduce your Power BI dataset size and speed up refresh
⚙️ Report Design and Visualizations
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Using Data Category to Have a Better Visualization in Power BI
- Adam Saxton (@guyinacube) presents POWERAPPS and POWER BI can do what?!? It's bananas!
- Charles Sterling (@chass) posts the Adv Hands On Lab 5: Embedding PowerApps into Power BI
⚙️ Data Exploration
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) writes about the Change to Summarized Data Export behavior with Build permission
- Marc Lelijveld (@MarcLelijveld) writes about Storytelling with Power BI 5/7: Ensure consistent context
🚀 Deployment, Security and Operations
- On the Power BI community blog, Jayendran Arumugam (@Jayendran_A) blogs about Power BI - CICD using Azure DevOps
🌐 General
- On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) announces custom branding for your organization
- Paul Turley (@paul_turley) blogs about Power BI Project Good and Best Practices
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 114 Live from SharePointFest Seattle with Chris Finlan
- On the Power BI community blog, MCornish explains How Power BI Transformed Our Data Culture
- Adam Saxton (@guyinacube) presents Power BI Desktop, Premium settings, Star Schema and more (August 19, 2019)
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) tells us to Join the Spanish Power BI forum