Power BI Weekly Issue 69: 28th July 2020
If React is part of your toolkit, then you're in luck this week - there's a new Power BI component for React to more easily embed your reports into React applications. The other couple of updates this week regard the new On-premises data gateway July 2020 update in which there's been added support for OAuth authentication via the gateway, and then there's the Power BI Service and Mobile May and June 2020 feature summary rounding up the last couple of months' worth of updates.
Elsewhere this week, Ruth Pozuelo Martinez has demonstrated 20 tricks to finally master the Matrix visualization in Power BI, and David Eldersveld has written a three part series about using Python as an External Tool for Power BI Desktop - here's Part 1.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) discusses Returning Annotations From OData Sources In Power BI/Power Query
- On the Power BI community blog, spgvizcube describes ETL Through Multiple Pages of a Website in Power BI
- On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) discusses Getting Started with APIs in Power Query
- Chandeep Chhabra (@chandeep2786) explains how to Create Dynamic File Path in Power Query
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) writes about Animated Scroll Bar / Scroller Visual in POWER BI, Get data from Pakistan Stock Exchange Website PSX and describes how to Extract Dates from Text - Column from Examples POWER QUERY - Microsoft Excel
- Melissa de Korte explains how to Create A Perpetually Updated Practice Dataset in Power BI
- On the Power BI Community blog, lbendlin writes It's the weekend! Or is it?
- Marcus Wegener (@PowerBIler) posts Hey Peter! In Power BI Spalten entpivotieren [German]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Also on the Power BI community blog, Greg Deckler (@GregDeckler) discusses CALCUHATE - Why I Don't Use DAX's CALCULATE Function
- Patrick Leblanc (@GuyInACube) writes about the NEW way to create measures in Power BI
- Gilbert Quevauvilliers (@GilbertQue) describes Validating Power BI DAX measures when using Tabular Editor
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes TIQ Part 3—Ultimate Guide to Date dimension creation
- Parker Stevens (@PowerBIElite) blogs about Power BI - Filter by a Measure in a Slicer
- Ruth Pozuelo Martinez (@ruthpozuelo) shares DAX Fridays #182: Virtual relationships with CONTAINS DAX function
- On the Power BI community blog, DavisBI talks about Iteration in DAX
- Also on the Power BI community blog, Mounika Narayana Reddy writes about the Redundant 'IF(Divide)' Statement and Power BI Report Performance Issues
- On the CSG Pro blog, Rachel Dyer (@rachelrdyer) shares a DAX Tutorial: The Most Important Practice For New DAX Developers
- Lars Schreiber (@SchreiberLars) writes about Die Herausforderung sich ändernder Dimensionen in Power BI [German]
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of posts: Dynamic Segmentation With Dynamic Parameters – Advanced Power BI & DAX Technique, Common Time Intelligence Patterns Used In Power BI, Top Customer Per Product – Power BI Analysis, Using The MAXX DAX Function In Power BI To Calculate Recent Values In Your Data, Creating A Pareto Chart In Power BI – Advanced DAX, Calculate A Year-To-Date YTD Monthly Moving Average In Power BI, Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique, Using AVERAGEX In Power BI – A DAX Tutorial & Examples and Five Strategies to Enhance Your DAX Toolbox
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) explains how to Analyze in Excel – the Advanced Method
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- David Eldersveld (@dataveld) writes about Python as an External Tool for Power BI Desktop: Part 1, Part 2 – Create a PBITool.json File and Part 3 – Virtual Environments and TOM Connection
- Matt Allington (@ExceleratorBI) writes about External Tools in Power BI Desktop
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a DAX 101: Mark as Date table
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) describes Power BI Report Guides
- Vivek Ranjan (@imvivran) describes how to Show or Hide measures using Slicer: Power BI
- Ruth Pozuelo Martinez (@ruthpozuelo) writes about 20 tricks to finally master the Matrix visualization in Power BI
- Reid Havens (@HavensBI) talks about the Color Gradient Legend for Native Visuals in Power BI
- Laura Graham-Brown (@Laura_GB) covers Power BI – Gradient Legends
- Dhruvin Shah (@DhruvinShah16) writes about Getting Started with Azure Maps visual in Power BI and describes how to Change Header Text for Power BI Slicer Value
- Mike Allen (@MikeAinOz) writes about Starability - An Active BI Story
- On the xViz blog, Bhupinder Singh writes about the xViz Linear Gauge – Progress Bar for MS Power BI and blogs about xViz Adv Pie and Donut for Power BI
- Also on the xViz blog, Marisharannath Chandran Soundarnath writes about Conditional formatting in xViz Gauges for MS Power BI
- On LaDataWeb, Bruno Zurita writes Leyes de UX aplicadas a Power Bi - Episodio 1 [Spanish]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) announces that the On-premises data gateway July 2020 update is now available
- On the Power BI community blog, Srishti Sharma writes Unable to Connect to Power BI Through XMLA Endpoint Using SQL Profiler
- Also on the Power BI community blog, Sumana Biswas writes Unable to Open a Paginated Report in PBI Service
- Also on the Power BI community blog, Anamika Goswami shares some PowerShell Scripts to Export Power BI Reports to PBIX/PDF/PPT
- Olivier Travers (@otravers) writes about Row Level Security in Business Intelligence Applications: A Practical Overview
- On the Power GI blog, Cyrus Christian highlights that Deployment Pipelines in Premium government cloud
- On the Blue Granite blog, Kirtis Carpenter blogs about Power BI for Government Agencies - Auditing Logins
- On the Prologika blog, Teo Lachev (@tlachev) writes about Why You Need a Trusted Advisor
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Amit Shuster (@ShusterAmit) announces React Power BI
- Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) describes the Power BI Service and Mobile May and June 2020 feature summary
- Adam Saxton (@GuyInACube) discusses the Power BI Desktop update and more... (Roundup | July 20, 2020)
- Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE (July 25, 2020)
- Matt Allington (@ExceleratorBI) blogs about Power BI Birthday Number 5
- Spencer Baucke (@JSBaucke) covers Analyzing Tableau and Power BI: A Conversation with Sekou Tyler
- BI Polar shares 5've Got All The Swords and provides A Brief History of Business Intelligence
- Avi Singh (@powerbipro) shares the Talk Power BI LIVE Q&A (July 24, 2020)
- Reza Rad (@Rad_Reza) talks about Power BI Design Patterns
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.