Category: Uncategorized

Aug 24 2023

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

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