Power BI Weekly
Issue #25 - 17th September 2019
After my highlighting of the lack of news from the Power BI team in last week's edition, they provided us no less than 6 blogs in the space of a week! Here they all are:
- Power BI Dataflows September 2019 Feature Summary
- Power BI Service and Mobile August 2019 feature summary
- Power BI Desktop September 2019 Feature Summary
- Power BI Developer community August 2019 update
- Learn more about the new innovations in Power BI starting October 2019
- Announcing the Microsoft Business Applications October Virtual Launch Event
Since that's already a lot to digest, I'll just highlight one article this week. An interesting blog written by Ike Ellis has been shared on Charles Sterling's blog, where Ike has gone into detail describing how to create Updateable Power BI Reports with PowerApps.
🛠️ Data Prep
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) discusses Episode 117 Interview with Chris Webb
- On the Power BI community blog, Michal Dvorak (@nolockcz) provides some Transitive Closure in Power Query - Improvements
- Patrick Leblanc (@GuyInACube) talks about Native Query: Be careful when using in Power BI
- On the Power BI blog, Mohammad Ali (@mohaali45) provides the Power BI Dataflows September 2019 Feature Summary
- On the Excelguru blog, Ken Puls (@kpuls) discusses Power Query Challenge 7 – Phone Words
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Custom Format Fields and Measures in Power BI and provides Some Methods for Calculating Quarter in DAX for Power BI
- Chris Webb (@cwebb_bi) highlights some Power BI Custom Format String Examples, Part 1: Numbers
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) talks about Calculating Percent Profit Margins Using DAX in Power BI and explains how to Calculate Financial Year To Date FYTD Sales In Power BI using DAX
- Patrick Leblanc (@GuyInACube) presents Troubleshooting DAX performance in Power BI Desktop? Clear the model cache!
- On the SQLBI blog, Marco Russo (@marcorus) discusses the VertiPaq Analyzer 2.0 Preview 1
⚙️ Report Design and Visualizations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) talks about Using Filter Fields & Visual Interactions To Create Compelling Visualizations In Power BI
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) explains How to Create a Pareto Chart in Power BI Desktop
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes about the Dual Y-Axis Line Chart
- On the PowerPivotPro blog, Rob Collie (@robcolli3) provides some Free, Interactive NFL Stats
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) talks about Data Visualizations in our daily lives – Part 1 and Data Visualizations in our daily lives: Tables – Part 2
- Ike Ellis (@ike_ellis) discusses Creating Updateable Power BI Reports with PowerApps
🚀 Deployment, Security and Operations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains how to Implement Row Level Security In Your Power BI Models
- On the MSSQLTips site, Scott Murray discusses Power BI Row Level Security
- On the Power BI community blog, Nandu Krishna (@NanduKrishnaVS) writes about Dynamic Row Level Security
- Gil Raviv (@gilra) provides a Power BI Template Apps Exploration Tool
- Matt Allington (@ExceleratorBI) walks through Preventing & Managing Refresh Failures in Power BI
- Adam Saxton (@GuyInACube) talks about Power BI Premium: What is V-CORE pooling?!?
- Brett Powell (@BrettPowell76) writes about Power BI Premium Registered Servers
- Imke Feldmann (@TheBIccountant) explains how to Compare Power BI files with Power BI Comparer tool
- Gilbert Quevauvilliers (@GilbertQue) explains How to enable the Power BI On-Premise Data Gateway to Stream data immediately
- On the edureka blog, Komal discusses Power BI Architecture: How to work on Data Security
🌐 General
- On the Power BI blog, Miguel Martinez (@maikelson) explains how to Learn more about the new innovations in Power BI starting October 2019 and the Microsoft Business Applications October Virtual Launch Event
- Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) provides the Power BI Service and Mobile August 2019 feature summary
- Also on the Power BI blog, Amanda Cofsky (@MissAmandaN) provides the Power BI Desktop September 2019 Feature Summary
- Also on the Power BI blog, Amit Shuster provides the Power BI Developer community August 2019 update
- Adam Saxton (@GuyInACube) talks about Microsoft Flow Power Query, Power BI mobile update and more (Roundup | September 9, 2019)
- Devin Knight (@knight_devin) and Manuel Quintana present the Power BI Monthly Digest – September 2019
- Erik Svensen (@donsvensen) blogs about Adding keyboard shortcuts to your favourite buttons in powerbi