Power BI Weekly Issue 240: 9th January 2024
Nothing official this week - so straight onto the highlighted articles. Firstly, Kurt Buhler has written a great piece titled The Quality Problem: A Call-to-Arms discussing how the lack of care taken when building solutions (in favour of faster and cheaper delivery) can be the downfall of many projects. Kurt talks about following DataOps principles as a means of helping you achieve quality outputs by delivering value in an agile, feedback-driven manner. We are huge proponents of DataOps here at endjin, and are actually delivering a workshop on the topic at this year's SQLBits conference. So if you find yourselves at SQLBits this year and you'd like to learn about practical methods to achieve DataOps principles when building solutions using Microsoft services, we'd love to see you at our workshop: DataOps: How to Deliver Data Faster and Better with Microsoft Cloud.
Elsewhere this week, Madison Giammaria has created a great way of interactively visualizing timeline data using the "Zoomable Serpentine Timeline", and my colleague Mike has started a series talking about Power Query - Where can you use it? - Power BI taking us through the many places Power Query pops up in the Microsoft ecosystem.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Ben Gribaudo (@bgribaudo) writes about M Language Specification in Review: 2023
- On the endjin blog, Mike Evans-Larah (@MikeLarah) covers Power Query - Where can you use it? - Power BI
- Cristian Angyal (@cristian_angyal) describes how to Track Changes Using Dimensions In Power Query
- Miguel Félix covers Alterações de tabelas em Direct Lake como ultrapassar? [Portuguese]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Reid Havens (@HavensBI) discusses Identifying & Optimizing DAX Patterns (Case-Study)
- Patrick Leblanc (@GuyInACube) walks through Thinking about your DAX Queries like a SQL Query in Power BI
- Bas Dohmen (@HowToPowerBI) describes 3 Ways to use Calculation Groups You Need to Know
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Adam Saxton (@GuyInACube) talks about 9 hidden gems about On-Object Editing in Power BI
- Andrzej Leszkiewicz (@avatorl) talks about SVG Map Embedded into Power BI Matrix Visual
- On the Learning Science YouTube channel, Learning Science explains how to Create a Dashboard in Power BI service
- Madison Giammaria shares a Zoomable Serpentine Timeline (Deneb)
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Soheil Bakhshi (@biinsightnz) writes about Incremental Refresh in Power BI, Part 2; Best Practice; Do Not Publish Data Model Changes from Power BI Desktop
- Chris Webb (@cwebb_bi) discusses Visualising Power BI Import Mode Refresh Job Graphs
- ,, Luca Liu describes Accessing Power BI Data with Python Using the Power BI REST API
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Chandeep Chhabra (@chandeep2786) covers Power BI Learning Path in 2024
- Kurt Buhler (@kurtbuhler) covers The Quality Problem: A Call-to-Arms
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.