Power BI Weekly

Issue #13 - 25th June 2019

Only one announcement this week, which is the new ability to Bring Your Own Key (BYOK) Preview for Power BI Premium - a great new capability for those who'd like more control over the keys that encrypt their data. Elsewhere, Marco Russo has introduced Calculation Groups (a way to group related, generic measures), and Brett Powell has written about Power BI Artifact to Workspace Relationships, creating a data model from the numerous different Power BI artifacts for easier governance by Power BI Admins.

🛠️ Data Prep

Chris Webb (@cwebb_bi) provides a pointer to a Detailed Article On The Power Query Formula Firewall And Data Privacy Settings
Matthew Roche (@SQLAllFather) provides two quick tips: Creating "data workspaces" for dataflows and shared datasets and Restricting access to linked entities in Power BI dataflows
Marc Lelijveld (@MarcLelijveld) explains how to Inform your end-users by embedding dataflow refresh times in your Power BI reports
On the Excelguru blog, Ken Puls (@kpuls) highlights Power Query Challenge 5 and provides One Solution to Power Query Challenge 5
On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) talks about Error handling (IFERROR) in Power BI / Power Query
Daniil Maslyuk (@DMaslyuk) highlights the Power Query text replacement competition

🧩 Data Modeling

On the SQLBI blog, Marco Russo (@marcorus) introduces Calculation Groups
On the RADACAD blog, Reza Rad (@Rad_Reza) writes Budget vs Actual: Zero Complexity Model in Power BI and Budget vs. Actual Model in Power BI: Calculations and DAX
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) provides a Basket Analysis Introduction – Best Practice Tips For Power BI Using DAX, describes How To Organize Your Power BI Models – Best Practice Tips and covers Power BI Tips & Techniques For Accounting & Finance
Chandeep Chhabra (@chandeep2786) explains How to correctly use IF in Power BI DAX
Devin Knight (@knight_devin) talks about Power BI Interview Questions – Volume 02 – Data Shaping with Erin Ostrowsky

⚙️ Report Design and Visualizations

On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 105 - June 2019 Power BI Desktop Update
On the RADACAD blog, Leila Etaati (@leila_etaati) provides an Introduction to Charticulator: Create Custom Visual – Part 1
David Eldersveld (@dataveld) writes Build a Basic Power BI Accordion Filter (or Don't)
On the MSSQLTips site, Siddharth Mehta (@siddhumehta) blogs about Time Series Analysis in Power BI using Timeline Visual
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) explains how to Make Custom Visuals with no Code
On the Visual BI blog, Sathya Narayana Karthikeshwar highlights 7 Things to Know About Paginated Reports in Power BI

⚙️ Data Exploration

Patrick Leblanc (@patrickdba) provides 5 tips for Power BI Paginated reports
On the PowerPivotPro blog, Rob Collie (@robcolli3) provides some Power BI Brain Candy: Value Above Replacement

🚀 Deployment, Security and Operations

On the Power BI blog, David Magar announces the Bring Your Own Key (BYOK) Preview for Power BI Premium
Brett Powell (@BrettPowell76) writes about Power BI Artifact to Workspace Relationships
Matthew Roche (@SQLAllFather) provides another Quick Tip: Making self-documenting Power BI apps
Gilbert Quevauvilliers (@GilbertQue) describes Embedding Word Documents into new App Experience within Power BI

🌐 General

Matt Allington (@ExceleratorBI) writes about the Power BI APIs for Non-Programmers
On the Power BI blog, Miguel Martinez (@maikelson) talks about MBAS 2019 On-Demand Featured Sessions: Power BI Roadmap and Vision
Adam Saxton (@guyinacube) talks about the MBAS updates – Power BI Desktop, Certified Datasets and more (June 17, 2019)
On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) writes a 2019 Microsoft Business Application Summit Retrospective