Mattias De Smet

Jul 30 2024

Azure, Business Intelligence, Technology

Fabric : Introduction to Fabric API

by mattias

No Comments

With Fabric taking a more and more prominent role in working with data and organising your data platform, the need for programmatical access or automation is also increasing. Many of...

api, automation, datawarehouse, fabric, powershell, scripting

Jul 24 2024

Azure, Business Intelligence, Technology

Fabric : Warehouse security – custom DB roles

by mattias

No Comments

Fabric is a platform that is taking everyone in the Microsoft data stack with speed. Data for the masses, warehouses at your fingertips, everyone a lakehouse whenever they want. Sounds...

data, fabric, microsoft, ols, security, warehouse

Nov 13 2023

Business Intelligence, Technology

Quick inline tables instead of UNION

by mattias

No Comments

When you need a quick mapping between column values in a SELECT statement in SQLServer, you could write a long block with UNIONS like this A bit more elegant and...

SQLServer, union, values

Nov 12 2023

Azure, Business Intelligence, Technology

Timeout on Power BI table refresh

by mattias

No Comments

While refreshing your PowerBI semantic model in the Desktop always succeeds, you might experience that once you deploy it to the service some of the bigger tables intermittently start to...

connectionstring, dataset, PowerBI, refresh, reporting, timeout

Nov 11 2023

Azure, Business Intelligence, Technology

Azure Data Factory and DB2 Codepages

by mattias

No Comments

Having the option to connect to DB2 from Azure Data Factory is a great help in migrating from more legacy database platforms to the cloud. Or to ingest these systems...

adf, as400, azure, Azure Data Factory, DB2, etl