Comparing Groups for Similarities in Power Query – Using Cosine Similarity
Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.
2025-01-10
Power Query
Power Query Editor in Power BI for Formatting Text Columns
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
2023-10-27
Getting Started with Power Query M Language in Excel
This article introduces M language concepts and examples of using M to manipulate data in Excel.
2023-10-02
Using Power Query to Combine Data from Multiple Sheets in Excel
This article employs Power Query features to combine queries and implement requirements in different listed scenarios.
2023-08-07
Why Power Query as an Activity in Azure Data Factory and SSIS?
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
2021-07-26
4,385 reads
Common Data Transformations in Power Query
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
2021-04-21
Power Query or SQL Server? Which, when and why
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
16,846 reads
Create Custom Functions in Power Query
Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]
2020-04-21
41,155 reads
Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
8,467 reads
Retrieve file sizes from the file system using Power Query
Koen Verbeeck shows how to easily extract metadata from files in your directories with Power Query.
2015-09-23
3,175 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers