Tag: etl

Mar 28 2025

Fabric : Hidden Collection Reference in Copy Activity

by Mattias De Smet

No Comments

In Fabric Data Pipelines, the recommended activity to quickly ingest data is by using Copy Activity. This activity allows you to copy data from various sources to various destinations, when...

Mar 21 2025

Business Intelligence, Technology

Fabric : Can’t remove my Lakehouse

by Mattias De Smet

No Comments

When you want to change your lakehouse strategy (e.g. merging lakehouses without schema to a lakehouse with schema support), or simply cleaning up some POC workspaces you might come across...

Dec 20 2024

Azure, Business Intelligence, Uncategorized

Datalake support in SSIS

by Mattias De Smet

No Comments

While new data modern data warehouse projects are often started with cloud based ETL products like Azure Data Factory, Synapse or Fabric pipelines, many companies still have a large investment...

Nov 05 2024

Business Intelligence

Orchestrate Fabric Data workloads with Airflow

by Mattias De Smet

5 Comments

With so many different Fabric items to work with that allow you to move and transform data, it becomes essential to have a way to “arrange” all that movement of...

Aug 27 2024

Business Intelligence, Technology

PowerBI : refresh a PowerBI semantic model from a SQLAgent job step

by Mattias De Smet

No Comments

The data warehouse technologies and architectures are changing at ever faster pace. Many organisations still have a large investment in a full SQLServer stack to load their data warehouse, but...