Power BI Weekly Issue 73: 25th August 2020
A few announcements this week. One is that AutoML now supports applying models in PQO Function Browser, which means you can utilize ML models that have been created by other people in the same workspace, rather than just the ones you've created in the Dataflow you own. We've also been told that the On-premises data gateway August 2020 update is now available, and we've been given a summary of the recent data protection updates.
In other news this week, Daniel Otykier has described how to easily generate a dynamic measure selector using Tabular Editor, and Meagan Longoria has described how to Fun with Power BI and Color Math. Finally, Erik Svensen has shown the true flexibility that the External Tools functionality in Power BI Desktop allows, by detailing how to Connect your Power BI desktop model to Tableau Desktop. Yes, you read that right!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Power BI blog, Ancy Philip (@ancyphilip) highlights that AutoML now supports applying models in PQO Function Browser
- Chris Webb (@cwebb_bi) discusses Displaying Routes On A Map In Power BI
- Erik Svensen (@donsvensen) describes how to Dynamically reference a table via a Parameter
- Ruth Pozuelo Martinez (@ruthpozuelo) shares 5 tips to work faster and do some cool things in Power Query
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares: Row And Column Transformations In Power BI, Organizing Your Queries Into Groups In Power BI, Beginners Guide To The M Code In Power BI, Querying Data From Multiple Data Sources, Best Practices For Transforming Data In The Query Editor, Creating The Ultimate Date Table In Power BI - How To Do This Fast (Updated Code) and on the Enterprise DNA blog, How Query Dependencies Work In Power BI
- Laura Graham-Brown (@Laura_GB) describes how to Import text using examples
- Vivek Ranjan (@imvivran) discusses Table & Date Transformations using Power Query
- Reid Havens (@HavensBI) talks about Extracting Text/CSV Data Using Text From Example in Power Query
- Leila Gharani (@LeilaGharani) describes How to Calculate Hours Worked with Excel Power Query (& Properly Sum time)
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes Importez et analysez vos fichiers PDF dans Excel [French]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Daniel Otykier (@DOtykier) describes Generating a dynamic measure selector
- Darren Gosbell (@darrengosbell) describes The easy way to Generate a DAX query for all measures
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) blogs about Creating KPIs in Power BI Desktop
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares a few videos: DAX Measure in the Axis of the Power BI Report, Optimizing Power BI model size and memory by using DAX Studio metrics and VertiPaq Analyzer by Marco and Combining Tables in Power BI Union Except and Intersect in DAX
- David Eldersveld (@dataveld) writes about Jupyter as an External Tool for Power BI Desktop (Python Part 4)
- Phil Seamark (@PhilSeamark) describes Using Visual Studio Code to query Power BI
- Erik Svensen (@donsvensen) explains how to Connect your Power BI desktop model to Tableau Desktop via External Tools
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) shares a Homeschooling report using DAX
- Matt Allington (@ExceleratorBI) describes how to Copy Measures Between 2 Power BI Files
- Patrick Leblanc (@GuyInACube) describes how to Trace Excel Power Pivot using DAX Studio
- Ruth Pozuelo Martinez (@ruthpozuelo) talks about The Power BI 1000 club, are you in it? and shares DAX Fridays! #183: How to deal with multiple dates in Power BI
- On the MSSQLTips site, Kenneth A. Omorodion explains how to Improve Power BI Performance with Auto Date/Time and DAX Variables
- On the CSG Pro blog, Brian Grant (@BrianGrantBI) talks about Elements of DAX: A Ribbon Cutting
- Marcus Wegener (@PowerBIler) shares Hey Peter! DAX Quickmeasure: laufende Summe
- On the Power BI community blog, Amit Chandak (@amitchandak78) blogs about Decoding DirectQuery in Power BI Part 5: Time Intelligence with Date Table in Power BI
- On the Towards Data Science blog, Thiago Carvalho walks through Ranking Categories with Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Marc Lelijveld (@MarcLelijveld) writes about Power BI visual customization – using perspectives
- David Eldersveld (@dataveld) writes about What Happens if I Create a Report with a Vertical Layout (Portrait Mode)?
- Meagan Longoria (@mmarie) discusses Fun with Power BI and Color Math
- Mike Allen (@MikeAinOz) describes how to Trim your Outliers with the ParaTrim Custom Visual and writes about Page Tooltips with the HTML Content Custom Visual
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) talks about Period comparisons in Power BI
- On the Forsight BI blog, Zainab Balogun provides A Step By Step Guide To Creating A Custom Calendar Table In Power BI (Part 1)
- On the SQL Shack blog, Ben Richardson writes about Power BI Visuals: Working with Filters
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) writes about the Sankey Chart in Microsoft POWER BI - Termination Analysis / Reasons for Job Change - HR Analytics
- Dhruvin Shah (@DhruvinShah16) describes how to Export Current Page from Power BI Service, how to Show Rating in Power BI Using Ratings Visual by TME AG and how to Cross Filter your data by Selecting Multiple Data Point at Once Using Rectangular Lasso
- Sam McKay (@_EnterpriseDNA) describes how to Showcase Which Multi Selections Are Selected Within A Slicer - Useful Visual Technique
- Belinda Allen (@MsBelindaAllen) talks about Using a DAX function as a Report Title in Microsoft Power BI
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Seguridad a nivel de páginas con bookmarks - Parte 1 [Spanish]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that the On-premises data gateway August 2020 update is now available
- Also on the Power BI blog, Anton Fritz (@AntonFritz15) talks about the Power BI data protection updates
- Parker Stevens (@PowerBIElite) talks about Building a Power BI Admin Report
- On the Data Bear blog, Mariska Oosthuizen discusses Row-level security with Power BI
- Also on the Power BI Community blog, Greg Deckler (@GregDeckler) writes about Column Level Security
- Adam Saxton (@GuyInACube) explains how to Create a trial tenant to explore Power BI Administration
- On the Blue Granite blog, Olya Musokhranova (@OlyaMusok) writes about Power BI Governance: How to Avoid Unauthorized Workspaces and Gateways
- Dhruvin Shah (@DhruvinShah16) describes how to Block Users to try Power BI Pro Trial - Power BI Admin Tip
- Gilbert Quevauvilliers (@GilbertQue) asks Has your Power BI App been stuck in "Building App" state? I show one way to solve this.
- On the BlueGranite YouTube channel, Angela Henry (@SQLSwimmer) shares Embedding Power BI? [Premium and Embedded SKUs]
- Also on the Power BI community blog, Srishti Sharma writes about the Refresh Failure in Power BI Service with Error “Information Is Needed in Order to Combine Data”
- On the Towards Data Science blog, Arthur (@Arthur86S) describes how to Track your Azure Analysis Services Processing Times per Table
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 157 - Interview with Mike Carlo & Seth Bauer
- Adam Saxton and Patrick Leblanc (@GuyInACube) shares the REPLAY Power BI tips from the Pros – LIVE w/ Marco Russo (Aug 22, 2020)
- Matthew Roche (@SQLAllFather) talks about Data Culture: The Importance of Community
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.