Power BI Weekly
Issue #243 - 30th January 2024
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.
🛠️ Data Prep
- 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
- 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
- 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
- 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
- On the Power BI blog, Cookie McCray (@MSPowerBI) covers Power BI Report Server January 2024 Feature Summary