Azure Weekly - Power BI Weekly #170 - 16th August 2022
Power BI Weekly Newsletter Issue #170
powered by endjin
Welcome to the 170th edition of Power BI Weekly! Another month, another Power BI Feature Summary. Improvements this month include much needed DAX editor fixes (solving some of the intellisense issues many of you will have encountered over the last year), there's now Conditional formatting for data labels for further chart customization, and there have been new settings to influence the Power BI engine query execution (you can see the commit diff for the underlying documentation in GitHub here: Evaluation configuration settings).
Elsewhere this week, we've also been told about a series of improvements to the Datamart Query editor and the now available PostgreSQL connector for the virtual network data gateway. Finally, there is a new (paid) Microsoft Power Platform Conference, sponsored by Microsoft and taking place in-person in Orlando from 18-23 September 2022. Looks like a great line-up with a wide variety of Power BI content on offer - do check it out.
If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.
Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.
@edfreeman_ | @endjin
powerbiweekly.info | endjin.com
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Power BI blog, Dharini Sundaram (@heydharini) announces improvements to Datamart Query editor
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI Datamart Vs. Dataflow Vs. Dataset
- Erik Svensen (@donsvensen) blogs about Power Query – Convert a referenced query column to a table without Table.FromList() – Magic trick
- Patrick Leblanc (@GuyInACube) presents You thought DAX? Alex shows you Dynamic M-M-Magic!
- Melissa de Korte (@_EnterpriseDNA) describes How To Strip Off Seconds From A DateTime Value In Power Query
- On the MSSQLTips site, Levi Masonde describes how to Load API Data to SQL Server Using Python and Generate Report with Power BI
- Bas Dohmen (@HowToPowerBI) discusses Geocoding API in Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) talks about Context Transition – The Whiteboard 03 and writes about the Different filter behaviors in SUMMARIZECOLUMNS and CALCULATETABLE
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about DEFINE MEASURE – DAX Guide
- Matt Allington (@ExceleratorBI) writes about Power BI Desktop August 2022 Features I Love
- Avi Singh (@powerbipro) describes How to Always Show Current Week vs. Prior Week Automatically
- Harsh Joshi (@_EnterpriseDNA) explains How To Calculate Ranking In A Tabular Form In Power BI
- Teo Lachev (@tlachev) writes Not Your Kimball’s DW
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Enterprise DNA blog, Mudassir Ali (@EnterpriseDNA_) explains how to Make Power BI Report Templates With PowerPoint
- Brian Julius (@_EnterpriseDNA) explains How To Extract Themes And Background Images From PBIX Files
- Reid Havens (@HavensBI) discusses Introduction to the PlotlyJS Custom visual with Kerry Kolosko and covers Reviewing the Field Parameters Contest Winners with Kane Snyder
- Ruth Pozuelo Martinez (@CurbalEN) explains How to design stunning Power BI reports: From initial sketches to final result
- On the Perficient blog, Ankit Jangle writes about 10 Steps to Integrate Power Apps on Power BI Dashboard
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) explains How to Visualize Python Charts in Power BI
- Hima Bindu Marri (@sivahimabindu) talks about Modern visual tool tips in Power BI
- Purna (Chandoo) Duggirala (@r1c1) describes How to create report page tooltips in Power BI (step by step)
- On the Learning Science YouTube channel, Learning Science talks about Conditional Formatting for Data Labels in Power BI
- Dhruvin Shah (@DhruvinShah16) explains how to Apply Conditional Formatting on Power BI Data Labels
- Olivier Travers (@otravers) writes about Data-Driven Heaven in Power BI Using Field Parameters, Bookmarks, CSS, and Expression-Based Formatting
- Lars Schreiber (@SchreiberLars) talks about Flexible Perioden in Power BI vergleichen [German]
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, Nikki Waghani (@NikkiWaghani) announces the PostgreSQL connector for the virtual network data gateway
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) describes How to Choose the Right Virtual Machines for Your Power BI Gateways
- Chris Webb (@cwebb_bi) blogs about Calling The Power BI Enhanced Refresh API From Power Automate, Part2: Refreshing Specific Tables And Partitions
- Mara Pereira (@datapears) writes about Power BI B2B - Sharing your content outside of your organisation
- Gilbert Quevauvilliers (@GilbertQue) covers the Power BI Error – Culture Name en-XX is not valid or is not supported
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, Oksana Kyrychenko (@MSPowerBI) shares the Power BI August 2022 Feature Summary
- Also on the Power BI blog, Kelly Kaye (@MS_KellyKaye) shares Join us! 18-23 September 2022. The FIRST ever Microsoft Power Platform Conference!
- James Serra (@JamesSerra) highlights some Power BI guidance documentation
- Lars Schreiber (@SchreiberLars) shares a Chat with Nikola Ilic
Useful Links
- Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
- M language reference - Official Power Query M Reference
- DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
- DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
- Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
- Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
- Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
- Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
- Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
- Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
- Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
- Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.
Tweet | Forward | Preferences | Unsubscribe
Older messages
☁️ Azure Weekly #381 - 7th August 2022
Sunday, August 7, 2022
Azure Weekly Newsletter Issue #381 powered by endjin Welcome to issue 381 of the Azure Weekly Newsletter. Three very interesting updates this week; firstly Azure Neural TTS previews a new contextual
Power BI Weekly #166 - 19th July 2022
Tuesday, July 19, 2022
Power BI Weekly Newsletter Issue #166 powered by endjin Welcome to the 166th version of Power BI Weekly! This month's Power BI Feature Summary includes announcements like the new NETWORKDAYS DAX
☁️ Azure Weekly #378 - 10th July 2022
Sunday, July 10, 2022
Azure Weekly Newsletter Issue #378 powered by endjin Welcome to issue 378 of Azure Weekly. There are a number of interesting articles covering real world uses cases of analytics: Introducing AVERA:
☁️ Azure Weekly #377 - 3rd July 2022
Sunday, July 3, 2022
Azure Weekly Newsletter Issue #377 powered by endjin Welcome to Issue 377 of Azure Weekly! Another quiet week, I suspect because it's the end of the Microsoft Financial Year. The Azure Synapse
Power BI Weekly #163 - 28th June 2022
Tuesday, June 28, 2022
Power BI Weekly Newsletter Issue #163 powered by endjin Welcome to the 163rd edition of Power BI Weekly! Not a huge amount of content this week, but we've had one pretty neat update which is that
You Might Also Like
Upgrade Your Git Game, Visual Studio Getting 'Command Palette,' Python/Java in VS Code, .NET 9 Preview, More
Thursday, April 25, 2024
Home | News | How To | Webcasts | Whitepapers | Advertise .NET Insight April 25, 2024 THIS ISSUE SPONSORED BY: ■ dtSearch® - INSTANTLY SEARCH TERABYTES Upgrade Your Git Game in Visual Studio 2022
🔒 The Vault Newsletter: April issue 🔑
Thursday, April 25, 2024
Get the latest business security news, updates, and advice from 1Password. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Top Tech 🏆 Lenovo ThinkPad X1 Carbon Gen 12 Laptop Review — Testing an AI Voice Recorder
Thursday, April 25, 2024
Also: The Roborock S8 MaxV Ultra Vacuum is Excellent, and More! How-To Geek Logo April 25, 2024 Take a look at our latest reviews, featuring fun tech like the Lenovo ThinkPad X1 Carbon laptop,
⚙️ r1
Thursday, April 25, 2024
Plus: UK investigating OpenAI
Charted | Economic Growth Forecasts for G7 and BRICS Countries in 2024 📊
Thursday, April 25, 2024
The IMF has released its economic growth forecasts for 2024. How do the G7 and BRICS countries compare in expected real GDP growth? View Online | Subscribe Presented by: Access European benchmarks with
Build5Nines Newsletter - April 25, 2024
Thursday, April 25, 2024
View this email in your browser Build5Nines Build5Nines Newsletter Thank you for subscribing! I look forward to sharing with you the latest cloud news, technical help, and other thoughts around DevOps
Discover the World's Easiest Parallel File System
Thursday, April 25, 2024
Join us in exploring the future of data management with Bjorn Kolbeck, a Google engineer turned CEO and Co-founder of Quobyte, the creators of the world's easiest parallel file system. ͏ ͏ ͏ ͏ ͏ ͏
Issue 314 - New Model 3 Performance is here
Thursday, April 25, 2024
View this email in your browser If you are just now finding out about Tesletter, you can subscribe here! If you already know Tesletter and want to support us, check out our Patreon page Issue 314 - New
Programmer Weekly - Issue 202
Thursday, April 25, 2024
View this email in your browser Programmer Weekly Welcome to issue 202 of Programmer Weekly. Let's get straight to the links this week. Quote of the Week "Computer science inverts the normal.
Python Weekly - Issue 647
Thursday, April 25, 2024
View this email in your browser Python Weekly Welcome to issue 647 of Python Weekly. Let's get straight to the links this week. From Our Sponsor Get Your Weekly Dose of Programming A weekly