Power BI Weekly
Issue #145 - 22nd February 2022
It's Power BI Feature Summary time, and there are a few lovely features landing this month. First of all we have the new mobile visual formatting pane (preview) which is a very welcome addition for those of us who create mobile versions of our reports. Next, the Dynamic M Query Parameters feature now supports SQL Server and more relational data sources (e.g. most flavours of SQL Server, Oracle, Teradata), which is awesome - you'll see a couple of blogs about this below and learn about how it can help you. We've also been told that the Power BI Windows app now has a dark mode, which is great, but most of you are probably waiting for the Power BI Desktop dark mode, which unfortunately still doesn't exist. Sorry.
Elsewhere this week, Imke Feldmann has described how to Transform multiple columns at once with reference to existing column in Power Query, Brian Julius has described How to Create And Debug Custom Functions In Power BI, and Chandeep Chhabra has show how to use buttons and bookmarks to Turn On / Off Tooltips In Power BI.
🛠️ Data Prep
- On the Prologika blog, Teo Lachev (@tlachev) discusses Power BI Dynamic M Query Parameters Reloaded
- Chris Webb (@cwebb_bi) covers TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQuery
- Imke Feldmann (@TheBIccountant) covers Transforming multiple columns at once with reference to existing column in Power Query
- Brian Julius (@_EnterpriseDNA) describes How To Handle Stacked Data In Power BI and describes How to Create And Debug Custom Functions In Power BI
- Ben Gribaudo (@bgribaudo) discusses Custom Connectors: Components & Packaging Formats
- Gašper Kamenšek (@ExcelUnplugged) writes about Why You Should Know Power Query – Part 2: Split
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) describes the Differences between INT and CONVERT in DAX
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: RADIANS, DEGREES – DAX Guide, ISBLANK – DAX Guide and SIN, COS, ASIN, ACOS, TAN, ATAN, COT, ACOT – DAX Guide
- Daniil Maslyuk (@DMaslyuk) talks about Power BI Antipatterns #3: Table functions
- On the SQL Server Central blog, Adam Aspin describes DAX table functions for paginated reports: Part 1
- Ruth Pozuelo Martinez (@CurbalEN) talks about Nearest location based on Lat/Long in Power BI and talks about Sorting the Y-axis in Power BI
- Ilgar Zarbaliyev (@IlgarZ) talks about What-If Parameters (Enterprise Analytics Summit)
📊 Report Authoring and Interactivity
- On the Power BI blog, Michal Foster Heldy (@Michal36040600) explains how to Create stunning, mobile-optimized Power BI reports with mobile layout’s new visual formatting pane (Preview)
- Fowmy Abdulmuttalib (@ExcelFort) describes How to Make Elegant In Page Navigation with Power BI Bookmark Navigator
- Reid Havens (@HavensBI) talks about Effective use of Bookmarks and Buttons (with Ben Ferry - Power BI Guy)
- James Andrew explains how to Create Powerful Custom Power BI KPI Cards
- Chandeep Chhabra (@chandeep2786) describes how to Turn On / Off Tooltips In Power BI
- Sam McKay (@_EnterpriseDNA) presents Application-Like Report Development Techniques (Enterprise Analytics Summit)
- Arnaud Gastelblum (@LazySna1l) writes about Power BI: Duplicate of Duplicate – The best way to test your reports and measures
- Pat Mahoney (@mahoneypa) talks about Deneb - Unpivot your data... inside the visual!
- Jason Cockington (@JasonCockington) writes about Plotting 2 Columns on the Legend of a Chart
- On the Learning Science YouTube channel, Learning Science talks about Dynamic Image in Power BI
- Dhruvin Shah (@DhruvinShah16) talks about the Scorecard Visual in Power BI
- Carl de Souza (@carldesouza) blogs about Embedding Power Automate Flows Inside Power BI
🚀 Deployment, Security and Operations
- Adam Saxton (@GuyInACube) discusses Do we need more Power BI Premium Capacity?
- Hafeez Jimoh (@jimohhafeezco) explains How to Share and Publish to the Web in Power BI
- Dhruvin Shah (@DhruvinShah16) discusses Power BI Goals - Goal Level Permissions
- Reid Havens (@HavensBI) presents Uncovering Secrets and Mysteries in your Power BI Tenant (with Benni De Jagere)
🌐 General
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) highlights the Power BI February 2022 Feature Summary
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show