Mattias De Smet

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

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