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