Power BI Weekly Issue 153: 19th April 2022
The April 2022 Feature Summary has landed, with drill actions for tooltips being added to matrix, line and area charts, Dynamic M query parameters becoming GA, and various "updating" permissions being added to Power BI Goals. Separately, we've also been given another heads up that Classic Workspace Upgrade Starts on April 27, 2022 (so ping your admins if they don't already know!). Elsewhere this week, Amit Chandak has shared a useful series of videos doing side-by-side walkthroughs of Power BI and Tableau, labelled Migrating from Tableau to Power BI, and Bas Dohmen has shown a way of using calculation groups to get 100% Control of Data Labels in Power BI.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- James Andrew describes how to List All M Functions within Power Query with the Shared Keyword Improve your Power BI Skills
- Miguel Félix writes Linguagem M referenciação dentro da mesma consulta [Portuguese]
- On the Prologika blog, Teo Lachev (@tlachev) writes about Power BI Dataflows vs ADF Mapping Data Flows
- On the Power BI community blog, Vijay Verma describes Number.ExcelBin2Dec in Power Query Language M and describes how to Extract Domain from URLs in Power Query Language M
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes Power BI Filtering Techniques For Tables
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Filter context in DAX, and shares a few tutorials: POISSON.DIST – DAX Guide, RANK.EQ – DAX Guide and CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT – DAX Guide
- Also on the SQLBI blog, Marco Russo (@marcorus) describes Dictionary size in Tabular models reported by VertiPaq Analyzer
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes the TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter
- On the Power BI community blog, Amit Chandak (@amitchandak78) walks through Migrating from Tableau to Power BI
- Rick de Groot (@Rickmaurinus) covers Creating Ordinal Numbers 1st, 2nd, 3rd in Power BI
- Bas Dohmen (@HowToPowerBI) describes 100% Control of Data Labels in Power BI
- Daniil Maslyuk (@DMaslyuk) presents Power BI Antipatterns #7: ISBLANK
- Matt Allington (@ExceleratorBI) describes Exploding Measures using Tabular Editor 3
- On the Power BI Community blog, Chenwu Zhu describes how to Understand the Filter Context and How to Control it
- Adam Saxton (@GuyInACube) explains How to get a DATE TABLE easily in Power BI
- Chris Webb (@cwebb_bi) describes Filtering An Excel Cube Function Report By A List Of Manually-Entered Values
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the CSG Pro blog, Daniel Marsh-Patrick (@the_d_mp) discusses Deneb: An Alternative Approach for Custom Visual Development
- James Andrew writes about Powerful Data Visualization with Power BI Best Practices dataviz dashboard
- Pat Mahoney (@mahoneypa) describes TopN and Others with Deneb in Power BI and discusses Column Switching With Deneb in Power BI
- On the Learning Science YouTube channel, Learning Science talks about Conditional Formatting Tips and Tricks in Power BI
- On LaDataWeb, Bruno Zurita writes Documentar tu informe dentro del informe [Spanish]
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 shares a Heads up: Classic Workspace Upgrade Starts on April 27, 2022
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights the Power BI Dev Camp April 28th, 2022: Report Authoring and Customization with Power BI Embedding
- Mimoune Djouallah (@mim_djo) discusses Using DuckDB with Power BI
- On the Power BI blog, Vanessa Fournier describes Built-in AI in Power BI, New Teams App, and Real-time Big Data with Hybrid Tables
- On the Purple Frog Systems blog, Jon Fletcher describes how to Download Power BI Reports using PowerShell
- Patrick Leblanc (@GuyInACube) wonders Are you backing up your Power BI Dataset?
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Reid Havens (@HavensBI) writes about Tabular Editor C# Scripts & Calculation Groups (with Bernat Agulló)
- On the Power BI Community blog, Eason Fang shares some Tips for handling common scenarios of employee attendance sheets
- Hima Bindu Marri (@sivahimabindu) shares a video: Power BI beginner questions | M or DAX or Power Query? What to learn?
- On the MSSQLTips site, Scott Murray covers Power BI Desktop - The What, Why and How
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (April 16, 2022)
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI April 2022 Feature Summary
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.