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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- 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
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- On the Power BI community blog, Jayendran Arumugam (@Jayendran_A) blogs about Power BI - CICD using Azure DevOps
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.