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
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
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
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
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
Problem Many of us are already aware of the loopin...
2020-04-07
6,773 reads
Koen Verbeeck shows how to easily extract metadata from files in your directories with Power Query.
2015-09-23
3,175 reads
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
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
By Steve Jones
I got this in an email about a week ago from the PASS Data...
By Steve Jones
addleworth – adj. unable to settle the question of whether you’re doing okay in...
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers