Power BI Weekly Issue 177: 4th October 2022
No announcements at all this week, so we'll jump straight into the highlighted articles. First of all, Alberto Ferrari has recorded a 20 minute tutorial on the ins and outs of RANKX in DAX (a function surprisingly difficult to get going with). Mara Pereira has written an article describing Everything you need to know about Bookmarks in Power BI, describing the different use-cases and options you can configure when using the feature. Finally, although not directly related to Power BI, Olivier Travers has written a helpful overview of Row Level Security, Object Level Security, Data Masking and their Business Use Cases.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Antriksh Sharma (@AntrikshShar) explains How to Create Date Table in Power BI with Records, List.Generate, & List.Accumulate
- Melissa de Korte (@_EnterpriseDNA) describes Introducing The Extended Date Table 2.0 - Power Query M Function
- Fowmy Abdulmuttalib (@ExcelFort) explains how to Transform Multiple Columns Based On Other Columns In Power Query With A Single Step
- On the Excelguru blog, Ken Puls (@kpuls) explains how to Connect to Spotify using Power Query and explains how to Get Album and Track Data from Spotify
- On the Learning Science YouTube channel, Learning Science explains How to get XML file in Power BI
- Ignacio Barrau (@ignacho_07) covers [PowerQuery] Capturar errores en un request http [Spanish]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Introducing RANKX in DAX
- Gilbert Quevauvilliers (@GilbertQue) describes How to use the Power BI DAX Debug Output when testing EvaluateAndLog
- Bas Dohmen (@HowToPowerBI) talks about the New OFFSET Function in DAX
- Lars Schreiber (@SchreiberLars) covers So kalkulierst du durchschnittswerte über zeitreihen mit DAX [German]
- Greg Deckler (@GregDeckler) describes How To Guarantee Sort Order In DAX
- Sam McKay (@_EnterpriseDNA) describes Complex 'What If' Analysis Example In Power BI Using DAX [2022 Update] and describes Layering Multiple 'What If' Scenarios In Power BI - Advanced DAX Concepts [2022 Update]
- Reid Havens (@HavensBI) talks about What's new in DAX Studio 3? (with Darren Gosbell)
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Michael Felix covers Diferença dinâmica de datas com Field Parameters [Portuguese]
- Also on the Power BI community blog, Polly covers How to achieve 'or' logic but not 'and' logic with slicers
- Mara Pereira (@datapears) covers Bookmarks in Power BI - Everything you need to know
- Ruth Pozuelo Martinez (@CurbalEN) covers Stars rating (with half stars) using Power BI icons only
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) walks through Designing Power BI reports for accessibility
- On the Enterprise DNA blog, Gustaw Dudek (@EnterpriseDNA_) writes about Dashboard Layout Design Techniques
- Andrzej Leszkiewicz (@avatorl) shares Power BI Theme JSON tricks
- Leila Gharani (@LeilaGharani) describes the Power BI Aquarium - A Cool Visual to Add to Your Reports
- Mike Allen (@MikeAinOz) announces ParaDown Power BI Custom Visual is available and working again
- On the Perficient blog, Ankit Jangle (@Perficient) describes how to Change Power Apps Visuals and Data fields in Power BI
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) explains how to Create A Blank Report Using Power BI Report Builder
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Olivier Travers (@otravers) covers Row Level Security, Object Level Security, Data Masking: What Are the Business Use Cases?
- On the Power BI community blog, Ted Pattison (@TedPattison) announces Power BI Dev Camp Session: Modern React-JS Development with App-Owns-Data Embedding
- Darren Gosbell (@darrengosbell) writes about Power BI Report Server – fixing “Can’t upload this report”
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains how to Implement Incremental Refresh for non-Query Folding sources in Power BI within a Datamart
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Enterprise DNA blog, Alex Badiu (@BadiuAlexandru) writes about Effective Data Storytelling: Asking The Right Questions
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 207
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.