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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Audrée Pellerin (@lecfomasque) covers Réussir votre implantation Power BI: le sponsor exécutif [French]
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.