Power BI Weekly #243 - 30th January 2024
Power BI Weekly Newsletter Issue #243
powered by endjin
Welcome to the 243rd edition of Power BI Weekly! This week we have just the one "official" announcement, and that's the Power BI Report Server January 2024 Feature Summary, which includes: the ability to show visuals as tables, more styling options for column and bar charts, and greater customization for data labels. The other announcement I wanted to highlight this week comes from the Tabular Editor blog, which is that Editing semantic models through the XMLA endpoint no longer disables web authoring of the models, giving you greater flexibility over where and how you make modifications.
Elsewhere, Greg Deckler and Brian Julius have shared a video DAX Is Easy, CALCULATE Makes It Hard, describing how they believe you can simplify your DAX experience by avoiding the CALCULATE function altogether. Reid Havens has shown a neat method to Apply Custom Column Ordering for Field Parameters (Measures). And finally, Roland Szirmai has shared a two-part video describing a Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part I and Part II.
If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.
Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.
@edfreeman_ | @endjin
powerbiweekly.info | endjin.com
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Erik Svensen (@donsvensen) covers Power Query: Get the population (or any other) data from Statistics Denmark into Power BI
- Chris Webb (@cwebb_bi) walks through Understanding The “Evaluation resulted in a stack overflow” Error In Power Query In Excel And Power BI
- Chandeep Chhabra (@chandeep2786) delves into User Controlled Column Selection in Power Query
- Marcus Wegener (@PowerBIler) covers Home Assistant REST API mit Power BI Desktop abrufen [German]
- On the Tabular Editor blog, Kurt Buhler (@kurtbuhler) explains how to Connect to and transform data for a semantic model
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about What Are Power BI Datamarts And Why Should You Use Them?
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) writes about Streamlining Power BI Projects with Tabular Editor Macros: Automated Dates Table Creation
- Mark Walter (@markwaltercpa) covers Learning Evaluation Context 101
- Greg Deckler and Brain Julius (@_EnterpriseDNA) discuss DAX Is Easy, CALCULATE Makes It Hard
- Bas Dohmen (@HowToPowerBI) describes 3 Hacks to Work Faster in Power BI
- Patrick Leblanc (@GuyInACube) discusses Can you use Field Parameters with Direct Lake in Power BI?
- Luca Liu describes How to Use DAX Studio to Retrieve All Measures in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Reid Havens (@HavensBI) describes Applying Custom Column Ordering for Field Parameters (Measures)
- Meagan Longoria (@mmarie) talks about Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them
- On the Learning Science YouTube channel, Learning Science describes How to add an image in Power BI slicer visual
- Andrzej Leszkiewicz (@avatorl) describes Vega Bar Chart Example + Magic! = IBCS-Styled Chart for Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Ignacio Barrau (@ignacho_07) covers Seteo PowerBi Rest API por primera vez [Spanish]
- Morten Lønskov highlights that Editing through XMLA endpoint no longer disables web authoring of semantic models
- Roland Szirmai (@BILAnalytics) describes Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part I and Part II
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Cookie McCray (@MSPowerBI) covers Power BI Report Server January 2024 Feature Summary
Useful Links
- Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
- Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
- M language reference - Official Power Query M Reference
- PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
- DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
- DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
- Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
- Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
- Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
- Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
- Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
- Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
Tweet | Forward | Preferences | Unsubscribe
Older messages
☁️ Azure Weekly #451 - 28th January 2024
Sunday, January 28, 2024
Azure Weekly Newsletter Issue #451 powered by endjin Welcome to issue 451 of Azure Weekly. Highlights from this edition: first up in AI: LangChain Prompt Templates with OpenAI LLMs and Enable GPT
Power BI Weekly #242 - 23rd January 2024
Tuesday, January 23, 2024
Power BI Weekly Newsletter Issue #242 powered by endjin Welcome to the 242nd edition of Power BI Weekly! A handful of announcements this week. Firstly, there is a brand New Fabric certification (Beta)
Power BI Weekly #240 - 9th January 2024
Tuesday, January 9, 2024
Power BI Weekly Newsletter Issue #240 powered by endjin Welcome to the 240th edition of Power BI Weekly! Nothing official this week - so straight onto the highlighted articles. Firstly, Kurt Buhler has
Power BI Weekly #239 - 2nd January 2024
Tuesday, January 2, 2024
Power BI Weekly Newsletter Issue #239 powered by endjin Welcome to the 239th edition of Power BI Weekly, and the first of 2024! In this newsletter we're covering all content since the last edition,
Power BI Weekly #238 - 19th December 2023
Tuesday, December 19, 2023
Power BI Weekly Newsletter Issue #238 powered by endjin Welcome to the 238th edition of Power BI Weekly! This will be the final edition of 2023 as we wind down for our holiday season here at endjin.
You Might Also Like
When accelerator dreams become company nightmares
Thursday, May 2, 2024
Plus: Illinois gives Rivian incentives and AI is not SaaS View this email online in your browser By Christine Hall Thursday, May 2, 2024 Hello, and welcome back to TechCrunch PM. We have a great lineup
📱 Issue 409 - Claude Team plan and iOS app
Thursday, May 2, 2024
This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 409 Release Date May 02, 2024 Your weekly report of the most popular iOS news, articles and projects Popular
💻 Issue 415 - Hotel WiFi JavaScript Injection (2012)
Thursday, May 2, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 415 Release Date May 02, 2024 Your weekly report of the most popular JavaScript news, articles
💎 Issue 415 - Choosing the Right Audit Trail Approach in Ruby
Thursday, May 2, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 415 Release Date May 02, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 408 - Speeding up C++ build times
Thursday, May 2, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 408 Release Date May 02, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 415 - Ditch dotenv: Node.js Now Natively Supports .env File Loading
Thursday, May 2, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 415 Release Date May 02, 2024 Your weekly report of the most popular Node.js news, articles and
💻 Issue 333 - React 19 Beta
Thursday, May 2, 2024
This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 333 Release Date May 02, 2024 Your weekly report of the most popular React news, articles and projects
📱 Issue 412 - The Composable Architecture: My 3 Year Experience
Thursday, May 2, 2024
This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 412 Release Date May 02, 2024 Your weekly report of the most popular Swift news, articles and projects
💻 Issue 410 - Lessons learned after 3 years of fulltime Rust game development, and why we're leaving Rust behind
Thursday, May 2, 2024
This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 410 Release Date May 02, 2024 Your weekly report of the most popular Rust news, articles and projects
📺 How to Stop Any Smart TV From Spying On You — Single Player Games That Are Fun With Friends
Thursday, May 2, 2024
Also: Alienware's Latest Gaming Laptop is Great For Work, and More! How-To Geek Logo May 2, 2024 Did You Know The voice actors behind Mickey and Minnie Mouse throughout the 1980s, 1990s, and most