Mattias De Smet

Dec 20 2024

Datalake support in SSIS

by mattias

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

2 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

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...

Aug 20 2024

Business Intelligence, Technology

PowerBI : treating fields containing HTML tags

by mattias

No Comments

Some source systems tend to store HTML code in their back-end database, so they can more easily render it in the web UI, and allow the end-user to provide some...

Aug 02 2024

Business Intelligence, Technology

PowerBI : bulk PDF generation

by mattias

No Comments

Generating a PDF from a PowerBI report is simple, there is even a button for that. Or you can subscribe to one and it appears daily in your mailbox. The...