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
Power Query
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,016 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
15,561 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
37,448 reads
Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
7,979 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
Query Folding in Power Query to Improve Performance
In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.
2015-06-03
3,661 reads
Getting Started with Microsoft Power Query for Excel
Power Query, provided as part of Microsoft Power BI self-service solution, is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of Excel add-ins. Read on to learn how to install and get started using it.
2013-12-04
3,337 reads
Blogs
Speaking at SQL Saturday Boston 2023
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Forums
Best Sildenafil Is The Fildena 100mg For Male Protection
Fildena 100 mg is used to deal with sexual issues. This medication is taken...
Building Bonds with Entertainment
Comments posted to this topic are about the item Building Bonds with Entertainment
Closing a Symmetric Key
Comments posted to this topic are about the item Closing a Symmetric Key
Ask SSC