Power BI Weekly Issue 56: 28th April 2020
This week, the Power BI team has announced the new certification capabilities for dataflows, providing the capability to promote or certify your dataflow in your organization - like you can already do for datasets. We've also been told that the On-premises data gateway April 2020 update is now available.
Elsewhere this week, Gilbert Quevauvilliers has illuminated a small tip that's news to me, and that's How to refresh selected (not all) tables in Power BI Desktop. Kasper de Jonge has described How to change the dataset script in Power BI desktop. Finally, James has written about an often overseen part of Power BI solutions - testing. As James mentions, validating business rules and security boundaries within reporting solutions is just as important as in more "traditional" software applications, especially when the data being shown is highly sensitive. Read his blog on Testing Power BI Dataflows using SpecFlow and the Common Data Model.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- Ben Gribaudo (@bgribaudo) writes about The Data Mashup Binary Stream: How Power Queries Are Stored and describes Comparing M Code Between Files
- On the endjin blog, James Broome describes Testing Power BI Dataflows using SpecFlow and the Common Data Model
- Erik Svensen (@donsvensen) blogs about PowerQuery – Easily Copy all queries from a PBIX to Excel and vice versa
- Gilbert Quevauvilliers (@GilbertQue) describes How to refresh selected (not all) tables in Power BI Desktop
- Ignacio Barrau (@ignacho_07) writes about Pandas and SQL to M [Spanish]
- Sophie Marchand (@Mon_Cher_Watson) writes Identifiez vos écarts de facturation en 1 minute, avec Power Query!
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the endjin blog, Carmel Eve (@carmel_eve) walks through Learning DAX and Power BI – Related Tables and Relationships
- Matt Allington (@ExceleratorBI) describes how to Edit/Replace Code Inside All DAX Measures Using Tabular Editor
- On the SQLBI blog, Marco Russo (@marcorus) walks through Checking model size using VertiPaq Analyzer in DAX Studio
- Chandeep Chhabra (@chandeep2786) discusses Slab / Tired Calculations using DAX and explains how to Calculate Fiscal Week in Power BI
- Kasper de Jonge (@kjonge) describes How to change the dataset script in Power BI desktop
- Patrick Leblanc (@GuyInACube) shares 3 tips for using the MODEL VIEW in Power BI Desktop
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few blogs: Format Your DAX Formulas Easily With Our New DAX Clean Up Tool, Fixing Incorrect Totals Using DAX Measures In Power BI, RANKX Considerations – Power BI And DAX Formula Concepts, Implementing DAX Measure Groups Into Your Reports – A Power BI Modeling Review, ,, Pareto Analysis: Who Are The Top 20% Customers and on the Enterprise DNA blog, Break Out New Customer Sales – Advanced Power BI Insights
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the PowerPivotPro blog, Evan Rhodes writes about Self-Documented Reports (aka the FAQ Page)
- Prathy Kamasani (@pkamasani) shares some Power BI reports landing page tips and tricks: Tiles using, Images, Power BI buttons, hover effects and all the above
- On the Visual BI blog, Jiwon Jeon explains how to Visualize Microsoft Power BI Project Data in Power BI using Gantt Custom Visual
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) delves into Power BI Reporting Techniques: Setting Up Application Like Reports
- On the Towards Data Science blog, Kenneth Infante (@iamkennethcpa) covers Recreating the Gapminder Plot in PowerBI
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the Prologika blog, Teo Lachev (@tlachev) describes Sentiment Analysis with Power BI
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, Yarden Albeck announces the new certification capabilities for dataflows
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that the On-premises data gateway April 2020 update is now available
- Chris Webb (@cwebb_bi) walks through Calling The Power BI Export API From Power Automate, Part 1: Creating A Custom Connector and Part 2: Creating A Flow That Exports A Paginated Report To A CSV File
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Lauren Faber describes How Rockwell Automation Drives a Data Culture
- On YouTube, The Power BI team (@MSPowerBI) talks about the Microsoft Power BI | 2020 release wave 1 overview
- Adam Saxton (@GuyInACube) talks about Power BI Reports, governance and updates... (Roundup | April 20, 2020) and talks about 9 things to know before getting into Power BI (Or, really anything)
- Adam Saxton (@GuyInACube) discusses the Free Training: Power BI Paginated Reports in a Day
- Adam Saxton and Patrick Leblanc (@GuyInACube) provide a REPLAY: April 2020 Power BI recap
- The Knee-Deep in Tech team (@KneeDeepinTech) present Episode 116
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.