Mattias De Smet

Jul 26 2023

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

Jul 20 2023

Uncategorized

PowerBI: Change PowerBI Desktop language

by mattias

No Comments

Ever woken up to a PowerBI Desktop that suddenly spoke a different language then before? For some reason in Belgium the application likes to revert to French, while I prefer...

Jul 20 2023

Uncategorized

SQL : Locking down disperse SQL databases – part 6 – Unlock Request form

by mattias

No Comments

As the cherry on this multi-layered cake that has a base of SQL logins, KeyVault, a sauce of Azure Functions with a coating of Elastic Jobs all glazed with PowerAutomate,...

Jul 08 2023

Uncategorized

SQL : Locking down disperse SQL databases – part 5 – Approval flow with PowerAutomate

by mattias

No Comments

We’ll design the approval flow in PowerAutomate, which will send out the emails to notify the requestor, trigger the unlock process for the requested database, and give the opportunity for...

Jul 06 2023

Uncategorized

SQL : Locking down disperse SQL databases – part 4 – Automatic locking with Elastic Jobs

by mattias

No Comments

Now that we setup the logins, the key vault and the function that will do the unlocking, it’s time to make sure any unlocked logins are also automatically locked again,...