Power BI Weekly Issue 77: 22nd September 2020
Has everyone remembered that the Microsoft Ignite virtual conference starts today? If you haven't, don't worry - there's still time to sign-up. I'm sure there'll be plenty of exciting announcements/updates/roadmpas, both in Power BI and in the wider Microsoft ecosystem. Learn more over here.
Otherwise, some pre-Ignite good news: there are now Power Automate actions for exporting Power BI and paginated reports which is perfect for those of you automating the exporting/distributing of Power BI content. However, you won't be surprised to hear of the requirement for a dedicated capacity. Humph. We've also been told about the Updates to the 'new look' experience and release plangoing forward, including more admin settings for those determining what Power BI users view in their organization.
Elsewhere, Matthew Roche has answered a few thus-far unanswered questions in the blog Dataflows enhanced compute engine - will it fold?, Chris Webb has described the importance of reducing the number of visuals on a page of a Power BI report, and Imke Feldmann has described how to Split up an existing Power BI report into a Golden Dataset and a thin report.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Matt Allington (@ExceleratorBI) writes about Power BI and SharePoint – Terrible Together
- Matthew Roche (@SQLAllFather) writes about Dataflows enhanced compute engine – will it fold? and gives a Lazy Dataflows Overview
- Gilbert Quevauvilliers (@GilbertQue) blogs about Using Power Query to get data from an API that uses a Username and Password combination
- Imke Feldmann (@TheBIccountant) explains how to Retrieve header fields like response status from Web.Contents in Power BI and Power Query
- On the Towards Data Science blog, Peter Hui discusses Functions in Power BI
- Belinda Allen (@MsBelindaAllen) talks about Creating data source parameters for SQL Server in Microsoft Power BI
- On the Enterprise DNA blog, Melissa de Korte walks through Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables and covers Creating Values For Each Date Using Power Query Formula
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) explains How to Make a Copy of a Power BI DataFlow
- Jon Acampora (@excelcampus) explains How to Count Unique Rows with Power Query
- Jeff Lenning (@Exceluniversity) explains how to Create Calculated Columns without Writing Formulas
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains how to Get the Nth Records via VLOOKUP or Solve via POWER QUERY (Group By, Pivot Columns & M Code) in Excel and describes how to Split Columns Text or Numbers by Formula or POWER QUERY in Microsoft Excel
- Dhruvin Shah (@DhruvinShah16) explains how to Get Help with Spellings and Group text values using Table.AddFuzzyClusterColumn Function in Power BI
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) writes about Power BI with Teradata Report Considerations
- Avi Singh (@powerbipro) writes about Power BI: Select Top Row in Each Category?! #PowerBIPuzzle 🤔
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Patrick Leblanc (@GuyInACube) discusses Working with Time Periods in Power BI
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Role-playing dimensions in Power BI and explains How I speed up my Power BI report 5x!
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Understanding the difference between LASTDATE and MAX in DAX
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Create a link to a Power BI report with External tools functionality and writes about My beginner's DAX mistakes, ......what are yours? 😈
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes how to Supercharge KPIs with Rankings (When Trend And Target Are Not Enough) (Plus a RANKX() DAX Function Tutorial)
- On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) provides a Practical Introduction to DAX (Intro to Calculated Tables)
- Vivek Ranjan (@imvivran) covers Moving Average using DAX, p2 and blogs about DAX: KEEPFILTERS
- Amit Chandak (@amitchandak78) writes Customer Retention Part 2: Period over Period Retention
- On the Enterprise DNA blog, Brian Julius describes Using IsAfterToday for Power BI Time Intelligence Scenarios
- Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few posts: Techniques To Manage Your Data Model In Power BI, Quickly Discover When The Last Date Something Occurred Was Using DAX - MAXX Tutorial, Highlight Growth Trajectory Of A Customer Through Time - Analysis Tip For Power BI, The Importance Of Date Tables In Power BI and Power BI Dynamic Visuals Using SWITCH TRUE Logic – Visualization Technique
- Lars Schreiber (@SchreiberLars) describes Power BI User Group Hamburg: Relationships in Power BI (Alberto Ferrari)
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Filtro que cambia unidades de visualizaciones [Spanish]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Chris Webb (@cwebb_bi) discusses Power BI Report Performance And The Number Of Visuals On A Page
- Meagan Longoria (@mmarie) tells us to Stop Letting Accessibility Be Optional In Your Power BI Reports
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) talks about Creating Power BI Dashboard with Custom Images & Icons
- On the CSG Pro blog, Alice Drummond and Christian Borovac talks about The Power BI Designers Workflow: From Canvas to Creation
- Reid Havens (@HavensBI) talks about Selecting Data Points with a Lasso Tool as a Time Scrubber in Power BI
- On the Towards Data Science blog, Thiago Candido (@ogaihtcandido) writes about Truly Customizing Power BI with React, Angular, or any web framework
- Paul Turley (@paul_turley) writes Doing Power BI the Right Way: 9. Choosing the right report type: analytic or paginated
- Sam McKay (@_EnterpriseDNA) shares a few videos: Creating A Visual Tooltip In Power BI - Make Your Consumers Really Go Wow, Using Drillthrough Navigation Techniques Within Your Power BI Reports, Placing Dynamic Maps In Tooltips In Power BI - Ultimate Data Viz Technique and Why Using Good Colours Across Your Reports Is Essential In Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Create Ribbon Chart Using Charticulator inside Power BI
- On the Data Bear blog, Edward Van Der Merwe blogs about Power BI’s Q&A
- Ruth Pozuelo Martinez (@CurbalEN) talks about Making some things transparent in Power BI
- On the Visual BI blog, Padmasaran Sathiakumar delves into the Power Apps visual for Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Imke Feldmann (@TheBIccountant) describes how to Split up an existing Power BI report into a Golden Dataset and a thin report
- Kasper de Jonge (@kjonge) describes how to Refresh the table fully after setting up incremental refresh with TMSL
- Magnus Lander describes Reverse engineering Power BI templates for a complete source control solution
- On the BlueGranite YouTube channel, Angela Henry (@SQLSwimmer) writes about Unauthorized Gateways Power BI
- Adam Saxton (@GuyInACube) talks about Why is my Power BI refresh so SLOW?!? 3 Bottlenecks for refresh performance
- On the Power BI community blog, Ted Pattison (@TedPattison) provides the Power BI Dev Camp Session 2: September 24th Details
- Olivier Travers (@otravers) discusses Refreshing Power BI Datasets & Dataflows with APIs and Power Automate
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Christopher Finlan (@cmfinlan) highlights that Power Automate actions for exporting Power BI and paginated reports now available
- Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) shares the Updates to the ‘new look’ experience and release plan
- Also on the Power BI blog, Justyna Lucznik (@JustynaLucznik) writes about the Gartner Analytics and BI Virtual Bake-Off 2020: world population health analysis with Power BI
- Marc Lelijveld (@MarcLelijveld) discusses Driving a data culture with Power BI – Part 1 – What is a data culture? and highlights the Power BI icon library for Diagrams.net (draw.io)
- Matthew Roche (@SQLAllFather) writes about Data Culture: Now you’re thinking with portal
- Adam Saxton (@GuyInACube) explains how to Standardize Power BI, Power BI report design and more… (Roundup | Sept 14, 2020)
- Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE (Sept 19, 2020)
- Spencer Baucke (@JSBaucke) provides a Price Point Comparison: Tableau v Power BI
- Gregory Petrossian (@gregpetrossian) writes about the DA-100 Microsoft Exam: How to Prep and Pass
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes 5 interactions possibles entre Excel et Power BI [French]
- Neil Hambly (@Neil_Hambly) talks about the Power BI DIAD 'Dashboard-in-a-Day' (28 Sept 2020) - FREE Virtual Workshop
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.