Power BI Weekly Issue 174: 13th September 2022
This week, a significant change in the security for Power BI Datamarts has been released, which is intoduced using the fancy terminology "AAD-based filtration for Power BI Datamarts", which in reality translates to a new tenant setting that allows you to specify the AAD groups which are allowed to create Datamarts. The other announcement this week is that the Power BI component for Vue.js applications is now available - so if you use Vue as your front-end framework, embedding Power BI just got a whole lot easier.
Elsewhere this week, my colleage James has written the first part of a series of posts around our Insight Discovery process with the brilliant article Why do data projects often fail? - explaining the pitfalls of bottom-up approaches to delivering insights and "one size fits all" data models. Also this week, Chris Webb has written the last of his Power Automate + Power BI Enhanced Refresh API blog series with the article Part 5: Getting A Dataset’s Refresh History.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Erik Svensen (@donsvensen) writes about Power Query – Create a date column from Year number and a month name
- Melissa de Korte (@_EnterpriseDNA) covers The Each Expression In Power Query / M
- On the Learning Science YouTube channel, Learning Science describes Group by in Power BI using Power Query
- Reid Havens (@HavensBI) blogs about Transforming Beast Tables into Beauty Models in Power BI
- On the Enterprise DNA blog, Gaelim Holland (@_EnterpriseDNA) describes Using Python In Power BI | Dataset And String Function
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Jeffrey Wang (@jwang_pbi) describes EVALUATEANDLOG and DAX Engine Optimizations
- Antriksh Sharma (@AntrikshShar) describes How many queries can Power BI engines cache?, and on the Enterprise DNA blog, describes How Data Segmentation Works In Power BI and blogs about The DAX Studio MEASURE Keyword: An Overview
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about DEFINE TABLE – DAX Guide
- Also on the SQLBI blog, Marco Russo (@marcorus) discusses Variables – The Whiteboard #05
- Bernat Agulló (@AgulloBernat) writes about Defining different formats for values and totals
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes 3 Steps to troubleshoot any DAX Query
- Also on the Towards Data Science blog, Salvatore Cagliari (@TDataScience) walks through Handling historisations in Power BI
- James Andrew (@MatadorSoftware) describes how to Simply Calculate Working Days in Power BI | DAX NETWORKDAYS Function
- Hima Bindu Marri (@sivahimabindu) describes the Summarize function in DAX
- Sam McKay (@_EnterpriseDNA) walks through Calculating Sales Financial Year to Date in Power BI with DAX [2022 Update] and explains how to Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Adam Saxton (@GuyInACube) discusses Are you thinking about your tooltips in Power BI?
- Chandeep Chhabra (@chandeep2786) describes how to Highlight Rows of Table in Power BI
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) explains How to visualize Python charts in Power BI Part 2
- Federico Pastor (@EnterpriseDNA_) covers Visualization Tricks with Error Bars - Lollipop Chart and Other Variations
- Bas Dohmen (@HowToPowerBI) talks about Notifications in Your Power BI Report
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Derek Jaeger (@MSPowerBI) covers Introducing AAD-based filtration for Power BI Datamarts
- Also on the Power BI blog, Noam Raveh (@MSPowerBI) announces Power BI component for Vue.js applications is now available
- Chris Webb (@cwebb_bi) walks through Calling The Power BI Enhanced Refresh API From Power Automate, Part 5: Getting A Dataset’s Refresh History
- On the Prologika blog, Teo Lachev (@tlachev) writes about Refreshing Power BI Datasets from SSIS
- Jason Himmelstein (@jasehimm) talks about Automating your formatted tables in Power BI
- Lars Schreiber (@SchreiberLars) shares a Chat with Mathias Thierbach
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the endjin blog, James Broome (@jamesbroome_) shares Insight Discovery (part 1) – why do data projects often fail?
- Reid Havens (@HavensBI) presents Insights & Learnings from the Microsoft CAT Team with Kasper De Jonge
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.