Power BI Weekly
Issue #94 - 26th January 2021
Again, Pretty much radio silence again from the Power BI team, but that's to be expected in January. Next month we'll be hit with a few of the year's first updates - maybe they'll start flowing through next week. In any case, this week Paul Turley has continued the comprehensive "Doing Power BI the Right Way" series, talking about an often confusing decision Power Query in Dataflows or Power BI Desktop? Along related lines, Imke Feldmann has provided a Workaround to connect to Power BI dataflows from Power Query in Excel, since the native Dataflows (nor ADLS Gen2 connector) isn't available in Excel. Elsewhere, Alberto Ferrari has introduced the new DAX DEFINE COLUMN statement in queries, taking us through a number of useful examples to get us going, and Pragati Jain has described how to Schedule Automated Data Exports from Power BI using a simple R/Python Script, so that your data is exported when your datasets are refreshed up in the Power BI Service.
🛠️ Data Prep
- Patrick Leblanc (@GuyInACube) explains how to Do I need to be an expert in Power Query M?
- Paul Turley (@paul_turley) writes about Doing Power BI the Right Way: 4. Power Query in Dataflows or Power BI Desktop
- Asanka Padmakumara (@asanka_e) compares Power BI Dataflow vs Azure Data Factory Power Query
- Imke Feldmann (@TheBIccountant) provides a Workaround to connect to Power BI dataflows from Power Query in Excel and blogs about Exception reporting and management for missing fuzzy matches in Power BI
- Matt Allington (@ExceleratorBI) blogs about Shaping vs Modelling in Power BI
- Wolfgang Strasser (@wstrasser) shares the Connectors in Power Query (reference link)
- On the SQL Server Central blog, Victor Sánchez Jáuregui talks about Power Query or SQL Server? Which, when and why
- Dhruvin Shah (@DhruvinShah16) explains How to connect CDS or Dataverse Table in Power BI
- Brian Julius writes about Combinations And Permutations In Power Query
- Melissa de Korte describes How To Create An Alternating 0-1 Pattern In The Date Table
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) introduces DEFINE COLUMN in DAX queries
- Adam Saxton (@GuyInACube) talks All about DAX and data modeling in Power BI… (Roundup | Jan 18, 2021)
- On the Prologika blog, Teo Lachev (@tlachev) highlights a couple of Calculation Group Gotchas
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) writes about Constant Currency Analysis (Power BI DAX Tutorial)
- Gilbert Quevauvilliers (@GilbertQue) explains How to create DirectQuery (Composite) using an existing Power BI Dataset and a local Excel file
- Philipp Lenz (@lenz_philipp) writes Need to translate the Adventure Works Tabular Model into German?
- Reid Havens (@HavensBI) talks about DAX Studio with Darren Gosbell
- Lars Schreiber (@SchreiberLars) writes Wie Du „unregelmäßige Hierarchien“ in Power BI und Power Pivot nutzen solltest [German]
- Hima Bindu Marri (@sivahimabindu) talks about the Difference between Direct Query and Import in Power BI and describes how to Sort month name chronologically in Power BI Desktop Power BI tutorial for beginners
📊 Report Authoring and Interactivity
- Adam Saxton (@GuyInACube) explains how to Create your first Power BI report
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) writes about the Custom KPI card in Power BI
- Mike Allen (@MikeAinOz) shares that ParaTaskCard Updated and Published
- On the SQL Shack blog, Ben Richardson describes Waterfall Charts and Combined Visuals
- On the Excel Basement YouTube channel, Excel Basement Private Limited describes How to Embed Microsoft POWER BI Dashboard in Microsoft PowerPoint Presentation (2 Methods)
- Hima Bindu Marri (@sivahimabindu) talks about Creating maps and formatting them
- Greg Philps explains How To Add Button Interactivity In Your Power BI Reports
🚀 Deployment, Security and Operations
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains How to organize workspaces in a Power BI environment
- Also on the RADACAD blog, Asanka Padmakumara (@asanka_e) describes How to stop your Power BI tenant becoming a dataset swamp
- On the Power BI community blog, Pragati Jain describes how to Schedule Automated Data Exports from Power BI using a simple R/Python Script
- Chris Webb (@cwebb_bi) walks through Comparing The Performance Of Importing Data Into Power BI From ADLSgen2 Direct And Via Azure Synapse Analytics Serverless
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes How to capture SQL queries generated by Power BI
- Adam Saxton (@GuyInACube) presents 🔴 Power BI Deployment, Governance and Q&A with Melissa Coates – LIVE (Jan 23, 2021)
- Philipp Lenz (@lenz_philipp) writes Safe money, time and performance Or use Power Automate, Sentiment Analysis and Power BI with incremental refresh.
- On the Prologika blog, Teo Lachev (@tlachev) talks about Rogue Q&A Queries
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Y si hiciéramos Login y RLS en Publish To Web… [Spanish]
🌐 General
- On the Power BI blog, Kelly Kaye (@MS_KellyKaye) writes Join Us! Power BI Dev Camp! Thursday 28 January, 2021
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares Data Culture, Data Literacy, Data everything – how does this relate to Power BI - by Tom Martens
- Ruth Pozuelo Martinez (@CurbalEN) shares COVID Vaccine Tracker Part1: Get data from github and schedule refresh it, DAX Fridays 194: COVID Tracker Part2: Modeling and getting the last value of an accumulated list and COVID Vaccine Tracker Part3: Tweet daily Power BI reports with Power Automate flow