Power BI Weekly
Issue #59 - 19th May 2020
A long awaited feature has landed this week, and that's the deployment pipelines that have been demoed at Microsoft Ignite last year and MBAS a couple of weeks ago. This (preview) feature provides much-needed lifecycle management for Power BI artifacts, surfaced through a user-friendly user interface. However (as ever...) this is only currently available for workspaces assigned to Premium capacities, and lacks support for Dataflows - so a way to go yet before it becomes useful for a lot of us. Also announced this week: the Power BI Embedded samples have been spruced up, with examples in .NET, Python, Java and Node and React. Perfect resources for those of you trying to get going with embedded reports.
Elsewhere, Zach Renwick has written about Why You Should Choose Power BI Pro or Premium over Power BI Report Server, Soheil Bakhshi has described Power BI Version Control with OneDrive, Teams and SharePoint Online, and Imke Feldmann has provided a useful Performance tip to speed up slow pivot operations in Power Query and Power BI.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) describes how to Speed Up Data Refresh Performance In Power BI Desktop Using Table.View
- On the Power BI community blog, Ahmed Oyelowo (@AhmedOyelowo) writes To Transpose or Unpivot? What you need to know about table structuring in Power Query (2)
- On the Data Bear blog, Edward Van Der Merwe blogs about Data Preparation Part 2 – Pivot vs Unpivot Columns
- Also on the Power BI community blog, Ignacio Barrau (@ignacho_07) writes From Pandas and SQL to Power Query Code and on LaDataWeb writes Exportar datos automáticamente al actualizar conjunto [Spanish]
- Patrick Leblanc (@GuyInACube) describes how to Copy queries in Power Query for Power BI or Excel
- Jon Acampora (@excelcampus) shares a Power Query Overview: An Introduction to Excel's Most Powerful Data Tool
- On the Excelguru blog, Ken Puls (@kpuls) describes how to Name Worksheets After Queries
- Imke Feldmann (@TheBIccountant) describes How not to miss the last page when paging with Power BI and Power Query and shares a Performance tip to speed up slow pivot operations in Power Query and Power BI
- Purna (Chandoo) Duggirala (@r1c1) writes about Multiple Find Replace with Power Query List.Accumulate()
🧩 Data Modeling
- On the endjin blog, Carmel Eve (@carmel_eve) describes How can I improve my data model in Power BI?
- Matt Allington (@ExceleratorBI) talks about Expression Based Formatting in DAX
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) shares an Introduction to DAX Studio video by Darren Gosbell & Marco Russo
- Also on the Power BI community blog, Greg Deckler (@GregDeckler) updates the Excel to DAX Translation, and writes a reflective series on the task at hand: Part1: Reflections on Excel to DAX Translation, Part 2 and Part 3:
- Chandeep Chhabra (@chandeep2786) writes about Calculate Accrued Commission – DAX Challenge
- On the SQL Shack blog, Ben Richardson discusses the Differences between the M Language and DAX in Power BI
- On the Power BI community blog, Sam McKay (@_EnterpriseDNA) shares some Unique Time Intelligence Analysis Examples for Power BI
- On Le CFO Masqué, Kim Leblanc writes Exporter un modèle de données depuis Power Pivot vers Power BI [French]
⚙️ Report Design and Visualizations
- Parker Stevens (@PowerBIElite) writes about Dynamic Conditional Formatting for Values and Totals in a Power BI Matrix
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Highlighting the minimum and maximum values in a Power BI matrix
- Adam Saxton (@GuyInACube) describes a Technique to improve Power BI report perf by reducing visuals
- On the Towards Data Science blog, Michal Butkiewicz (@MikeBeUX) describes Three easy things you can do to improve the design of any Power BI report
- On the Prologika blog, Teo Lachev (@tlachev) discusses Showing Database Images in Power BI and Tabular
- Lars Schreiber (@SchreiberLars) shares a Podcast-IBCS in Power BI and Excel with Zebra BI visuals with Andrej Lapajne
- Also on the Towards Data Science blog, Ednalyn C. De Dios (@ecdedios) explains how to Create a Network Graph in Power BI
- Also on the Towards Data Science blog, Kenneth Infante (@iamkennethcpa) describes Creating a Storm Tracker in Power BI
- On the Power BI Tips and Tricks blog, Alice Drummond (@AliceDiscoverEI) explains how to Create 3D Maps in Power BI with MapBox
- Meagan Longoria (@mmarie) shares their MBAS Presentation on Power BI Report Accessibility
- On Le CFO Masqué, CompteAdminCFO (@lecfomasque) posts Valeur affichée vs valeur calculée [French]
- On the xViz blog, Bhupinder Singh describes the xViz Packed Bubble Chart – Key Features of Power BI Visual
- On the SQL Shack blog, Ben Richardson blogs about Creating a visualization in Power BI Report View
⚙️ Data Exploration
- Darrin Kinney shares a Power BI Progress & Schedule Dashboard
- Patrick Leblanc (@GuyInACube) explains how to Build a DATE PICKER in Power BI Desktop
- Brett Powell (@BrettPowell76) provides a Synapse SQL Monitoring Template
- Prathy Kamasani (@pkamasani) talks about Power BI Bookmarks vs Page Navigation
- On the Blue Granite blog, Tom Weinandy (@TomWeinandy) describes Mapping COVID-19's Effect on Local Employment with Power BI
- On the xViz blog, Bhupinder Singh describes 10+ Reasons to use Hierarchy Filter/Slicer in your Power BI Dashboards
- Also on the xViz blog, Ramkumar Sharma discusses Launch your Favourite Netflix Genre with Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Nimrod Shalit introduces Power BI deployment pipelines (Preview)
- Zach Renwick (@zachrenwick) writes about Why You Should Choose Power BI Pro or Premium over Power BI Report Server
- Gilbert Quevauvilliers (@GilbertQue) writes that Power BI coupled with Power Automate allows for super-fast dataset refreshes
- Soheil Bakhshi (@biinsightnz) introduces Introducing Power BI Governance and Adoption Good Practices Series and writes Part 2: Version Control with OneDrive, Teams and SharePoint Online
- On the endjin blog, James Broome writes about Why Power BI developers should care about the new read/write XMLA endpoint
- On the Power BI community blog, Jayendran Arumugam (@Jayendran_A) writes about the PowerBI intermittent Refresh Failure - Unable to connect to the data source undefined
- On the MSSQLTips site, Fikrat Azizov explains how to Automate Azure Analysis Services Management Tasks using Logic App - Part 1
🌐 General
- On the Power BI blog, Amit Shuster highlights the New developer samples for Power BI embedded analytics
- Also on the Power BI blog, Lauren Faber shares How Veolia Improves Customer Experiences with Power BIand Azure
- Adam Saxton and Patrick Leblanc (@GuyInACube) shares a REPLAY Power BI tips from the Pros – LIVE Hangout (May 16, 2020)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 145 - April 2020 Power BI Desktop Update
- Adam Saxton (@GuyInACube) talks about the Power BI announcements and a new Desktop release... (May 11, 2020)
- Devin Knight (@knight_devin) provides the Power BI Monthly Digest – April 2020 with Matt Peterson
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 119