Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
Mar 28 2025
Azure, Business Intelligence

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...
api, array, copy activity, data pipeline, datawarehouse, etl, fabric, json, nested, REST
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...
admin, etl, fabric, feature, git, lakehouse, source control, tenant
Feb 20 2025
Business Intelligence

PowerBI : Git integration for Reports with Live connections

by Mattias De Smet
No Comments
Working with Git integration on PowerBI (and Fabric) workspaces helps you overcome a lot of the limitations that working with PowerBI Desktop and PBIX files present. This is quite a...
fabric, git, live, PowerBI, reporting, sourcecontrol, vscode
Dec 27 2024
Azure

Get notified when Azure secrets are about to expire

by Mattias De Smet
No Comments
Using Azure EntraID App Registrations is almost essential for any type of application security or person-independant access to APIs and other autorization flows. Always follow the best practices when setting...
api, azure, entraid, powershell, secrets, security
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...
azure, datalake, etl, SQLServer, ssis

Posts pagination

1 2 … 10

Curious technological cases present themselves to me in my day to day life. While solving them, I write down my findings and hope I can help others with this summary.

Read more

  • Fabric Data Engineer Associate (DP-700)
  • Fabric Analytics Engineer Associate (DP-600)
  • Power BI Data Analyst Associate

Buy me a coffee

Categories

  • Azure (21)
  • Business Intelligence (30)
  • Navision (4)
  • Technology (12)
  • Uncategorized (8)

Tags

admin as400 adf connection backup agent analysis services airflow bi cleaning dataset ad 0NF connectionstring certificate azure sql db Azure Data Factory dba azure automation byok .net active directory data api data pipeline compute access_token business rules bearer cube child assembly db DB2 administration authentication copy activity array datawarehouse dax datalake database controller authorization
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe

  • March 2025
  • February 2025
  • December 2024
  • November 2024
  • August 2024
  • July 2024
  • November 2023
  • August 2023
  • July 2023
  • June 2023
  • January 2023
  • August 2022
  • June 2020
  • May 2020
  • April 2020
  • April 2018
  • March 2018

Buy me a coffee

Mattias De Smet

Microsoft BI and Azure solved cases
2020 Mattias De Smet