Power BI Weekly
Issue #63 - 16th June 2020
If this edition seems a little larger than usual, that's because we're now including YouTube content in the newsletter. So, you'll be seeing more and more great YouTube content being added in the near future. If you subscribe to any channels and you think that its content belongs in this newsletter, then send us a message! We can't find them all, and we want to include as much content from the community as possible.
In light of this news, it seems fitting to share some videos that have been shared in the last week. To kick things off, Ruth Pozuelo Martinez has posted the latest episode of DAX Fridays, with the edition #175: Column Fusion - Optimize your DAX queries!, where Ruth uses the neat technique described by Phil Seamark here which can speed up your DAX queries, with just a couple of changes to your measures. Elsewhere, Reid Havens has demonstrated Creating a Deployment Pipeline in the Power BI Service, and Dhruvin Shah has shown off the new mobile report development experience in the video: Develop Power BI Report for Mobile View Using Enhanced Mobile Emulator.
There have also been a number of announcements this week. As mentioned, there is a new mobile authoring experience in Power BI Desktop. The Power BI Desktop June 2020 Feature Summary has also landed, including the GA of automatic page refresh and the hierarchy slicer. Additionally, Dark mode for the Power BI iOS app has landed, we've been told that the On-premises data gateway June 2020 update is now available, and finally we've been told about the Power BI data protection GA and new capabilities.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) discusses Optimising The Performance Of Power Query Merges In Power BI, Part 4: Table.Join And Other Join Algorithms
- On the Power BI community blog, Ed Hansberry (@ehansalytics) talks about Utilizing M Code Samples Given as Solutions in Power Query
- Rick de Groot (@ExcelGorilla) writes about 3 Ways to SUM null values in Power Query
- Lars Schreiber (@SchreiberLars) writes about 3 ways for sums over columns in Power Query
- On the CSG Pro blog, Mark Walter (@storybicom) explains how to Learn How to Track Errors with a Power Query Error Table
- Chandeep Chhabra (@chandeep2786) describes how to Change Dates from MM-DD to DD-MM Format and Vice Versa
- Ruth Pozuelo Martinez (@ruthpozuelo) explains How to create hierarchies in Power Query and describes the Easiest and fastest way to get ANY data from OneDrive into Power BI
- Spencer Baucke (@JSBaucke) walks through Connecting to Data Dot World with Power BI
- On the MSSQLTips site, Scott Murray discusses Power BI Data Source (PBIDS) Files
🧩 Data Modeling
- Darren Gosbell (@darrengosbell) highlights that DAX Studio 2.11.0 Released
- Phil Seamark (@PhilSeamark) blogs about DAX 1-Column Fusion
- Ruth Pozuelo Martinez (@ruthpozuelo) shares DAX Fridays! #175: Column Fusion - Optimize your DAX queries!
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Sorting duplicated names in a level of a hierarchy with DAX
- Parker Stevens (@PowerBIElite) talks about Comparing One Category vs All Others in Power BI with DAX
- On the Power BI community blog, Michal Dvorak (@nolockcz) writes a How-To: A Table for Custom Report Measures
- On the Towards Data Science blog, Davis Zhang describes Implementing K-Nearest Neighbor Classification Algorithms Using DAX and covers Advance DAX Tutorial: Basket Analysis 2.0
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes about ALL - ALLSELECTED - ALLEXCEPT [Spanish]
- Nisal Mihiranga (@@nisalm) explains how to Analyse Data by using Role-Playing Dimensions Effectively in Power BI
- On the Purple Frog Systems blog, Nick Edwards describes Using ConcatenateX in PowerBI to return multiple values.
- Patrick Leblanc (@GuyInACube) wonders Why is there a BLANK in my Power BI slicer???
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about The Ultimate Budget Allocation Formula For Power BI Analysis and on the Power BI community blog, shares some Prediction Techniques for Power BI - How to Set Up This Type of Analysis
⚙️ Report Design and Visualizations
- On the Power BI blog, Michal Foster Heldy explains how to Create stunning mobile reports with the updated mobile authoring in Power BI Desktop
- Dhruvin Shah (@DhruvinShah16) explains how to Develop Power BI Report for Mobile View Using Enhanced Mobile Emulator and covers Data Storytelling with Comic Characters Based on Emotions and Poses of your Data in Power BI
- On the BlueGranite YouTube channel, David Eldersveld (@dataveld) describes how to Anchor and Conditionally Format an Other Category in a Power BI Visual
- Mark Walter (@storybicom) describes how to Improve the Readability of the Matrix Visual
- Mike Allen (@MikeAinOz) shares some ParaHtml Power BI Custom Visual Version 1.0.0 Guidance
- Daniel Marsh-Patrick (@the_d_mp) writes that Small Multiple Line Chart 2.1.0 Now Available
- On the CSG Pro blog, Ben Lawrence describes Visualizing Anomaly Detection and Interactive Documentation in Power BI
⚙️ Data Exploration
- Alberto Almoguera (@alalmoguera) provides A little entertainment – Covid & Stock Markets
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shares a Differently Abled People Survey Analytics Dashboard in POWER BI
- Dhruvin Shah (@DhruvinShah16) explains how to Apply Navigation from an Image to a Page in Power BI
- On Qiita, Yugo Shimizu (@yugoes1021) writes Power BI でリアルタイムアンケート ~ アンケートを即可視化 2020年版 ~ [Japanese]
🚀 Deployment, Security and Operations
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that the On-premises data gateway June 2020 update is now available
- Also on the Power BI blog, Anton Fritz (@AntonFritz15) announces the Power BI data protection GA and introducing new capabilities
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) explains how to Automate on-demand Dataset Refresh in Power BI – Self Service BI
- John White (@diverdown1964) walks through Creating Data Driven Subscriptions for Power BI Reports
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) discuss Episode 149 - Creating Data Driven Subscriptions for Power BI Reports
- Adam Saxton (@GuyInACube) asks Want to know when Teams will STOP creating Workspaces in Power BI???
- Reid Havens (@HavensBI) discusses Creating a Deployment Pipeline in the Power BI Service
- On the Towards Data Science blog, Korkrid Akepanidtaworn (@k_akepan) discusses Unblocking Power BI—A Leap into Power BI Deployment Pipeline (BIOps) (Ep. 6)
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes how to Show the information but not the details (Power BI Data Masking) and writes about Secure the Sensitive Data in Power BI (Data Masking better with Row Level Security)
- On the Blue Granite blog, Dan Szepesi (@szBigDan) describes How to Improve Power BI Performance - Part II
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) describes how to Split an existing Power BI file into a model and report
- Rafael Mendonça (@rafaelmpsantos) writes Atualização Incremental de Qualquer Tipo de Fonte de Dados!!!! [Portuguese]
- Marc Lelijveld (@MarcLelijveld) explains How to keep your Power BI dataflows organized and optimized
- Brett Powell (@BrettPowell76) shares a Synapse Columnstore Index Analysis Template
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) covers Process Analysis Service with Data Factory only and discusses how to Pause and Resume Analysis Services with ADF only
- On the MSSQLTips site, Fikrat Azizov explains how to Automate Azure Analysis Services Management Tasks using Logic App - Part 3
- Gilbert Quevauvilliers (@GilbertQue) explains How you can incrementally refresh any Power BI data source (This example is a CSV File)
🌐 General
- On the Power BI blog, Sujata Narayana shares the Power BI Desktop June 2020 Feature Summary
- The Power BI team (@MSPowerBI) shares the Power BI Desktop Update video - June 2020
- Ruth Pozuelo Martinez (@ruthpozuelo) shares a Quick feature summary for the Power BI Desktop June 2020
- Also on the Power BI blog, Maya Shenhav announces The theme you've been waiting for - Dark mode comes to the Power BI iOS app
- On the PowerPivotPro blog, Rob Collie (@robcolli3) blogs about Power BI and Paginated Reports: Have We Come Full Circle and writes about Paginated Reporting and Power BI: Why You Probably Need Both
- On the BlueGranite YouTube channel, the BlueGranite team (@BlueGraniteInc) covers Power BI Office Hours [May 2020 #2]
- James Serra (@JamesSerra) shares a Power BI FAQ
- Adam Saxton (@GuyInACube) talks about Power BI quizzes, data masking and more... (Roundup | June 8, 2020) and shares the REPLAY Power BI tips from the Pros – LIVE Hangout w/ Marco Russo (June 13, 2020)
- Devin Knight (@knight_devin) shares the Power BI Monthly Digest – June 2020 with Matt Peterson
- Avi Singh (@powerbipro) talks about Power BI vs. Current Crisis: Challenges & Opportunities for Businesses and Power BI Professionals (with guests!)
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) blogs about Power BI Tips, Tricks & Hacks by Rui Romano
- Marcus Wegener (@PowerBIler) writes about Fünf häufig gestellte Fragen zu Power BI [German]