-
Power BI – Combine all files from folder
In my last blog post, I wrote about the easiest ways to import data from Excel files hosted on SharePoint into Power BI. Another scenario that I encounter frequently is the use of recurring flat file exports from source systems like ERPs, CRMs, or databases, typically as daily or weekly exports. This approach is often…
-
Power BI data from Excel on Sharepoint
When teaching others how to work with Power BI, I almost always start with the same example: working with a simple Excel file. Typically, the file is stored on SharePoint, and we import the data into Power BI to explore and work on this basic scenario. This approach isn’t just for demonstration purposes, it also…
-
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…
