Mattias De Smet

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

Nov 09 2023

Azure, Business Intelligence, Technology

Use Power BI APIs from Azure Data Factory

by mattias

No Comments

Prerequisites  The preferred way to use the PowerBI API from Azure Data Factory (ADF) is by using a Service Principal. This has the benefit of not requiring a license assigned to...

adf, api, azure, Azure Data Factory, PowerBI, REST, Service Principal

Aug 24 2023

Uncategorized

DAX Optimizer – quick review

by mattias

No Comments

Intro As a PowerBI professional, you will surely value tools like DAX Studio and Tabular Editor as they are essential for efficient development of PowerBI datamodels and understanding and improving...