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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
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.