Power BI Weekly
Issue #72 - 18th August 2020
This week the Power BI Desktop August 2020 Feature Summary has been shared, which highlights new preview support for rectangular lasso select for data points in line, area and scatter charts, DirectQuery support for Q&A visuals, and many other features. We've also been told about changes to headers and navigation in the Power BI Mobile apps, and how to Build cross-platform solutions that connect to Power BI datasets.
Elsewhere this week, Rui Romano has described how to Copy Report Layout between two PBIX files, Rahim Zulfiqar Ali has shown us an Animated Bar Chart (Race Style) using custom visuals, and Greg Deckler has updated the useful post on Power BI Licensing in Pictures.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) blogs about Power Query Geography And Geometry Functions In Power BI And Excel
- Adam Saxton (@GuyInACube) talks about 3 HIDDEN tricks in the Power Query editor for Power BI and Excel
- Daniil Maslyuk (@DMaslyuk) describes Grouping text values in Power BI
- Gil Raviv (@gilra) describes how to Import & Combine multiple PDF files from WHO
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Import Data from a PDF to Excel
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) shares some Power Query tips for every Power BI Developer
- Matthew Roche (@SQLAllFather) blogs about the Power BI dataflows PowerShell scripts on GitHub
- On the CSG Pro blog, Reza Rad (@Rad_Reza) talks about Moving from Power Query in Power BI Desktop to Dataflow
- Gilbert Quevauvilliers (@GilbertQue) describes How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes Working On Your Data Inside The Power BI Query Editor
- Vivek Ranjan (@imvivran) shares the BI Simplified Webinar 1, p3: Date Transformations using Power Query, covers Power Query QuickBytes 1: Self Join and Power Query Quickbytes 2: Summary Statistics using Data Preview
- Dhruvin Shah (@DhruvinShah16) describes How to Call Power BI Rest APIs from Power BI Desktop – Register your Power BI Application – Part One and describes how to Call Power BI Rest API with Dynamic Access Token From Power BI Desktop Power BI Rest API Part Two
- Marcus Wegener (@PowerBIler) shares Hey Peter! Gruppieren nach in Power BI (Power Query) [German]
- ,, Lars Schreiber (@SchreiberLars) writes Das Kundenalter zum Zeitpunkt des Kaufes ermitteln [German]
- On the Power GI blog, David Bachrach highlights the Dataflows in Government Webinar
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) announces DAX Patterns second edition and writes about Default calculation item in calculation groups
- Adam Saxton (@GuyInACube) describes how to Easily convert your Excel Power Pivot model to Power BI
- Ruth Pozuelo Martinez (@ruthpozuelo) describes how to Open your Power BI Desktop model in Excel with just one click (two methods) and shares DAX Fridays #182: Why your Power BI tables sometimes filter, sometimes don't
- On the Power BI community blog, Amit Chandak (@amitchandak78) writes Power BI Continuous Streak - With One-Day Break
- On the CSG Pro blog, Darren Goonawardana describes What If Analysis and Data Modeling in Power BI
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Para que sirve “marcar como tabla fecha”? [Spanish]
- On the dev.to blog, Kevork Keheian (@KKeheian) describes Writing DAX Formulas
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few blogs: Inventory Management Reports To Show Trends In Sales, CRM Sales Analytics In Power BI, Business Metrics In Power BI Reports To Achieve Logistics Insights, Showing Sales Growth In Power BI Reports and Top Power BI Solutions and Features
📊 Report Authoring and Interactivity
- Rui Romano (@RuiRomano) describes how to Copy Report Layout between two PBIX files
- Parker Stevens (@PowerBIElite) discusses Highlighting the Current User's Data
- Belinda Allen (@MsBelindaAllen) blogs about Changing the Report Background, walks through Turning Off Auto-Size Column Width and covers Changing Interactions between visuals
- On the MSSQLTips site, Scott Murray describes some Power BI Tooltips Enhancements
- Laura Graham-Brown (@Laura_GB) provides a Q&A Synonyms Update
- On the Enhansoft blog, Leonard Suares (@SuaresLeonard) explains How to Create a Power BI Date Range Slicer
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about the Animated Bar Chart Race Style in Microsoft POWER BI - Get Hex Codes and Create Custom Visuals
- Matthew Peterson (@mattpetersonbi) writes an Azure Maps Visual UPDATE
🚀 Deployment, Security and Operations
- On the Power BI community blog, Greg Deckler (@GregDeckler) shares Power BI Licensing in Pictures - Updated
- Dhruvin Shah (@DhruvinShah16) discusses Which License do I need to Embed Power BI Report to Power Apps
- Reza Rad (@Rad_Reza) talks about the Read-only license for Power BI
- Adam Saxton (@GuyInACube) shares YES!!! BLOCK Classic Workspaces in Power BI. Even from Microsoft Teams!
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) describes how to Hot Swap Report Connections – External Tools
- Reid Havens (@HavensBI) describes Splitting a Power BI (PBIX) File into a Dataset and Lean Report File
- Also on the Power BI community blog, Akshiita Srivastava writes about a Missing Report in Power BI Service Although Publish Is Successful From Desktop
- Also on the Power BI community blog, Sumana Biswas writes Incremental Refresh is failing in PBI Service - We couldn't parse the input provided as DateValue
- Also on the Power BI community blog, Sheetal Shetty explains how to Analyze in Excel – How to Deal With an XML Parsing Error
- Also on the Power BI community blog, Srishti Sharma discusses Power BI Report Throws an Error Principalobjectattributeaccessset During the Refresh
🌐 General
- On the Power BI blog, Sujata Narayana shares the Power BI Desktop August 2020 Feature Summary
- Ruth Pozuelo Martinez (@ruthpozuelo) reviews the Power BI Desktop Update - August 2020 in 6 minutes
- Also on the Power BI blog, Kay Unkroth blogs about Building cross-platform solutions that connect to Power BI datasets
- Also on the Power BI blog, Maya Shenhav describes how to Re-imagine headers and navigation in the Power BI Mobile apps
- On the Power BI blog, Kelly Kaye (@MS_KellyKaye) says Congratulations to the Featured Data Stories Gallery contributors for June and July!, writes Power BI, Thank You For 5 Years, T-Shirt Give Away Results and says Join Us! Monthly Power BI Dev Camp is Here! Starting Thursday August 27, 2020
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights Power BI Dev Camp - Developing for Power BI with .NET Core
- Also on the Power BI blog, Debraj Ghosh writes that Humana Enhances its Healthcare Data Usage with Power BI and Azure
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 155 - News & other updates
- Adam Saxton (@GuyInACube) talks about Block Power BI Classic Workspaces, Analyze in Excel and more… (Roundup | Aug 10, 2020)
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) shares One Tool to Install them ALL
- Mimoune Djouallah (@mim_djo) explains how to Connect Streamlit to Power BI service using XMLA end point
- Lars Schreiber (@SchreiberLars) talks with Matt Allington about building a consulting business on Power BI
- Matthew Roche (@SQLAllFather) writes about Data Culture: Picking Your Battles
- Devin Knight (@knight_devin) shares the Power BI Monthly Digest – August 2020 with Matt Peterson
- On the Towards Data Science blog, Jenny Dcruz writes Excel, Tableau, Power BI… What should you use?
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) lists the Top 5 Power BI Features That Saved Me This Week