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
3,363 reads
Power Query
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
10,249 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
28,291 reads
Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
6,772 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Open Enrollment at WordPress.com: Free Websites for Students
By Rob Sewell
A website can change the world. If you're a student, we'd like to help...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Forums
New article
Comments posted to this topic are about the item New article
Monitoring Azure Blob Storage
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers