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