Azure Weekly - Power BI Weekly #163 - 28th June 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 Preview data is now available in the dataset details page. You'll now see a pane on the right of your screen on the dataset details page with the tables and columns within the dataset, which you can use to take a quick peek at the data and export it if you wish (there's even a check-box at the table level to select all columns within that table (which still doesn't exist in Desktop, but oh well)). Elsewhere this week, Barry Smart has shown how Python and Power BI can work well together in his blog Extract insights from tag lists using Python Pandas and Power BI, Marco Russo has gone into depth helping us understand the optimization of SWITCH, and Kim Manis has joined Kelly Kaye on the Community Show talking about Synapse and Power BI.
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 endjin blog, Barry Smart covers Extract insights from tag lists using Python Pandas and Power BI
- Chris Webb (@cwebb_bi) blogs about Monitoring Power Query Online Memory And CPU Usage
- On the Power BI community blog, Xiaoxin Sheng describes How to do cumulative counting by group in Power Query
- Rick de Groot (@Rickmaurinus) describes how to Return Rows with Maximum Value in Power Query
- Michael Felix covers Rankings no Power Query [Portuguese]
- Bernat Agulló (@AgulloBernat) writes about Validating migrations, or how to properly compare tables
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) describes Power BI Datamart
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Understanding the optimization of SWITCH
- Greg Deckler (@GregDeckler) explains How To Create Dynamic Temporal Scale In Power BI Pt.2
- Reid Havens (@HavensBI) describes DAX Anti-Patterns Episode Twelve - Case Sensitivity - with Daniil Maslyuk
- On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) covers Using The DAX Studio User Interface: An Overview and writes about Optimizing DAX For Power BI Using DAX Studio – Formula Engines
- Olivier Travers (@otravers) describes How to Get DAX Query Results Out of Power BI Without Writing Any DAX or Code
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Daniel Marsh-Patrick (@the_d_mp) writes about "Out of One, Many", or: Making Switchable Charts in Power BI with Deneb
- Also on the Power BI community blog, Yingjie Li blogs about Field Parameters in Power BI
- On the Power BI community blog, Anand delves into Field Parameter and Bookmarking Field Parameter Values In Power BI Report Server
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes how to Bring life to Field Parameters in Power BI
- Also on the Towards Data Science blog, Thiago Carvalho writes about Dynamic Axes with Field Parameters in Power BI
- Kim Leblanc covers Libre choix à l’utilisateur avec les Paramètres de champs [French]
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes How to Add Forecasting in Line Chart | Regular and Irregular Intervals (Dates)
- Patrick Leblanc (@GuyInACube) discusses From Decomposition Tree to Details in Power BI
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) describes How to Increase the Vertical Orientation of Power BI Report Page
- James Andrew explains how to Create a stylish & minimal Power BI dashboard in 6 simple steps
- Ignacio Barrau (@ignacho_07) covers Informes preparados para exportar/imprimir [Spanish]
- On the Learning Science YouTube channel, Learning Science describes Hyperlink in Power BI | 4 Ways to add external URL & navigate in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Cookie McCray announces Preview data is now available in the dataset details page
- Microsoft Power BI (@MSPowerBI) explain how to Govern your data in Power BI leveraging auto detection of sensitive information
- Marc Lelijveld (@MarcLelijveld) covers Power BI B2B External Collaboration
- Meagan Longoria (@mmarie) describes how to Log in to Power BI Desktop as an External B2B User
- Gilbert Quevauvilliers (@GilbertQue) describes How to get Power BI Row Level Security (RLS) Role users, details and export to CSV
- Arnaud Gastelblum (@LazySna1l) covers Filter a Power BI report passing parameters through URL
- Philipp Lenz (@lenz_philipp) explains how to Migrate SSAS Tabular Models to Power BI Premium by using the XMLA endpoint
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Append exported Power BI data to Excel automatically
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 7 - Synapse and Power BI with Kim Manis
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 229 - Power BI June 2022 Feature Summary
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents Power BI & Microsoft 365 – Better Together by Amanda Rivera Auckland Power BI User Group
- Bas Dohmen (@HowToPowerBI) explains How to Get Started with Power BI
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
Key phrases
Older messages
Power BI Weekly #161 - 14th June 2022
Tuesday, June 14, 2022
Power BI Weekly Newsletter Issue #161 powered by endjin Welcome to the 161st edition of Power BI Weekly! A pretty quiet week this week with just the one official announcement, which was the May Release
Power BI Weekly #160 - 7th June 2022
Tuesday, June 7, 2022
Power BI Weekly Newsletter Issue #160 powered by endjin Only one update this week, which is that Enhanced refresh with the Power BI REST API is now generally available (renamed from asynchronous
☁️ Azure Weekly #373 - 29th May 2022 - Microsoft BUILD special!
Monday, May 30, 2022
Azure Weekly Newsletter Issue #373 powered by endjin Welcome to issue 373 of Azure Weekly - a bumper edition (about 2x the normal size!) covering all the announcements from BUILD 2022. Jumping straight
☁️ Azure Weekly #372 - 22nd May 2022
Sunday, May 22, 2022
Azure Weekly Newsletter Issue #372 powered by endjin Welcome to issue 372 of Azure Weekly! Quite a busy edition this week, considering this is usually the "calm before the BUILD storm". Some
Power BI Weekly #157 - 17th May 2022
Tuesday, May 17, 2022
Power BI Weekly Newsletter Issue #157 powered by endjin Welcome to the 157th edition of Power BI Weekly! Yesterday the Power BI May 2022 Feature Summary came out, and the feature that's drawn the
You Might Also Like
New Alpine.js Sort plugin, Laravel 11.5, and more - №510
Sunday, April 28, 2024
Your Laravel week in review ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
This Week's Daily Tip Roundup
Sunday, April 28, 2024
Missed some of this week's tips? No problem. We've compiled all of them here in one convenient place for you to enjoy. Happy learning! iPhoneLife Logo View In Browser Your Tip of the Day is
DeveloPassion's Newsletter #164 - A Thousand Fans
Sunday, April 28, 2024
Edition 164 of my newsletter, discussing Knowledge Management, Knowledge Work, Zen Productivity, Personal Organization, and more! Sébastien Dubois DeveloPassion's Newsletter DeveloPassion's
Nobody Likes a Know-It-All: Smaller LLMs are Gaining Momentum
Sunday, April 28, 2024
Phi-3 and OpenELM, two major small model releases this week. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Retro Recomendo: Music
Sunday, April 28, 2024
Recomendo - issue #408 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Your Phone’s Other Number 📱
Saturday, April 27, 2024
Let's talk about your phone's IMEI number. Here's a version for your browser. Hunting for the end of the long tail • April 27, 2024 Today in Tedium: As you may know, Tedium is a blog and/or
🕹️ How to Play Retro Games for Free on iPhone — Why I Can't Live Without an eReader
Saturday, April 27, 2024
Also: Anker MagGo (Qi2) Power Bank Review, and More! How-To Geek Logo April 27, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by
Weekend Reading — The Bob Ross of programming
Saturday, April 27, 2024
This week we use coffee tasting as our design practice, get as close to and as far away from the metal as possible, find an easier way to write documentation, discover why Google Search is getting so
Issue #538: All the Jam entries, Panthera 2, and Tristram
Saturday, April 27, 2024
Weekly newsletter about HTML5 Game Development. Is this email not displaying correctly? View it in your browser. Issue #538 - April 26th 2024 If you have anything you want to share with the HTML5 game
Daily Coding Problem: Problem #1424 [Easy]
Saturday, April 27, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Microsoft. Implement a URL shortener with the following methods: shorten(url) , which