PBI Queryous
@pbiqueryous.bsky.social
🦄#F5F5DC
🏹MemeHunter
🧙🏽♂️dataGeek
#PowerBI | #PowerQuery |
#StayQueryous | #M | #DAX | #Excel |
#Linguaphile | #Dialects
#Geordie #Català #Español
🏹MemeHunter
🧙🏽♂️dataGeek
#PowerBI | #PowerQuery |
#StayQueryous | #M | #DAX | #Excel |
#Linguaphile | #Dialects
#Geordie #Català #Español
From the PowerBI community on Reddit
Explore this post and more from the PowerBI community
www.reddit.com
November 6, 2025 at 9:30 PM
Reposted by PBI Queryous
I've long known that #SQLServer supports "if exists" when dropping objects.
DROP TABLE IF EXISTS dbo.test;
It even supports multiple tables, like
DROP TABLE IF EXISTS dbo.test1, dbo.test2;
But did you know that it applies to DROP COLUMN, too?
ALTER TABLE dbo.test DROP COLUMN IF EXISTS col1;
DROP TABLE IF EXISTS dbo.test;
It even supports multiple tables, like
DROP TABLE IF EXISTS dbo.test1, dbo.test2;
But did you know that it applies to DROP COLUMN, too?
ALTER TABLE dbo.test DROP COLUMN IF EXISTS col1;
August 27, 2025 at 6:19 PM
I've long known that #SQLServer supports "if exists" when dropping objects.
DROP TABLE IF EXISTS dbo.test;
It even supports multiple tables, like
DROP TABLE IF EXISTS dbo.test1, dbo.test2;
But did you know that it applies to DROP COLUMN, too?
ALTER TABLE dbo.test DROP COLUMN IF EXISTS col1;
DROP TABLE IF EXISTS dbo.test;
It even supports multiple tables, like
DROP TABLE IF EXISTS dbo.test1, dbo.test2;
But did you know that it applies to DROP COLUMN, too?
ALTER TABLE dbo.test DROP COLUMN IF EXISTS col1;
Without downloading any new images, where are you mentally?
August 27, 2025 at 4:34 AM
Without downloading any new images, where are you mentally?
Reposted by PBI Queryous
SSMS Tips and Tricks 5.3 Using the XML editor and increasing the XML output size
blog.greglow.com/2025/08/23/s...
blog.greglow.com/2025/08/23/s...
August 23, 2025 at 5:00 AM
SSMS Tips and Tricks 5.3 Using the XML editor and increasing the XML output size
blog.greglow.com/2025/08/23/s...
blog.greglow.com/2025/08/23/s...
The North remembers...
August 23, 2025 at 10:40 AM
The North remembers...
Reposted by PBI Queryous
What's the origin of 'soul'?
No living soul knows.
The Germanic ancestor of 'soul' can be reconstructed, but attempts to reconstruct its further origin or find cognates have only been speculative.
My new graphic sums up these theories and shows the cognates of 'soul' in the sister languages:
No living soul knows.
The Germanic ancestor of 'soul' can be reconstructed, but attempts to reconstruct its further origin or find cognates have only been speculative.
My new graphic sums up these theories and shows the cognates of 'soul' in the sister languages:
August 15, 2025 at 7:04 PM
What's the origin of 'soul'?
No living soul knows.
The Germanic ancestor of 'soul' can be reconstructed, but attempts to reconstruct its further origin or find cognates have only been speculative.
My new graphic sums up these theories and shows the cognates of 'soul' in the sister languages:
No living soul knows.
The Germanic ancestor of 'soul' can be reconstructed, but attempts to reconstruct its further origin or find cognates have only been speculative.
My new graphic sums up these theories and shows the cognates of 'soul' in the sister languages:
Reposted by PBI Queryous
This paper by Meredith et al. (2025) examines global city exposure to volcanic hazards, using metrics such as population and distance to GVP Holocene volcanoes to quantify and rank cities at risk. This data has also been visualised through a web app. nhess.copernicus.org/articles/25/...
Cities near volcanoes: which cities are most exposed to volcanic hazards?
Abstract. Cities near volcanoes expose dense concentrations of people, buildings, and infrastructure to volcanic hazards. Identifying cities globally that are exposed to volcanic hazards helps guide l...
nhess.copernicus.org
August 15, 2025 at 3:09 PM
This paper by Meredith et al. (2025) examines global city exposure to volcanic hazards, using metrics such as population and distance to GVP Holocene volcanoes to quantify and rank cities at risk. This data has also been visualised through a web app. nhess.copernicus.org/articles/25/...
#Vscode #Sql #AzureDataStudio #SyntaxHighlighting
Good friends, is there a VS Code extension that offers a mature SQL Syntax Highlighter?
Ideally, something that replicates SSMS/ADS? As VSCode is due to replace ADS as the alternative SQL IDE... this is a QoL must 🥹🫶🏽
Good friends, is there a VS Code extension that offers a mature SQL Syntax Highlighter?
Ideally, something that replicates SSMS/ADS? As VSCode is due to replace ADS as the alternative SQL IDE... this is a QoL must 🥹🫶🏽
August 12, 2025 at 6:34 AM
#Vscode #Sql #AzureDataStudio #SyntaxHighlighting
Good friends, is there a VS Code extension that offers a mature SQL Syntax Highlighter?
Ideally, something that replicates SSMS/ADS? As VSCode is due to replace ADS as the alternative SQL IDE... this is a QoL must 🥹🫶🏽
Good friends, is there a VS Code extension that offers a mature SQL Syntax Highlighter?
Ideally, something that replicates SSMS/ADS? As VSCode is due to replace ADS as the alternative SQL IDE... this is a QoL must 🥹🫶🏽
I am not alone saying VSCode is wonderful and essentially in infinite ways...However, it is categorically NOT a nice nor superior alternative to Azure Data Studio / SSMS
I'm internally crushed that ADS is being depricated in Feb26. It shouldnt have to be this way.
RIP
I'm internally crushed that ADS is being depricated in Feb26. It shouldnt have to be this way.
RIP
a man wearing a yellow vest and tie is screaming with his mouth open
ALT: a man wearing a yellow vest and tie is screaming with his mouth open
media.tenor.com
August 8, 2025 at 7:45 AM
I am not alone saying VSCode is wonderful and essentially in infinite ways...However, it is categorically NOT a nice nor superior alternative to Azure Data Studio / SSMS
I'm internally crushed that ADS is being depricated in Feb26. It shouldnt have to be this way.
RIP
I'm internally crushed that ADS is being depricated in Feb26. It shouldnt have to be this way.
RIP
Reposted by PBI Queryous
German companies love on-prem so much.
August 7, 2025 at 3:54 PM
German companies love on-prem so much.
Reposted by PBI Queryous
"Bluesky is dying"
Oh yeah? Then explain why this GIF always does numbers.
Oh yeah? Then explain why this GIF always does numbers.
two men are standing next to each other holding guns in a field .
ALT: two men are standing next to each other holding guns in a field .
media.tenor.com
August 7, 2025 at 6:37 PM
"Bluesky is dying"
Oh yeah? Then explain why this GIF always does numbers.
Oh yeah? Then explain why this GIF always does numbers.
Reposted by PBI Queryous
I so don't love YAML. Delimiting code by using indents has never been a good idea. Just spent ages finding an issue with one space. Also looking at you Power BI TMDL.
August 8, 2025 at 5:57 AM
I so don't love YAML. Delimiting code by using indents has never been a good idea. Just spent ages finding an issue with one space. Also looking at you Power BI TMDL.
Reposted by PBI Queryous
Did you know you can allow the report viewer to choose whether to display numbers in millions / billions, with / without decimals?
Check it out..
📺 youtu.be/31vWlmD4aO8&...
#PowerBI
Check it out..
📺 youtu.be/31vWlmD4aO8&...
#PowerBI
July 31, 2025 at 2:30 AM
Did you know you can allow the report viewer to choose whether to display numbers in millions / billions, with / without decimals?
Check it out..
📺 youtu.be/31vWlmD4aO8&...
#PowerBI
Check it out..
📺 youtu.be/31vWlmD4aO8&...
#PowerBI
Reposted by PBI Queryous
A delightful watch, if you're having a lazy weekend like I am and happen to be into #cartography #maps and #dataviz.
youtu.be/Qm6rFQMtiWE
youtu.be/Qm6rFQMtiWE
The History of Fantasy Maps
YouTube video by Jess of the Shire
youtu.be
June 28, 2025 at 8:18 PM
A delightful watch, if you're having a lazy weekend like I am and happen to be into #cartography #maps and #dataviz.
youtu.be/Qm6rFQMtiWE
youtu.be/Qm6rFQMtiWE
Reposted by PBI Queryous
What's the most underrated Power BI feature?
youtu.be/S47MtiVTwp8?...
#metrics #BusinessIntelligence #DataDrivenBusiness #PowerBITraining
youtu.be/S47MtiVTwp8?...
#metrics #BusinessIntelligence #DataDrivenBusiness #PowerBITraining
Power BI Metrics: Why are they so underutilised?
YouTube video by Geordie Intelligence #PowerBI
youtu.be
June 2, 2025 at 12:34 PM
What's the most underrated Power BI feature?
youtu.be/S47MtiVTwp8?...
#metrics #BusinessIntelligence #DataDrivenBusiness #PowerBITraining
youtu.be/S47MtiVTwp8?...
#metrics #BusinessIntelligence #DataDrivenBusiness #PowerBITraining
Reposted by PBI Queryous
The SQL Server 2025 public preview is here!
I wrote a blog post summarizing my first impressions of the JSON datatype and the brand-new JSON index.
TL;DR: it's looking very promising.
sqlsunday.com/2025/05/19/j...
I wrote a blog post summarizing my first impressions of the JSON datatype and the brand-new JSON index.
TL;DR: it's looking very promising.
sqlsunday.com/2025/05/19/j...
JSON indexes in SQL Server: First impressions – sqlsunday.com
sqlsunday.com
May 19, 2025 at 5:02 PM
The SQL Server 2025 public preview is here!
I wrote a blog post summarizing my first impressions of the JSON datatype and the brand-new JSON index.
TL;DR: it's looking very promising.
sqlsunday.com/2025/05/19/j...
I wrote a blog post summarizing my first impressions of the JSON datatype and the brand-new JSON index.
TL;DR: it's looking very promising.
sqlsunday.com/2025/05/19/j...
Reposted by PBI Queryous
The Spanish words 'año' (year) and 'España' (Spain) contain the letter ñ, called eñe.
It comes from a double nn.
One of the n's was abbreviated as a squiggle on top of the other: ñ.
'Año' comes from Latin 'annum' with nn, but 'España' comes from 'Hispāniam'. My graphic explains how it got its ñ:
It comes from a double nn.
One of the n's was abbreviated as a squiggle on top of the other: ñ.
'Año' comes from Latin 'annum' with nn, but 'España' comes from 'Hispāniam'. My graphic explains how it got its ñ:
May 18, 2025 at 6:27 PM
The Spanish words 'año' (year) and 'España' (Spain) contain the letter ñ, called eñe.
It comes from a double nn.
One of the n's was abbreviated as a squiggle on top of the other: ñ.
'Año' comes from Latin 'annum' with nn, but 'España' comes from 'Hispāniam'. My graphic explains how it got its ñ:
It comes from a double nn.
One of the n's was abbreviated as a squiggle on top of the other: ñ.
'Año' comes from Latin 'annum' with nn, but 'España' comes from 'Hispāniam'. My graphic explains how it got its ñ:
Reposted by PBI Queryous
Incredibly interesting read for folk with an interest in NZ Politics and/or racism in politics.
Very good explainer here of where we're at with this (prepare for Brownlee-inspired filibuster!) and why (obvious racism is obvious). One of those rare moments when the press gallery and Speaker feel really on point because this time, The Game is The Stakes.
The House: Parliamentary privileges - Race as an aggravating factor?
Analysis: Reactions and advice from Parliament's Clerk, Speaker and even the committee chair show it has recommended indefensibly harsh punishments.
www.rnz.co.nz
May 17, 2025 at 2:55 AM
Incredibly interesting read for folk with an interest in NZ Politics and/or racism in politics.
Reposted by PBI Queryous
Thanks so much to Sue Bayes for an amazing intro to #Python in #PowerBI and #Fabric today, with a bit of Python in #Excel with #PowerQuery for good measure! If you weren't able to join us live, or want to see it again, the recording is already available. 🎥 www.youtube.com/watch?v=vya9...
Getting Started with Python | Sue Bayes | VanPUG PBI Ed - May 2025
YouTube video by Skillwave Training
www.youtube.com
May 15, 2025 at 8:34 PM
Thanks so much to Sue Bayes for an amazing intro to #Python in #PowerBI and #Fabric today, with a bit of Python in #Excel with #PowerQuery for good measure! If you weren't able to join us live, or want to see it again, the recording is already available. 🎥 www.youtube.com/watch?v=vya9...
Reposted by PBI Queryous
Reposted by PBI Queryous
To reduce the cognitive load in data visualizations, directly label your data rather than using legends. This helps colorblind or visually impaired users. It also decreases the work of scanning back and forth trying to match the legend with the data.
May 14, 2025 at 3:42 AM
To reduce the cognitive load in data visualizations, directly label your data rather than using legends. This helps colorblind or visually impaired users. It also decreases the work of scanning back and forth trying to match the legend with the data.
Reposted by PBI Queryous
English 'wood', Dutch 'woud', and German 'Wald' can all mean "forest".
However, despite their similar forms, 'wood' is not in any way etymologically related to 'woud' or 'Wald'.
'Woud' and 'Wald', which do have a common ancestor, are related to English 'wold' instead.
Click my graphic for more:
However, despite their similar forms, 'wood' is not in any way etymologically related to 'woud' or 'Wald'.
'Woud' and 'Wald', which do have a common ancestor, are related to English 'wold' instead.
Click my graphic for more:
May 10, 2025 at 10:32 AM
English 'wood', Dutch 'woud', and German 'Wald' can all mean "forest".
However, despite their similar forms, 'wood' is not in any way etymologically related to 'woud' or 'Wald'.
'Woud' and 'Wald', which do have a common ancestor, are related to English 'wold' instead.
Click my graphic for more:
However, despite their similar forms, 'wood' is not in any way etymologically related to 'woud' or 'Wald'.
'Woud' and 'Wald', which do have a common ancestor, are related to English 'wold' instead.
Click my graphic for more:
Reposted by PBI Queryous
Reposted by PBI Queryous
Last call! Do you see yourself in this data - you could! Join over 280 other participants and log your step data from April 13-18th here: forms.gle/xHwbNWe6TkRG...
I'm moving to the Twin Cities next week, so I've got to prep boxes instead of data. Survey stays open through 5/18!
I'm moving to the Twin Cities next week, so I've got to prep boxes instead of data. Survey stays open through 5/18!
May 5, 2025 at 12:19 PM
Last call! Do you see yourself in this data - you could! Join over 280 other participants and log your step data from April 13-18th here: forms.gle/xHwbNWe6TkRG...
I'm moving to the Twin Cities next week, so I've got to prep boxes instead of data. Survey stays open through 5/18!
I'm moving to the Twin Cities next week, so I've got to prep boxes instead of data. Survey stays open through 5/18!