Power BI Weekly

Issue #35 - 26th November 2019

Last week was quite a quiet one by the Power BI team's standards. 2 announcements: we've been told about that we can now Upgrade classic workspaces to the new workspace experience, but this feature is currently in public preview, so use with caution! We've also been provided with the Power BI Developer community November 2019 update which includes a bunch of cool updates, including the ability to dynamically bind a report to a new dataset across a workspace.

Elsewhere, Bill Anton has answered a common question Do all visuals on a Power BI report generate queries?, and, relating to the workspace upgrade announcement above, Brett Powell has described how we can Find V1 Workspace Owners.

🛠️ Data Prep

On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Get The Error Count with the Profiling Data of Power BI Data Table using Power Query and describes how to Change the Source of Power BI Datasets Dynamically Using Power Query Parameters
On the Power BI community blog, Michal Dvorak (@nolockcz) provides a How-To: Unusual Formatted String to Record in Power Query
Gil Raviv (@gilra) writes about Deep Thought on Power BI AI
Matthew Roche (@SQLAllFather) provides a Power BIte: Creating dataflows by attaching external CDM folders
On the Data Bear blog, Edward Van Der Merwe writes Data Preparation Part 4 – Transforming Columns
Marcus Wegener (@PowerBIler) blogs about Streaming sensor data to Power BI

🧩 Data Modeling

On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes a number of blogs: Power BI Visuals: Change Size By Ranking Logic, Comparing Calculated Columns And Measures In Power BI, Customer Analysis In Power BI Reviewing Performance Over Time, Working With Iterating Functions In DAX and Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Optimizing conditions involving blank values in DAX
Chris Webb (@cwebb_bi) blogs about the Performance Overhead Of Visual Totals On Dimension Security In Analysis Services Multidimensional
On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Calculating Total, and Percentages in a Row-Level Security Power BI Model
Patrick Leblanc (@GuyInACube) describes how to Analyze your Power BI data model without the PBIX file

⚙️ Report Design and Visualizations

Bill Anton (@SQLbyoBI) wonders Do all visuals on a Power BI report generate queries?
On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Enhance the Card Visual in Power BI with Conditional Formatting
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) describes how to Scale a Visual
Prathy Kamasani (@pkamasani) highlights the DataLounge video with AltiusData talking about Storytelling and PowerBI

⚙️ Data Exploration

On the MSSQLTips site, Eduardo Pivaral (@EduardoDBA) writes about Azure Text Analytics and Power BI

🚀 Deployment, Security and Operations

On the Power BI blog, Lukasz Pawlowski (@lukasztweets) writes that Upgrade your classic workspaces to the new workspace experience public preview is rolling out
Brett Powell (@BrettPowell76) explains how to Find V1 Workspace Owners
Paul Turley (@paul_turley) blogs about Setting up Power BI project Team Collaboration & Version Control
Mimoune Djouallah (@mim_djo) discusses Power BI Incremental refresh using Python or R
Matthew Roche (@SQLAllFather) talks about the Power BI Premium Dedicated Capacity Load Assessment Tool on GitHub
Gilbert Quevauvilliers (@GilbertQue) writes Did you know you can throttle the CPU and Memory on the Power BI On-Premise Data Gateways?

🌐 General

On the Power BI blog, Alon Baram provides the Power BI Developer community November 2019 update
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 127 - November 2019 Power BI Desktop Update
Devin Knight (@knight_devin) discusses Power BI Monthly Digest with Manuel Quintana – November 2019
Patrick Leblanc (@GuyInACube) writes about 5 AWESOME things about the new ribbon in Power BI Desktop
On the Power BI community blog, KHamilton explains how to Get more from your business intelligence investments with cloud analytics