Power BI Weekly
Issue #37 - 10th December 2019
Only one announcement this week, and that's the Power BI Service and Mobile October and November 2019 feature summary. Elsewhere, Mike Carlo has written about the impact of too many visuals on a report page in the blog More Visuals Mo Problems, Kasper de Jonge has described how to Build your custom visual with Charticulator and Power BI, and Gil Raviv has shared some interesting thoughts on the statement: "Power BI is a Data Visualization Tool". It's much more than that, folks. But I'm sure you all knew that anyway!
🛠️ Data Prep
- On the RADACAD blog, Leila Etaati (@leila_etaati) discusses Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query
- Also on the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases and describes how to Pre Concatenate List of Values in Power BI using Power Query
- On the Power BI community blog, Michal Dvorak (@nolockcz) writes about a Custom Data Connector: How to Deploy and Test
- Mimoune Djouallah (@mim_djo) explains how to Normalize multiple progress files using PowerQuery
- Gilbert Quevauvilliers (@GilbertQue) writes about the AAS Processing Error "Error returned: 'M Engine error: Microsoft.Data.Mashup; Token Comma expected"
- Chandeep Chhabra (@chandeep2786) writes about Dynamic Column Names in Power Query
- On the MSSQLTips site, Semjon Terehhov writes about Indexing SQL Server for Power BI workloads
- On the Blue Granite blog, Josh Crittenden (@Jcrit44) provides A Tour of Artificial Intelligence Features in Power BI
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about a Same Period Last Year to Date DAX Calculation in Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Understanding eager vs. strict evaluation in DAX
- Also on the SQLBI blog, Marco Russo (@marcorus) describes Comparing with previous selected time period in DAX and walks through Updating tabular models for Ordinal property in calculation groups
- On the Prologika blog, Teo Lachev (@tlachev) provides some Tips for Extended Events
- Chandeep Chhabra (@chandeep2786) provides a DAX Data Modeling Tip Card
- Mimoune Djouallah (@mim_djo) describes how to Load Raster tiles to PowerBI Data Model using R
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few blogs: Discover Unique Insights Using Power BI TOPN Function, Automatically Find Your Top 3 Salespeople Per Region Using DAX In Power BI, Create Compelling Power BI Insights Fast For Financial Analysis and Power BI Customer Attribution Analysis Using Advanced DAX
- On the Data Bear blog, Edward Van Der Merwe covers Data Preparation Part 6 – Star Schema Power BI
⚙️ Report Design and Visualizations
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes More Visuals Mo Problems
- Kasper de Jonge (@kjonge) explains how to Build your custom visual with Charticulator and Power BI
- Soheil Bakhshi (@biinsightnz) provides some Quick Tips: Line Chart and Area Chart Conditional Formatting in Power BI
- Carl de Souza (@carldesouza) checks out the Personalized Visualizations Pane in Power BI
- David Eldersveld (@dataveld) writes about Animated GIF Backgrounds in Power BI
- Prathy Kamasani (@pkamasani) describes How I designed a layered donut chart
- On the Purple Frog Systems blog, Jon Fletcher talks about Creating Power BI Layouts using PowerPoint
- Bibin Bastian (@bibinbastian) writes about Power BI Integration with SharePoint Online
🚀 Deployment, Security and Operations
- On the Power BI community blog, Mahak Rathore provides a Step-by-Step guide to update Microsoft Gateway used for Power BI and other apps v1
- Chris Webb (@cwebb_bi) discusses Testing Performance Of Power BI Reports In The Browser, Part 1 and Part 2
🌐 General
- On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) covers Power BI Service and Mobile October and November 2019 feature summary
- Gil Raviv (@gilra) writes about the statement: "Power BI is a Data Visualization Tool"
- Paul Turley (@paul_turley) has A Conversation with Ásgeir Gunnarsson about Power BI in the Enterprise
- On the Power BI community blog, Nicky van Vroenhoven (@NickyvV) writes that A Form, a Flow and a Power BI Streaming Dataset Walk into A Bar - Part 1
- On the Power BI community blog, Fred Kaffenberger (@freder1ck) writes about Ask Amir Anything: Self-Service Composite Models in 2020