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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the MSSQLTips site, Eduardo Pivaral (@EduardoDBA) writes about Azure Text Analytics and Power BI
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 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
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.