Power BI Weekly Issue 47: 25th February 2020
The first Power BI Desktop update of the year has landed: read about the new Hierarchical slicer, ribbon updates, DAX functions and more here. The other huge news of the week, is that Incremental refresh is generally available ... and supported in Pro! Hooray! This is great news for datasets big and small - only refresh the data that's new.
There are a couple of updates that have slipped through the gaps over the past couple of editions (sorry about that) - those are the General Availability of Bring Your Own Key (BYOK) for Power BI Premium and the enhanced connectivity for Snowflake.
Elsewhere this week, Marco Russo has written an in-depth blog on Relationships in Power BI and Tabular models, and James Broome has continued his series on Azure Analysis Services – How to query all the measures in a model from .NET.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI blog, Ofer Ashkenazi announces enhanced connectivity for Snowflake
- Adam Saxton (@GuyInACube) talks about What to do when your Power BI dataflows data source isnt listed???
- Imke Feldmann (@TheBIccountant) shares a Date.Networkdays function for Power Query and Power BI and writes about Various ways to add a column to a table in Power BI and Power Query
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) talks about the SQL Server Integration Services Power Query Source
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the SQLBI blog, Marco Russo (@marcorus) writes about Relationships in Power BI and Tabular models
- On the PowerPivotPro blog, Krissy Dyess writes about ALL('the Bengal Ladies')
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes how to Use Power BI Measure Branching To Check If Your Margins Expand As Revenue Grows
- On the Power BI community blog, Amit Chandak (@amitchandak78) writes Decoding Direct Query in Power BI Part 2: Date Difference Across in Direct Query: Oracle/SQL Server
- Matt Allington (@ExceleratorBI) discusses Joining Tables on 2 Columns in Power BI
- On the endjin blog, James Broome writes about Azure Analysis Services – How to query all the measures in a model from .NET
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- The Azure updates team writes that ArcGIS now supported for embedded analytics for your organisation and highlights that High contrast mode for embedded reports now available
- On the Visual BI blog, Arjun Raja Sreedar talks about PowerBI AI Visuals & Capabilities
- On the xViz blog, Bhupinder Singh writes about 20+ Configuration Options in xViz Multi Axes Chart for Power BI
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- The Azure updates team highlights that the Embedded Filters API now supports single-selection filter
- Patrick Leblanc (@GuyInACube) asks whether you're Going CRAZY with Power BI slicers not filtering other slicers
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) describes Adding Contextual Help for End Users
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, Christian Wade (@_christianWade) announces that Incremental refresh is generally available ... and supported in Pro
- Also on the Power BI blog, David Magar announces the General Availability of Bring Your Own Key (BYOK) for Power BI Premium
- Adam Saxton (@GuyInACube) highlights that SharePoint DOES NOT make Power BI Publish to Web secure!
- Gilbert Quevauvilliers (@GilbertQue) describes How to configure Azure Function App notifications for errors
- The Azure updates team writes that Power BI has new, improved usage metrics report
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Sujata Narayana shares the Power BI Desktop February 2020 Feature Summary
- Devin Knight (@knight_devin) provides the Power BI Monthly Digest – February 2020
- Adam Saxton (@GuyInACube) talks about Big news for Power BI and more... (Roundup | February 17, 2020) and presents 3 tips for Power BI Adoption with Chris Wagner
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 136 - February 2020 Power BI Desktop Update
- On the Power BI YouTube channel, The Power BI team (@MSPowerBI) shares the Ask Amir Anything session
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.