Power BI Weekly
Issue #218 - 1st August 2023
A bit of a quiet one this week - the only official blog is the announcement of Low code authoring of paginated reports, which is a huge feature bringing the quick and easy creation of paginated reports over Power BI datasets directly within the Power BI Service - great to see the positive comments. Otherwise this week, Kurt Buhler has released a couple of blogs on data viz, namely around Bar Charts and Basic Line Charts in Power BI, showing the wealth of visual possibilities with a bit of measure magic. Finally, Angela Henry has written about the various Options for Data Source Credentials When A Service Principle Owns A Power BI Dataset - none of which is perfect by itself - just shows the importance of weighing up your technical options (given the limitations) and deciding what's best for your scenario.
Finally, my colleague Barry has shared the first of a five-part series aimed at helping technology leaders assess the strategic implications of Microsoft Fabric. His first blog asserts that Microsoft Fabric Is A Socio-Technical Endeavour where people and processes are just as important the tech. Do take a look!
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about Exploring Power BI Import Mode Throughput With Log Analytics, Part 3: Throughput Variations During A Refresh
- Kurt Buhler (@kurtbuhler) shares Format Power Query in Power BI (Updated)
- Ben Gribaudo (@bgribaudo) blogs about Privacy Levels in Dataflows: Click to Continue? (Or Not!)
- Chandeep Chhabra (@chandeep2786) explains how to Make Queries Unbreakable: 5 Awesome Hacks | Power Query Tricks
🧩 Data Modeling
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) covers Changing perspective on your data in Power BI
- On the Power BI community blog, Arul covers Comparing Selected Month Sales against other months Sales using INDEX DAX function
- On the Learning Science YouTube channel, Learning Science discusses Bring a column value from one table to another table in Power BI | LOOKUPVALUE function in Power BI
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) describes Advanced Top N Filter Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Nirupama Srinivasan (@MSPowerBI) covers Low code authoring of paginated reports
- Bernat Agulló Roselló (@AgulloBernat) covers Making Single Measure Stacked Column Chart Keep Multi-Measure Color
- Kurt Buhler (@kurtbuhler) writes about Bar Charts in Power BI and describes Basic Line Charts in Power BI
- Bas Dohmen (@HowToPowerBI) talks about Quick Guide: Field Parameters in Power BI, explains how to Create a Unique Slicer | New Card Visual + Slicer in Power BI and describes Quick Power BI Report Background Design
- Andrzej Leszkiewicz (@avatorl) talks about The Spaghetti (monster) Plot
- Vahid Doustimajd (@VahidDoustiM) explains How to Add Animated Effects to Power BI Buttons
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) delves into [PowerBi][UI] Animated Cards with HTML and CSS
🚀 Deployment, Security and Operations
- Gilbert Quevauvilliers (@GilbertQue) describes Power BI – Testing Row Level Security (RLS) for multiple users in Excel
- Angela Henry (@SQLSwimmer) describes Options for Data Source Credentials When A Service Principle Owns A Power BI Dataset
- Soheil Bakhshi (@biinsightnz) describes Integrating Power BI with AzureDevOps (Git), part 1: Cloud Integration
- Reid Havens (@HavensBI) talks about Better Together with Power BI in Microsoft 365 (with Christine Payton)
🌐 General
- Audrée Pellerin (@lecfomasque) covers Réussir votre implantation Power BI: le sponsor exécutif [French]