Power BI Weekly
Issue #36 - 3rd December 2019
I hope everyone who celebrated Thanksgiving last week had a great time. It's been noticeably quiter over the last week. Only a few blogs came from the Power BI team - the only announcement being that the On-premises data gateway November 2019 update is now available. We were also told about How Power BI and Accessibility Work Together, and the Analytics in Azure Virtual Event on the 10th December was pointed out to us.
A number of interesting articles this week. Phil Seamark hsa written that Clean data = faster reports, Gilbert Quevauvilliers has described How I saved 40%+ on Power BI Dataset size, and Matthew Roche has provided another useful Power BIte: Turning datasets into dataflows.
🛠️ Data Prep
- Erik Svensen (@donsvensen) talks about PowerQuery – Calculate the ISO date from year and a week number
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Extract Start and End Dates with Power Query
- Matthew Roche (@SQLAllFather) provides a Power BIte: Turning datasets into dataflows
- Chandeep Chhabra (@chandeep2786) writes about the IF Function in Power Query
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) writes about the New Artificial Intelligence Features in Power BI / Power Query
- Gilbert Quevauvilliers (@GilbertQue) describes How I saved 40%+ on my Power BI Dataset size
🧩 Data Modeling
- Jiri Neoral (@JiriNeoral) provides a DAX for Analysis Services Multidimensional workaround
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Sorting months in fiscal calendars
- Phil Seamark (@PhilSeamark) writes that Clean data = faster reports
- On the RADACAD blog, Reza Rad (@Rad_Reza) presents a Slicer with AND condition in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) posts a number of blogs: How To Organize Your Power BI Data Model – Best Practice Tips, Group Customers Dynamically By Their Ranking w/RANKX In Power BI, Segmentation Example Using Advanced DAX in Power BI, Discover Where Your Profit Growth Comes From: A Power BI Tutorial and Using Iterating Functions SUMX And AVERAGEX In Power BI
⚙️ Report Design and Visualizations
- Mimoune Djouallah (@mim_djo) writes about PowerBI, generate multiple Print quality Maps using R
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) covers Embedding Paginated Reports
⚙️ Data Exploration
- On the RADACAD blog, Reza Rad (@Rad_Reza) covers a Power BI What If Parameter for Getting the Sales of X months ago: Use Case Scenario
🚀 Deployment, Security and Operations
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that the On-premises data gateway November 2019 update is now available
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) describes Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
- Paul Turley (@paul_turley) covers Setting up Power BI project Team Collaboration & Version Control
🌐 General
- On the Power BI blog, Vijay Gopalakrishnan highlights the Analytics in Azure Virtual Event
- Also on the Power BI blog, Tessa Hurr (@tessahurr) explains how to Learn How Power BI and Accessibility Work Together
- Meagan Longoria (@mmarie) writes that Microsoft Can't Make Your Power BI Reports Accessible Without Your Help