Power BI Weekly
Issue #53 - 7th April 2020
Only one update this week, and that's the Power BI Service and Mobile February and March 2020 feature summary, rounding up all the most recent announcements. Elsewhere this week, Carmel Eve has continued her series on Learning DAX and Power BI – Calculated Columns and Measures, Alberto Ferrari has written about Obtaining accurate totals in DAX, and 'artemus' has written about Adding Sparklines to the Table and Matrix Visual No Custom Visuals on the Power BI Community blog.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) introduces the Data Mashup Explorer
- Chris Webb (@cwebb_bi) walks through Understanding The "The key didnt match any rows in the table" Error In Power Query In Power BI Or Excel
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Import Multiple Files Containing Multiple Sheets with Power Query
- Cédric Charlier (@Seddryck) describes Adding a table from Wikipedia to enrich your dataset with an feature of Power Query empowered by AI and writes about Transforming a cumulative time series into an event-based time series
- Imke Feldmann (@TheBIccountant) provides Tips to download files from webpages in Power Query and Power BI
- Daniil Maslyuk (@DMaslyuk) writes about Safely transforming column types in Power Query
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes Reproduire la fonction NBVAL d’Excel dans Power Query [French]
- Rafael Mendonça (@rafaelmpsantos) writes Código M para Dataset sobre Covid19 no Brasil e a Função Value.Metada [Portuguese]
- On the MSSQLTips site, Aveek Das (@avikoleum) writes about Conditional Column in Power BI
🧩 Data Modeling
- On the endjin blog, Carmel Eve (@carmel_eve) continues her series on Learning DAX and Power BI – Calculated Columns and Measures
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Obtaining accurate totals in DAX
- Patrick Leblanc (@GuyInACube) covers Setting default values using COALESCE in DAX
- Gil Raviv (@gilra) talks about COVID-19 & Time Intelligence in Power BI
- On the Excelguru blog, Ken Puls (@kpuls) talks about the PivotSleuth and Measure Tables
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes that Tabular Editor Rocks
- On La Data Web blog, Ignacio Barrau (@ignacho_07) writes 5 tips de reducción de tamaño de modelo [Spanish]
- On the Purple Frog Systems blog, Nick Edwards talks about Creating calendar tables with DAX using Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Complete Refresh For Ultimate Beginners Guide To DAX, Power BI Grouping Technique: Aged Trial Balance Using DAX, DAX Function Review: Using PARALLELPERIOD In Power BI, How to Compare Current Sales to Previous Best Month in Power BI, Cumulative Totals Based On Monthly Average Results In Power BI, How To Set Up Your Financial Data in Power BI, Budget vs Actual vs Last Year – Financial Reporting Tips, Power BI Budgeting Technique: Allocating Monthly Budgeting Sensitivity Table and on the Power BI community blog, covers Customer Analysis Deep Dive - How to Complete Quality Analysis
⚙️ Report Design and Visualizations
- On the Power BI community blog, artemus blogs about Adding Sparklines to the Table and Matrix Visual No Custom Visuals
- On the xViz blog, Bhupinder Singh discusses the xViz Radar/Polar Chart – Power BI Custom Visual Key Features
⚙️ Data Exploration
- On the BI Elite blog, Parker Stevens (@PowerBIElite) writes about 3 Ways to Scale Down Outliers in Power BI
- On the Power BI community blog, Michal Dvorak (@nolockcz) provides a Showcase: How Much Toilet Paper with What-If Parameters
- Marcus Wegener (@PowerBIler) writes about Power BI reports as Screensavers
🚀 Deployment, Security and Operations
- Chris Webb (@cwebb_bi) describes Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler
- On the Power BI community blog, Marcus Wegener (@PowerBIler) writes about Incremental Refresh with Subqueries
- Brett Powell (@BrettPowell76) discusses Parallel Power BI Scripts
- Gilbert Quevauvilliers (@GilbertQue) answers Which Groups can be used to set Permissions in Power BI
- Nicky van Vroenhoven (@NickyvV) writes My First Look at Read/Write XMLA Endpoints in Power BI Premium
- Soheil Bakhshi (@biinsightnz) writes Power BI Governance, Good Practices, Part 1: Multiple Environments, Data Source Certification and Documentation
- Prathy Kamasani (@pkamasani) talks about PowerBI Auto Recovery
- On YouTube, Christian Wade (@_christianWade) talks about Power BI Premium as a superset of Analysis Services: the XMLA endpoint | Community Webinars
🌐 General
- On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) shares the Power BI Service and Mobile February and March 2020 feature summary
- Adam Saxton (@GuyInACube) walks through Getting Started with Power BI Desktop in 5 steps
- Also on the Power BI blog, Arun Ulag (@arunulag) describes How Public Agencies Keep Communities Informed on COVID-19 with Power BI