Power BI Weekly Issue 8: 21st May 2019
This week our very own James Broome has written a brilliant blog explaining How to create a Power BI workspace in an Azure DevOps Pipeline using Powershell, laying it out step-by-step and alluding to the gotchas. This week, we've also been given the Power BI Desktop May 2019 Feature Summary which includes information about the new Performance analyzer pane which I'm sure a lot of you will find very useful! Elsewhere, there have been some advancements around Trusted Third Party Connectors for Power BI, making it easier for you to use the connectors you've built and trust.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI blog, Colin Popell writes about Trusted Third Party Connectors for Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets
- Chris Webb (@cwebb_bi) answers What Is The Maximum Length Of A Text Value In Power BI? and describes Storing Large Images In Power BI Datasets
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Get Data from Web by Example
- Lars Schreiber (@SchreiberLars) writes about Records in Power Query – how, when and why
- Imke Feldmann (@TheBIccountant) blogs about The full Table.ContainsAnywhere function for Power Query in Power BI and Excel
- Daniil Maslyuk (@DMaslyuk) writes about the New M function: Text.ReplaceAll
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) blogs about Creating a simple date table in DAX and writes about Automatic time intelligence in Power BI
- Also on the SQLBI blog, Marco Russo (@marcorus) highlights the Mastering DAX video course, 2nd edition
- On the RADACAD blog, Reza Rad (@Rad_Reza) covers the Basics of Modeling in Power BI: Fact Tables
- Imke Feldmann (@TheBIccountant) posts a custom DAX CALCULATE Debugger
- On the Data Bear blog, Edward Van Der Merwe talks about SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD
- Patrick Leblanc (@patrickdba) describes how to Use DAX to get relative dates
- On the edureka blog, Upasana writes about Starting out with DAX in Power BI
- Matt Allington (@ExceleratorBI) talks about Measure Tables in Power BI
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the DB Best blog, Anil Kishore explains how to Create a waterfall chart when the data differs by several orders of magnitude
- Also on the DB Best blog, DeNisha Malone (@thepowerbiqueen) suggests to Align Your Visuals — Episode 7
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the MSSQLTips site, Scott Murray writes about Power BI Personal Bookmarks
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- On the endjin blog, James Broome explains How to create a Power BI workspace in an Azure DevOps Pipeline using Powershell
- Gilbert Quevauvilliers (@GilbertQue) posts Power BI Premium Performance – Part 4 How does Row Level Security affect performance
- On the Power BI Community blog, timmac provides some [SUPPORT-INFO]: Export-PowerBIReport returns: invalid status code 'Unauthorized'
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Amanda Cofsky (@MissAmandaN) provides the Power BI Desktop May 2019 Feature Summary
- Adam Saxton (@guyinacube) talks about Power BI Updates, tips and tricks and more May 13, 2019
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) provides a Power BI 101 for an Excel User: Read this before you use Power BI
- On the Power BI community blog, jfeil describes how Power BI helps Improve Ocean Health
- Also on the Power BI blog, Vera Chan writes that Through Power BI, USAFacts Explores Government Financial Data In Latest Report
- Also on the Power BI blog, Miguel Martinez (@maikelson) discusses Microsoft Business Applications Summit: Top 10 reasons to attend
- Also on the Power BI blog, Charles Sterling (@chass) writes Meet Community stars at Microsoft Business Applications Summit
- On BIFocal, John White and Jason Himmelstein (@bifocalshow) present Episode 100 - A measurable milestone
- Gil Raviv (@gilra) writes about My Sessions at MBAS
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.