Power BI Weekly #125 - 14th September 2021
Power BI Weekly Newsletter Issue #125
powered by endjin
Welcome to the 125th edition of Power BI Weekly! Just the one announcement on what has been a very quiet week, and that's an update on the preview of the Export Power BI report to file API whereby they've massively increased the limit of the volume of API requests you can make and removed the concurrent pages limitation, amongst other changes. Othwerwise this week, Chris Webb has highlighted a useful option for SQL Server connectors to Preserve Data Types With SQL Queries In Power Query, Adam Saxton has spoken about the Power BI XMLA Endpoint and why you should care, and Antriksh Sharma has described how to Sort Columns in a Matrix in Descending order with DAX and nifty use of the 'sort by column' functionality.
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
- Chris Webb (@cwebb_bi) describes Preserving Data Types With SQL Queries In Power Query And Power BI
- Mimoune Djouallah (@mim_djo) describes how to Share Data from a Power BI Dataset using Dataflow
- Matt Allington (@ExceleratorBI) talks about When to use Power Query/M vs Data Modelling/DAX with Ken Puls
- Soheil Bakhshi (@biinsightnz) shares a Quick Tip: Adding Leading Zero to Integer Values Padding with DAX and Power Query
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) writes about the M Language and Power Query Editor In Power BI
- Mike Allen (@MikeAinOz) blogs about Power BI Workflows In Excel with ADLS2
- On the dev.to blog, Matt Thacker (@mthacker09) describes Working With APIs in Microsoft's Power BI
- Ruth Pozuelo Martinez (@CurbalEN) explains How to do Pagination on a REST API in Power Query (Part 1)
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) delves into Creating Column Values Distribution Report in Power BI Using Power Query
- Rick de Groot (@Rickmaurinus) describes how to Filter Column by List Items Exact Match in Power Query
- Allison Kennedy writes about Advanced Filter OR vs AND
- On the Power BI Community blog, Xiaoxin describes Some filter operations based on character functions
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Patrick Leblanc (@GuyInACube) talks about When is a date not a date in Power BI?
- Antriksh Sharma (@AntrikshShar) describes how to Sort Columns in a Matrix in Descending order with DAX in Power BI
- On the Power BI Community blog, Greg Deckler (@GregDeckler) writes a series of blogs: Localizing the Data Model - Part 1, Part 2 and Part 3
- Matt Allington (@ExceleratorBI) talks about Variables in DAX
- On the Purple Frog Systems blog, Jeet Kainth writes about Variables in DAX
- Brian Julius writes about What Does "Variables Are Constants" Really Mean?
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses NATURALINNERJOIN, NATURALLEFTOUTERJOIN – DAX Guide and NONVISUAL – DAX Guide
- On the Power BI Tips and Tricks blog, James Bartlett shares a tool to Copy Power BI Desktop Server:Port Connection String to Clipboard
- Leila Gharani (@LeilaGharani) shares a Smart Excel Pivot Table Trick - Choose Your KPI from Slicer Excel Dashboard with DAX
- Hima Bindu Marri (@sivahimabindu) covers ParallelPeriod in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Enterprise DNA blog, Mudassir Ali blogs about Power BI Charts And Visuals Inside Charticulator
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) discusses Part-2 How To Highlight Events, Moving Average & Build Rich Tooltips In Power BI
- Bas Dohmen (@HowToPowerBI) describes Showing multiple forecasts in one chart in Power BI and talks about TopN confusion in Power BI | When the Top3 doesn't return 3 items
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains Drill Down and Up in Power BI
- Reid Havens (@HavensBI) describes Getting Started with Paginated Reports with Johnny Winter
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Work faster in Power BI
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 13 - Developing with Salesforce in Power BI Reports
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, Alon Baram provides the Export Power BI report to file API – Preview Update
- Adam Saxton (@GuyInACube) talks about the Power BI XMLA Endpoint: Why you should care
- Kevin Chant (@kevchant) shares a Nifty Power BI fix in Synapse Studio
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 204 - Power BI News Update
- On the RADACAD YouTube channel, Allison Kennedy presents the Auckland Power BI user group | Collaborate and Share Power BI through Teams
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
☁ Azure Weekly #340 - 12th September 2021
Sunday, September 12, 2021
Azure Weekly Newsletter Issue #340 powered by endjin Welcome to issue 340 of Azure Weekly. Unfortunately we have to start the issue with another security issue. Palo Alto Network's Unit 42 team
☁ Azure Weekly #338 - 29th August 2021
Sunday, August 29, 2021
Azure Weekly Newsletter Issue #338 powered by endjin Welcome to issue 338 of Azure Weekly. One of the biggest news articles this week was from Wiz, a Cloud Security Company, who revealed severe
Power BI Weekly #123 - 17th August 2021
Tuesday, August 17, 2021
Power BI Weekly Newsletter Issue #123 powered by endjin Welcome to the 123rd edition of Power BI Weekly! Firstly, a newsletter related announcement - the next edition of Power BI Weekly will be on the
Power BI Weekly #122 - 10th August 2021
Tuesday, August 10, 2021
Power BI Weekly Newsletter Issue #122 powered by endjin Welcome to the 122nd edition of Power BI Weekly! Some amazing announcements this week. The biggest one (IMO) came somewhat out of the blue, which
☁ Azure Weekly #335 - 8th August 2021
Sunday, August 8, 2021
Azure Weekly Newsletter Issue #335 powered by endjin Welcome to Azure Weekly Issue 335! We've had an week at endjin onboarding the first of our new cohort of interns and apprentices - a huge
You Might Also Like
Data Science Weekly - Issue 540
Friday, March 29, 2024
Curated news, articles and jobs related to Data Science, AI, & Machine Learning ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
This Week in Rust #540
Friday, March 29, 2024
Email isn't displaying correctly? Read this e-mail on the Web This Week in Rust issue 540 — 27 MAR 2024 Hello and welcome to another issue of This Week in Rust! Rust is a programming language
The Value Of A Promise 🤞
Friday, March 29, 2024
How much is a promise from a tech company really worth, anyway? Here's a version for your browser. Hunting for the end of the long tail • March 28, 2024 The Value Of A Promise When you hear a
New Elastic Security for SIEM Training Course
Friday, March 29, 2024
Detect and respond to evolving threats ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ elastic | Search. Observe. Protect Detect anomalies and malicious behavior March
SBF gets 25 years
Thursday, March 28, 2024
Sam Bankman-Fried is sentenced View this email online in your browser By Christine Hall Thursday, March 28, 2024 Welcome back to TechCrunch PM! The editorial team spent a chunk of the day discussing
💎 Issue 410 - Being laid off in 2023-2024 as an early-career developer
Thursday, March 28, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 403 - Microsoft defends .NET 9 features competing with open source ecosystem
Thursday, March 28, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 403 Release Date Mar 28, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 410 - Node.js TSC Confirms: No Intention to Remove npm from Distribution
Thursday, March 28, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular Node.js news, articles and
💻 Issue 410 - JSDoc as an alternative TypeScript syntax
Thursday, March 28, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular JavaScript news, articles
📱 Issue 404 - Dependency Injection for Modern Swift Applications Part II
Thursday, March 28, 2024
This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 404 Release Date Mar 28, 2024 Your weekly report of the most popular iOS news, articles and projects Popular