Power BI Weekly

Issue #64 - 23rd June 2020

Only a couple of announcements this week. There's now a New way of getting apps, whereby all your organizational apps and apps shared on AppSource are now in one, unified view. We've also been provided with a Licensing and roadmap update for Power BI Report Server, where the main bit of news is that Microsoft is now allowing SQL Server Enterprise customers with software assurance to deploy Power BI Report Server on Azure VMs for production use, by leveraging their Azure Hybrid Benefit. A great enabler for those orgs undergoing digital transformation and migrating to the cloud.

Elsewhere this week, Alberto Ferrari has written about 7 reasons DAX is not easy (I'm sure no one will be arguing with that), David Eldersveld has described Four Core Differences Between the Tableau and Power BI Data Models, and Rob Collie has finished a three part series discussing Power BI and Paginated reports, concluding that they're Better Together.

I'd also like to highlight a great new training resource for those wanting to learn more about Power BI Desktop, and that's the new edition of Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User by Adam Aspin, which is now available to buy. With content ranging from initial data load all the way through to the report enhancement tools such as Bookmarks and Drill-through - Adam spares no detail in this comprehensive resource about Power BI Desktop. Be sure to check it out!

Finally, you may notice that the newsletter categories have ever-so-slightly changed this week, so be sure to take a look through and familiarize yourself with the new setup, and let me know if you have any feedback.

🛠️ Data Prep

Ruth Pozuelo Martinez (@ruthpozuelo) describes how to Trim column headers with spaces in between words in one step in Power Query
Erik Svensen (@donsvensen) blogs about Converting xls files to xlsx file using powerautomate and avoid the pitfalls in powerquery using xls
Ilya Rzhevskiy (@ilya_sb1) explains how to Connect Excel to PowerBI Desktop
Chris Webb (@cwebb_bi) shares a Video: Power BI Data Privacy Settings Deep Dive
Jon Acampora (@excelcampus) explains How to Import PDF Files into Excel with Power Query
On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) blogs about Web Scraping in Power BI and walks through Using M to Create a Custom Function for Web Scraping in Power BI
On the SQL Shack blog, Aveek Das (@avikoleum) talks about Getting started with parameterized Power BI reports
Asanka Padmakumara (@asanka_e) explains How to fit an elephant into a fridge Only for Power BI Users
Carl de Souza (@carldesouza) writes about New Features – Common Data Service, SQL and Power BI!!!
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes [PowerQuery] Descomprimir archivos .gzip [Spanish]
Adam Saxton (@GuyInACube) wonders How do you get a REFRESH DATE in your Power BI report???
Dhruvin Shah (@DhruvinShah16) explains how to Add Comment or Description for your Power Query Steps
On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) posts a number of videos: An Introduction on 6 types of Joins in Power Query / POWER BI, Left Outer Join & Right Outer Join in POWER QUERY / POWER BI with Example, Left Anti Join & Right Anti Join in POWER QUERY / POWER BI, Full Outer Join & Inner Join in POWER QUERY / POWER BI and Append data techniques in different scenarios in POWER QUERY / POWER BI

🧩 Data Modeling

David Eldersveld (@dataveld) writes about Four Core Differences Between the Tableau and Power BI Data Models
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about 7 reasons DAX is not easy
On the Power BI community blog, Greg Deckler (@GregDeckler) writes that You Can Do MAGIC!
Also on the Power BI community blog, Vivek Ranjan (@imvivran) writes about Virtual Relationship with TREATAS
Chandeep Chhabra (@chandeep2786) explains how to Calculate MAX from Multiple Columns or Measures
Marc Lelijveld (@MarcLelijveld) explains how to Migrate Analysis Services models to Power BI using Tabular Editor
On the Purple Frog Systems blog, Jeet Kainth writes about SSAS Tabular Calculation Groups – avoid using SELECTEDMEASURE or ISSELECTEDMEASURE
Ruth Pozuelo Martinez (@ruthpozuelo) presents DAX Fridays #176: Speed up your Direct Query reports with a single click (kindof....)
Avi Singh (@powerbipro) shares a video: DAX Time Intelligence Functions for Beginners with Jeffrey Wang
Reza Rad (@Rad_Reza) covers Time Intelligence calculations with Power BI and provides a Data modelling 101 with Power BI
On the RADACAD YouTube channel, Owen Auger (@Ozeroth) covers DAX and data modelling – basic building blocks for business analytics
Daniil Maslyuk (@DMaslyuk) blogs about Understanding model recalculation in Power BI and writes about thte New DAX functions June 2020
Darren Gosbell (@darrengosbell) highlights the DAX Studio 2.11.1 Release
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) details 5 règles en or pour déboguer une mesure en DAX [French]

📊 Report Authoring and Interactivity

On the Power BI community blog, Didier Terrien describes Automatic Translation of Visual Labels
On the Prologika blog, Teo Lachev (@tlachev) talks about Designing Responsive Power BI Reports
On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) blogs about Dashboard Design Essentials: KPI Templates
On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] Power BI Report に Twitter の投稿ボタンを付けたい [Japanese]
On the xViz blog, Bhupinder Singh writes about 10 Linear Gauge Customizations in Power BI using xViz
Mike Allen (@MikeAinOz) blogs about ParaHtml PowerBI Custom Visual Version 1.0.1 SVG Upgrade and describes PageStar Custom Visual, The Start of an Idea

🚀 Deployment, Security and Operations

On the Power BI blog, Teddy Bercovitz (@Teddybbb) highlights the New way of getting apps
Also on the Power BI blog, Christopher Finlan (@cmfinlan) shares a Licensing and roadmap update for Power BI Report Server
Darren Gosbell (@darrengosbell) talks about Power BI Report Server – fixing Pending subscriptions
On the Towards Data Science blog, Davis Zhang covers Power BI RS: Setting Data Refresh in Trigger Mode
On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) explains how to Buy and Apply Power BI Premium P license
Parker Stevens (@PowerBIElite) discusses Building a Power BI Admin View Part 1: Connecting to Data from the REST API
On the Power BI YouTube channel, Peter Myers hosts a Developer in a Day online course about Embedding in Power BI
On the Power BI community blog, Jayendran Arumugam (@Jayendran_A) blogs about a Power BI Embedded Error: All provided principals must be existing, user or service principals
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about What Do You Need to Implement Dynamic Row Level Security in Power BI
Gilbert Quevauvilliers (@GilbertQue) writes about the Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1
Adam Saxton (@GuyInACube) writes about WHERE do you START with Power BI Performance???
Rafael Mendonça (@rafaelmpsantos) writes [Links Públicos do Power BI] Você ainda os utiliza? Bem... cuidado... [Portuguese]

🌐 General

Meagan Longoria (@mmarie) highlights an upcoming webinar: Power BI Data Viz Makeover: From Drab to Fab
The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 123
Mihail Mateev (@mihailmateev) describes How to build modern IoT solutions with Cosmos DB and Power BI
Asanka Padmakumara (@asanka_e) writes about 8 Popular myths about Power BI
On the Power BI community blog, Pat Mahoney provides A Self-Contained Sandbox PBIX File to Practice With
Adam Saxton (@GuyInACube) covers Power BI updates, DAX Fusion, and data driven subscriptions (Roundup | June 15, 2020)
Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE Hangout (June 20, 2020)
On the PowerPivotPro blog, Rob Collie (@robcolli3) writes Power BI and Paginated Reports: Better Together
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 150 - June 2020 Power BI Desktop Update
On the Towards Data Science blog, Ednalyn C. De Dios (@ecdedios) writes about Forecasting in Power BI
On the CSG Pro blog, Gregory Petrossian (@gregpetrossian) shares a presentation about Cash Flow Forecasting in Power BI
Ruth Pozuelo Martinez (@ruthpozuelo) explains how to Analyze and visualize your Outlook/Exchange calendar in Power BI
On the Beyond Impact blog, Branden Cecil writes about 3 things you should know about Microsoft's Power BI updates (May 2020)
Joseph Yeates (@FthrsAnalytics) discusses What's New in Power BI – June 2020
On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] Power BI でリアルタイムアンケート～アンケートを即可視化 2020年版 Vol.2～ [Japanese]