Power BI Weekly
Issue #65 - 30th June 2020
Just the one announcement this week - that's the General Availability (GA) of enhanced connectivity for Snowflake, which "includes the ability to connect to Snowflake without an on-premises data gateway, as well as support for Azure Active Directory (AAD) authentication and SSO in DirectQuery mode in the Power BI service". Not bad compatibility! Elsewhere this week, I've written a blog about How to dynamically choose the correct font colour based on a background colour in Power BI tables using a nice bit of colour theory, Parker Stevens has shared part 2 of the "Building a Power BI Admin View" series around obtaining refreshable access tokens, and John White has shown how to Connect to Application Insights and Log Analytics with Direct Query.
This week I'd also like to highlight Power BI Days, which is a free conference run by the community, for the community. In fact, Power BI Days consists of numerous free-to-attend virtual and in-person community events, held all across the world. Additionally, if you're wanting to organize an event, that's possible too - it's still free, and comes with support. Do visit the website to check it out!
🛠️ Data Prep
- On the Power BI blog, Kay Unkroth announces the General Availability (GA) of enhanced connectivity for Snowflake
- John White (@diverdown1964) explains how to Connect to Application Insights and Log Analytics with Direct Query in Power BI
- Marc Lelijveld (@MarcLelijveld) explains how to Bring existing tables to Power BI dataflows with Tabular Editor
- Ben Gribaudo (@bgribaudo) writes about Privacy Levels: Context Is Key
- Imke Feldmann (@TheBIccountant) describes how to Extract pattern string and numbers from text using List.Accumulate in Power Query
- Ruth Pozuelo Martinez (@ruthpozuelo) describes how to Split multiple columns into rows without errors in Power Query and describes how to Insert text anywhere in a cell without adding a new column using the Power Query User Interface.
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) wonders Will Power BI recognize Defined Names in Excel
- Chandeep Chhabra (@chandeep2786) describes how to Unstack Rows in Separate Columns
- Also on LaDataWeb, Ignacio Barrau (@ignacho_07) writes about [PowerQuery] Descomprimir archivos .zip [Spanish]
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Distinguishing HASONEVALUE from ISINSCOPE
- Phil Seamark (@PhilSeamark) writes DAX 1-Column Fusion Pt 2
- Matt Allington (@ExceleratorBI) describes Calculating Business Hours Using DAX
- Chris Webb (@cwebb_bi) talks about Naming Tables, Columns And Measures In Power BI
- Soheil Bakhshi (@biinsightnz) shares some Quick Tips: Time Dimension with Time Bands at Seconds Granularity in Power BI and SSAS Tabular
- Ilya Rzhevskiy (@ilya_sb1) writes about Subtotal Counters within Groups and Subgroups for Calculated Columns
- Vivek Ranjan (@imvivran) shares a number of blogs: DAX: Data Modeling with RELATED & RELATEDTABLE, Multiple Dates on the same axis: DAX USERELATIONSHIP, DAX: LOOKUPVALUE, Adding Calendar Table in Power Pivot, SWITCH DAX measures in Power Pivot, DAX Iterators: The X-Factors and ,, Using Rank for Comparison
- Ruth Pozuelo Martinez (@ruthpozuelo) asks Is your Power BI data on Google? Here is how to fix it... and shares Dax Fridays #177: My DAX measure is incorrect, how do I troubleshoot it?
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains How to Use Time and Date Dimensions in a Power BI Model
- Patrick Leblanc (@GuyInACube) says that It's time to free your Power BI data model! We freed up 83%!?!
- Rafael Mendonça (@rafaelmpsantos) describes the Power BI ERROR - O modelo não tem uma expressão nomeada chamada ... [Portuguese]
📊 Report Authoring and Interactivity
- On the endjin blog, Ed Freeman (@edfreeman_) describes How to dynamically choose the correct font colour based on a background colour in Power BI tables.
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) walks through Creating A Gantt Chart In Power BI Using Matrix and explains how to Update Your Power BI Dashboard – Power BI Online Service
- Patrick Leblanc (@GuyInACube) says that Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop
- Reid Havens (@HavensBI) writes about Conditional Page Navigation for Buttons in Power BI
- Gilbert Quevauvilliers (@GilbertQue) describes Getting the correct Date Format to be displayed in the Power BI Service
- Avi Singh (@powerbipro) presents Talk Power BI LIVE Q&A (June 26, 2020)
- Dhruvin Shah (@DhruvinShah16) lists the Top 10 Features for Power BI Decomposition Tree AI Visualization
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) describes how to Convertir un visuel de matrice en calendrier utile [French]
- Mike Allen (@MikeAinOz) writes about a PageStar Custom Visual, The Start of an Idea
🚀 Deployment, Security and Operations
- Parker Stevens (@PowerBIElite) describes Building a Power BI Admin View Part 2: Obtaining a Refreshable Access Token
- Adam Saxton (@GuyInACube) walks through Understanding the basics of Power BI Premium
- Dhruvin Shah (@DhruvinShah16) describes how to Set Up Power BI Data Gateway to Connect On-Premise Data Sources and discusses Things you should consider before installing Power BI Data Gateway
- Teo Lachev (@tlachev) writes about A Gateway to Hell
🌐 General
- Adam Saxton (@GuyInACube) writes about What to FOCUS on with DAX and more... (Roundup | June 22, 2020)
- Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE Hangout (June 27, 2020)
- On the Excel Basement YouTube channel, Moez Ali (@moezpycaretorg1) describes how to Implement Classification and Regression in POWER BI using PyCaret
- Gil Raviv (@gilra) shares the COVID-19 dashboard in Power BI: Offset the curve
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) shares some Power BI Best Practices
- Lars Schreiber (@SchreiberLars) covers Power BI User Group Hamburg: IBCS-Compliant Reporting in Power BI (Andrej Lapajne)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 151 - Visuals, Apps, Licensing & Picks
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) discusses Sharing Power BI Reports with the World - 5 Things to Know with John White