-
Nested ForEach loops in Azure Data Factory
In a recent project, I tried to copy data from a SharePoint site to an Azure Blob Storage using Azure Data Factory (Copy files from SharePoint to Blob Storage using Azure Data Factory – Syntera). The goal was to enable employees to upload their expense receipts to their SharePoint site using OneDrive’s built-in scan function.…
-
Impact of renaming columns in Power BI
Renaming columns in Power BI can have a severe impact on your reports. Initially, renaming columns in Power BI ensures that your end users don’t have to deal with cryptic system names from your source system. Over time, you may need to change a name of a column because of new terminology or to standardize…
-
Copy files from SharePoint to Blob Storage using Azure Data Factory
Azure Data Factory is a great tool for ETL pipelines, and we love working with it. However, when it comes to the integration with the rest of the non-Azure Microsoft world (especially SharePoint) it can get a bit frustrating. In a recent project I wanted to build a solution, which allows employees to upload documents…
