Category: Technology

Nov 09 2023

Azure, Business Intelligence, Technology

Use Power BI APIs from Azure Data Factory

by mattias

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

Jul 26 2023

Business Intelligence, Technology

Change PowerBI report dataset without republishing

by mattias

No Comments

When you try to implement a split workspace setup (Report workspace and Data workspace) in PowerBI starting from an existing set of reports, you could come across one practical challenge...

Jun 26 2023

Azure

SQL : Locking down disperse SQL databases – part 2 – Logins & Keyvault

by mattias

No Comments

In the previous article I explain the full setup of a mechanism to automate the access management of databases across various servers. In this article, I’ll start with the basics:...

Jun 23 2023

Azure, Uncategorized

SQL : Locking down disperse SQL databases – part 1

by mattias

No Comments

In this series, I’ll detail a process to automate giving and removing access to databases. Not just a single one, but different databases over different servers. Introduction The use case...

Jun 18 2023

Business Intelligence

PowerBI : Implementing BYOK

by mattias

No Comments

What is BYOK BYOK is the acronym for Bring Your Own Key. It gives you the ability to use your own encryption key on your data in rest, so you...