Power BI Weekly
Issue #98 - 23rd February 2021
In the past week, Microsoft has again been named a Leader in the 2021 Gartner Magic Quadrant for Analytics and BI Platforms, which will probably not come as a surprise to any of you reading this newsletter. But well done to the team nonetheless - maintaining the stronghold in this space is no easy feat. Arun Ulag has also written a blog Data insights without limit, security without compromise, which highlights how Power BI handles your data from a security perpective, talks about upcoming features, and shares a new whitepaper to deep dive into the specifics. Do take a look.
Elsewhere this week, we've been told from the Power BI team that the .NET Core support for Analysis Services client libraries is GA, supporting both .NET Core 3.1 and .NET 5, and the SQLBI team has created a new website: DAX.do, which can act as a playground to help you improve your DAX code. It's free, public, and comes preconfigured to a sample Contoso Database - all you need to do is start writing queries against the model! Great work from the team.
Finally, Miguel Escobar has open-sourced a great Power BI REST API Connector which you can just install and start using straight-away, and Chandeep Chhabra has described how you can use Calculation Groups to Use Measures in the Columns of a Matrix Visual - a neat workaround.
🛠️ Data Prep
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) shares a Power BI REST API Connector
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Dataflows: a remedy for slow data sources in Power BI
- Soheil Bakhshi (@biinsightnz) shares a Quick Tip: Renaming All Tables Columns in One Go in Power Query
- Chris Webb (@cwebb_bi) talks about Query Folding On SQL Queries In Power Query Using Value.NativeQuery() and EnableFolding=true
- Chandeep Chhabra (@chandeep2786) writes about Dynamic Data Types in Power Query
- Bas Dohmen (@HowToPowerBI) writes about Pivot errors in Power BI | How to fix it
- Ruth Pozuelo Martinez (@CurbalEN) explains How to make power query comments visible in the formula bar
- Leila Gharani (@LeilaGharani) explains How to Merge Excel Files with Different Headers in Power Query | List.Accumulate
- Greg Philps discusses Data Loading And Transformation - Power BI Best Practices
- Pat Mahoney (@HoosierBi) talks about Power BI - Shift N Fill Data Pattern
- On the Data Bear blog, Edward Van Der Merwe provides a Beginners Guide to Functions in Power BI
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights Power BI Dev Camp 25 March, 2021 - Session 8 - Deep Dive into M Programming
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) introduces Introducing DAX.do
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Letter case-sensitivity in DAX, Power BI and Analysis Services
- Chris Webb (@cwebb_bi) describes Implementing Data (As Well As Metadata) Translations In Power BI
- Patrick Leblanc (@GuyInACube) talks about the Best Practice Analyzer in Tabular Editor for your Power BI Dataset and discusses Working with Slowly Changing Dimensions in Power BI
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about a Dynamic axis in Power BI—DAXis
- Ruth Pozuelo Martinez (@CurbalEN) writes DAX Fridays #197: Why you need to test your DAX measures in different contexts
- Reid Havens (@HavensBI) discusses Calculation Groups with Kane Snyder
- Hima Bindu Marri (@sivahimabindu) explains how to Calculate Running Totals in Power BI using DAX
- Sam McKay (@_EnterpriseDNA) provides an Introduction To The ALL Function In Power BI
- Mudassir Syed Rashid Ali shares Calculation Groups To Your Rescue - DAX Tutorial
- Brian Julius explains how to Write Smarter DAX With Dummy Variables - Power BI
- Vivek Ranjan (@imvivran) shares the BI Simplified Webinar: Say Hello to PowerPivot
- Reza Rad (@Rad_Reza) talks about Composite Model in Power BI - By Kasper de Jonge
- Ilya Rzhevskiy (@ilya_sb1) writes about Calculated Groups – comparisons and calculated columns in a pivot directed by slicers
📊 Report Authoring and Interactivity
- Chandeep Chhabra (@chandeep2786) describes how to Use Measures in Columns of a Matrix Visual
- On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) describes how to Sort-By Columns in Power BI
- Reid Havens (@HavensBI) discusses Charticulator Custom Visuals with Daniel Marsh-Patrick
- The Power BI team (@MSPowerBI) explains how to Get started using Power BI product guidance
🚀 Deployment, Security and Operations
- On the Power BI blog, Kay Unkroth highlights that .NET Core support for Analysis Services client libraries is GA
- Marc Lelijveld (@MarcLelijveld) describes how to Trigger a single table to refresh in the Power BI Service
- Brett Powell (@BrettPowell76) writes about XMLA-Based PBI Dataset Refresh Automation
- On the Power BI community blog, Pragati Jain talks about the Lineage View in Power BI
- Just Blindbæk (@justblindbaek) blogs about Extracting the Power BI activity log with Data Factory
- John White (@diverdown1964) talks about Using Power BI Incremental Refresh with Azure Data Explorer
- On the Power BI Tips and Tricks blog, Anthony Escobedo discusses Power BI Version Control – Ready to use solution
🌐 General
- On the Power BI blog, Arun Ulag (@arunulag) announces that Microsoft named a Leader in the 2021 Gartner Magic Quadrant for Analytics and BI Platforms and talks about Data insights without limit, security without compromise
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) highlights The Dice Game
- Allison Kennedy shares the Data Story of the Month: Employee Sick Leave
- Dhruvin Shah (@DhruvinShah16) explains how to Build your first Power BI Report and Dashboard using Dataverse Table
- Djordje Medakovic (@DjMedakovic) writes about Facebook Ads data in Power BI a Fresh look