Power BI Weekly
Issue #18 - 30th July 2019
Most of you are probably aware of the main update this week - the new look for Power BI Service. Among numerous other changes, we now see report pages listed vertically instead of horizontally, which has had different effects on people's report real estate. What do people think of this new look/UX? The other update this week is that we now have the ability to sign up to service availability notifications, so we can react quickly if the Power BI service is down for any reason. Elsewhere, Gil Raviv has written a detailed blog on how to Find overlapping time periods using PowerQuery (Part 2).
🛠️ Data Prep
- Matthew Roche (@SQLAllFather) talks about Choosing the right tool for the job
- On the Power BI community blog, Michal Dvorak (@nolockcz) walks through a Date Dimension with Holidays in PowerQuery
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) describes how to Fill dates between dates with Power BI / Power Query
- Ulrik B. Carlsson (@crmchartguy) discusses the three main ways to get Dynamics 365 data into Power BI
🧩 Data Modeling
- Matt Allington (@ExceleratorBI) discusses The FILTER() Function in DAX
- Kasper de Jonge (@kjonge) walks through Using DAX variables in iterators
- On the SQLBI blog, Marco Russo (@marcorus) discusses Filtering the Top 3 products for each category in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about What Fields to Hide in Your Power BI Solution
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes a number of blogs: How To Calculate A Cumulative Run Rate In Power BI Using DAX, Calculate A Reverse Cumulative Total In Power BI Using DAX, Showcase The Top Result Name Within A Card Visualization Using Power BI, Show Results Up To Current Date Or A Specific Date In Power BI and on the Power BI community blog, writes CALCULATE & CALCULATETABLE - What's The Real Difference
- On the DataAP blog, Hariharan Rajendran describes how to Adjust the Total value – Conditional Total in DAX
⚙️ Report Design and Visualizations
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Find the Best, Worst, and Middle Values Using Simple Clustering with Power BI Scatter Chart
- Prathy Kamasani (@pkamasani) writes about the Power BI visual header tooltip
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains How To Create Compelling Reports & Dashboards In Power BI
- Carl de Souza (@carldesouza) explains How to Remove a Custom Visualization from Power BI Desktop
⚙️ Data Exploration
- Marc Lelijveld (@MarcLelijveld) posts Storytelling with Power BI 1/7: Provide easy navigation
- Carl de Souza (@carldesouza) explains How to Use Report Drillthrough in Power BI, talks about Cross-Report Drillthrough in Power BI and covers Passing Parameters in URL to Filter a Power BI Report
- Gil Raviv (@gilra) explains how to Find overlapping time periods using PowerQuery – Part 2
- Imke Feldmann (@TheBIccountant) describes how to Export large amount of data from Power BI desktop visuals
- Mariano Gomez talks about the Power Platform - Did you know? Mobile Apps
🚀 Deployment, Security and Operations
- On the Power BI blog, Vijay Gopalakrishnan writes that Power BI introduces service availability notifications
- Patrick Leblanc (@patrickdba) talks about Power BI Incremental Refresh – Understanding Detect Data Changes
- Paul Turley (@paul_turley) talks about Power BI Licensing
- Gilbert Quevauvilliers (@GilbertQue) discusses Setting up Version Control for my Power BI Desktop Files PBIX with no additional Cost Part 1
- Mimoune Djouallah (@mim_djo) describes Connecting PowerBI to Primavera, Implement Row Level security
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 109 - Interview with Reid Havens
🌐 General
- On the Power BI blog, Soumya Vijay (@soujay) introduces the new look for Power BI Service
- Adam Saxton (@guyinacube) talks about Power BI updates, performance and more (July 22, 2019)
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes Find Error DAX Expressions, Export Tables, Gateway and APP Documentation all in Power BI Helper July 2019 Edition