Power BI Weekly Issue 48: 3rd March 2020
A number of updates for you all this week. We can now configure our on-premise gateways to Use the Dataset owner's security context (UPN) for Refresh-based Reports (Public Preview), there is a new New Power BI tab for Microsoft Teams, you can now Promote your reports, dashboards, and apps on Power BI Home, and there is a new v3 .NET SDK to interact with the Power BI APIs.
Elsewhere this week, Ben Gribaudo has continued the Power Query M Primer series, with Part 17: Type System II – Facets, Darren Gosbell has described How to make the Gantt chart show events in progress, 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
- Ben Gribaudo (@bgribaudo) writes Power Query M Primer Part 17: Type System II – Facets
- Chris Webb (@cwebb_bi) describes Adding Your Own Messages To Power Query Query Diagnostics
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) provides some Practice Tips When Using The Power BI Advanced Editor
- On the Power BI community blog, Michal Dvorak (@nolockcz) writes a How-to: Dynamic Pivot in Power Query / T-SQL
- Matthew Roche (@SQLAllFather) shares One diagram to rule them all
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the endjin blog, James Broome writes about Azure Analysis Services – How to query all the measures in a model from .NET
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) covers Averages Per Customer Transactions – DAX in Power BI, describes Using Advanced Logic In Power BI To Correct Your Totals, discusses Calculating Profit Leakage Using Power BI Analytics and explains how to Learn Which Customer Groups Experienced Most Growth Through Customer Segmentation In Power BI
- Chandeep Chhabra (@chandeep2786) describes Bottom N in DAX
- On the Power BI Community blog, Timo Riikonen (@TimoRii) describes Top N with Slicer and Steps
- On YouTube, The Power BI team (@MSPowerBI) posts a video on Data modelling in Power BI Desktop
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- Darren Gosbell (@darrengosbell) describes How to make the Gantt chart show events in progress
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses a Power BI Visualization Technique: Learn How To Create Background Design Plates
- On the xViz blog, Bhupinder Singh talks about the xViz Waterfall Chart: Addressing frequently asked features from Power BI Ideas place
- Adam Saxton (@GuyInACube) describes how to Use a CUSTOM FONT with Power BI Desktop
- On the Power BI Community blog, Miguel Félix writes about Table Headers Conditional Formatting
- Ignacio Barrau (@ignacho_07) writes about Configuración de Informe [Spanish]
- Greg Low (@greglow) writes about Faster Power BI and Analysis Services Development with Automatic Data Subsets
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the MSSQLTips site, Scott Murray writes about Q&A Linguistic Schema
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) describes how to Use Dataset owner’s security context (UPN) for Refresh-based Reports (Public Preview)
- On the Azure blog, Michael Flanakin (@flanakin) writes about the New Power BI reports for Azure reservations and Azure Hybrid Benefit (Azure Cost Management)
- Chris Webb (@cwebb_bi) blogs about Connecting SQL Server Profiler To Power BI Premium
- Jan Egil Ring (@JanEgilRing) writes about Getting data from Power BI using PowerShell
- Patrick Leblanc (@GuyInACube) answers Can you use GROUPS with Power BI Row-Level Security (RLS)??? and wonders Why doesn't Export to Excel work with Power BI Row-Level Security (RLS)???
- Gilbert Quevauvilliers (@GilbertQue) describes Ensuring your Power BI Incremental Refresh does not Timeout when using a SQL Server Source
- Rafael Mendonça (@rafaelmpsantos) writes about Atualização Incremental - Saindo do mais do mesmo [Portuguese]
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- Adam Saxton and Patrick Leblanc (@GuyInACube) discuss Should you go to Power BI conferences?
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the New Power BI tab for Microsoft Teams
- Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) explains how to Promote your reports, dashboards, and apps on Power BI Home
- Also on the Power BI blog, Amit Shuster announces the Power BI APIs .NET SDK v3
- Also on the Power BI blog, Sandy Rivas (@SandyRivas) writes that the The Power BI Triple A Event Videos Are Now Live
- Adam Saxton (@GuyInACube) covers the AMAZING Power BI updates and more... (Roundup | February 24, 2019)
- Matthew Roche (@SQLAllFather) writes about Real customers, real stories
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.