Mattias De Smet

May 24 2020

Navision

Navision: Track Maximum & Average Users by day using PowerBI

by mattias

No Comments

With its simple Active Sessions table, Navision doesn’t provide an option out-of-the-box to track usage information. I will describe a mechanism that will allow you to understand what the maximum...

dax, maximum, navision, optimize, PowerBI, session, trigger, tsal, usage

May 16 2020

Business Intelligence

PowerBI for SQL Server Agent jobs

by mattias

No Comments

In a SQLServer datawarehouse you might have a lot of jobs scheduled through SQL Server Agent. There is little out of the box visibility on the status of those jobs,...

email, etl, PowerBI, SQLServer

May 12 2020

Business Intelligence

Expressions on ConnectionString issue in SSIS 2019

by mattias

No Comments

In SQLServer Integration Services, the use of Expressions to replace properties at runtime is very powerful. You can use it in combination with variables to pass parameters to queries, determine...

database, datawarehouse, etl, sql, SQLServer, ssis

May 10 2020

Azure

Power Automate : Uploading email attachments to DevOps issue

by mattias

No Comments

Creating issues in DevOps is easy enough, but frequently issues arise from an email received from the business users, with much the same details as you’d need to put in...

devops, email, flow, function, json, powerautomate

May 01 2020

Azure

Scaling Power Automate using Azure Queues

by mattias

No Comments

Often enough, a single Power Automate flow can be a perfect solution for a simple task. But when you start copying that solution for different triggers, it can soon become...

automation, email, flow, json, queue