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