Power BI Weekly
Issue #266 - 9th July 2024
Only a single announcement this week, which is regarding the Retirement of the Windows installer for Analysis Services client libraries (which I can't imagine impacts too many of you!) So straight onto the community articles this week. Firstly, Angela Henry has shared some valuable learnings/insights/gotchas for deploying PBIP files, in her blog So You Want to Deploy Power BI Project files (PBIPs)?, Andre Fomin has given a walkthrough of a DAX Calculation for Time Series Forecast (rather than utilizing the built-in forecasting functionality), and finally, Matt Mair-Durrant has written a fun blog about his experience Learning through ‘Unconventional’ Power BI Projects, describing how he re-created "Texas Hold ‘Em" as a Power BI report.
🛠️ Data Prep
- Rick de Groot (@Rickmaurinus) explains how to Convert Unix Timestamp to Datetime in Power Query M and writes about Using Variables in Power Query M
- Patrick Leblanc (@GuyInACube) describes how to Leverage Power Query Parameters with Power BI Paginated reports
- On the Power BI community blog, Xiaoxin Sheng covers Convert Single-Column Values into Structured Rows and Columns with M query
- Lars Schreiber (@SchreiberLars) covers So analysierst Du Abfrage-Schritte in Power Query ganz einfach [German]
- Kim Leblanc (@lecfomasque) covers Guide pratique: Exploiter les modèles sémantiques et flux Power BI dans Excel [French]
- On the Power BI community blog, Sam Kumar (@inogic) explains how to Utilize Power BI Semantic Model within Power BI Reports Builder
🧩 Data Modeling
- Chris Webb (@cwebb_bi) discusses DAX Measures That Never Return Blank
- Bas Dohmen (@HowToPowerBI) describes 10 Steps to Optimize Your Data Model in Power BI
- Chandeep Chhabra (@chandeep2786) describes 5 DAX Debugging Tricks
- Avi Singh (@powerbipro) lists the Top 5 DAX Functions that Every Power BI Beginner Must Learn
- On the Business Intelligist blog, Andre Fomin (@AndreFomin) discusses DAX Calculation for Time Series Forecast
📊 Report Authoring and Interactivity
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) talks about Using atomic design in report and model development
- Reid Havens (@HavensBI) talks about Cross-Highlighting a Visual Using a Slicer?
- On the Learning Science YouTube channel, Learning Science talks about Highlight a line in a Power BI line chart without DAX
- On the Power BI community blog, Ailsa Tao discusses Slicing and dicing dates: A practical guide to the Power BI Timeline Slicer
- Also on the Power BI community blog, Wenbin Zhou delves into Display table data in HTML Content visual
🚀 Deployment, Security and Operations
- On the Power BI blog, Ancy Philip (@ancyphilip) has highlighted the Retirement of the Windows installer for Analysis Services client libraries
- Angela Henry (@SQLSwimmer) writes about So You Want to Deploy Power BI Project files (PBIPs)?
- On the Select Distinct blog, David Laws (@SelectDistLtd) writes about Understanding Power BI Gateways
🌐 General
- On the Purple Frog Systems blog, Matt Mair-Durrant (@PurpleFrogSys) covers Learning through ‘Unconventional’ Power BI Projects