Power BI Weekly
Issue #144 - 15th February 2022
Couple of official Power BI blogs this week, one of which is the announcement of the General availability of Export Power BI report to file API (so you can put those Power Automate flows into production), and there's been a case-study into the Inforiver visual - No-Code Partner Innovation for End-User Self-Service inside Power BI which has cropped up a few times in this newsletter.
Elsewhere this week, Paul Waller has described How to Create Custom Buttons in Power BI to make your reports look & feel extra slick, Salvatore Cagliari has described a nice way to achieve Dynamic Time Intelligence in DAX, Alberto Ferrari has described how to Analyze related geography attributes in different tables in Power BI when utilizing conformed dimensions, and Patrick Leblanc tells us How do I get my Excel users to use Power BI?
🛠️ Data Prep
- Gašper Kamenšek (@ExcelUnplugged) writes about Why You Should Know Power Query – Part 1: Fill
- Pat Mahoney (@mahoneypa) describes An easy way to handle Daylight Savings Time in Power Query
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) describes YTD Flags in Power Query
- Kreimir Ledinski (@Exceed_ltd) writes about Dynamic Coalesce in PowerQuery
- On the MSSQLTips site, John Miner (@JohnMiner3) covers Leveraging the Power Query activity within Azure Data Factory
- Also on the MSSQLTips site, Scott Murray describes Power BI Designing with Diagrams
- Delia Fernandez (@datachant) provides an Introduction to Power BI Dataflows
- On the Enterprise DNA blog, George Mount (@_EnterpriseDNA) writes about Three Ways To Use R Script In Power BI and covers Using R In Power BI - An Exploration
- David Abu (@DavidAbu_) discusses Cleaning Multiple Files in Power BI
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) shares [Updated] Best practices using SUMMARIZE and ADDCOLUMNS
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Analyzing related geography attributes in different tables in Power BI – Unplugged 42, describes ISEMPTY – DAX Guide and delves into ROUND, ROUNDDOWN, ROUNDUP, TRUNC – DAX Guide
- Nazarena Tossolini writes about Cohort Análisis [Spanish]
- Bas Dohmen (@HowToPowerBI) shares Understand how to analyze by week in Power BI
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Dynamic Time Intelligence in DAX made easy
- Brian Julius (@_EnterpriseDNA) talks about Addressing Troublesome Time Intelligence Issues In Power BI and explains How To Dynamically Select Starting Period For Any Chart In Power BI
- Fowmy Abdulmuttalib (@ExcelFort) presents a webinar: Why Do My DAX Formulas Return Wrong Results?
- Bernat Agulló (@AgulloBernat) shares some One-click calculation groups for your toolbelt
- Edward Pollack (@EdwardPollack) describes Vertipaq optimization and its impact on columnstore compression
📊 Report Authoring and Interactivity
- On the Power BI blog, Ranin Salameh (@rsalameh) writes about Inforiver – No-Code Partner Innovation for End-User Self-Service inside Power BI
- On the endjin blog, Paul Waller (@Crashbangwaller) describes How to Create Custom Buttons in Power BI
- Allison Kennedy (@ExcelAllison) writes about Power BI Formatting
- Pat Mahoney (@mahoneypa) presents Getting Started With the Deneb Visual in Power BI and talks about Getting Help With the Deneb Visual in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) shares Powerful storytelling technique in Power BI from storytelling by data book
- Reid Havens (@HavensBI) presents Faster Reporting and Insights Using InfoRiver with Matt Allington
- On the Learning Science YouTube channel, Learning Science talks about Designing Power BI Report for Mobile Devices
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) blogs about Introduction to the latest features of Power BI Desktop
- Hima Bindu Marri (@sivahimabindu) talks about Key Performance Indicators in Power BI
- Patrick Leblanc (@GuyInACube) describes How to get Secure Images in Power BI Reports
🚀 Deployment, Security and Operations
- On the Power BI blog, Alon Baram announces General availability of Export Power BI report to file API
- On the Power BI Tips and Tricks blog, the Explicit Measures podcast team (@PowerBITips) discusses Certified vs. Promoted Dataset?
- Dhruvin Shah (@DhruvinShah16) talks about Power BI Goals - Create connected goals in Power BI
- Chris Webb (@cwebb_bi) describes how to Speed Up Power BI Refresh By Increasing The Amount Of Memory On Your On-Premises Data Gateway Machine
🌐 General
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Feb 12, 2022)
- Reid Havens (@HavensBI) presents Starting your journey with Power BI with Gaston Cruz
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) writes about 8 Mistakes I made to Start Learning Power BI
- Patrick Leblanc (@GuyInACube) presents How do I get my Excel users to use Power BI?