Mattias De Smet

Jul 31 2024

Business Intelligence, Technology

Power BI : Desktop client errors

by mattias

No Comments

When working with PowerBI Desktop, you can encounter various error messages, which usually put you on the right track explaining what you’re doing wrong. However, there is also another category...

Desktop, dll, errors, json, newtonsoft, PowerBI

Jul 30 2024

Azure, Business Intelligence, Technology

Fabric : Introduction to Fabric API

by mattias

No Comments

With Fabric taking a more and more prominent role in working with data and organising your data platform, the need for programmatical access or automation is also increasing. Many of...

api, automation, datawarehouse, fabric, powershell, scripting

Jul 24 2024

Azure, Business Intelligence, Technology

Fabric : Warehouse security – custom DB roles

by mattias

No Comments

Fabric is a platform that is taking everyone in the Microsoft data stack with speed. Data for the masses, warehouses at your fingertips, everyone a lakehouse whenever they want. Sounds...

data, fabric, microsoft, ols, security, warehouse

Nov 13 2023

Business Intelligence, Technology

Quick inline tables instead of UNION

by mattias

No Comments

When you need a quick mapping between column values in a SELECT statement in SQLServer, you could write a long block with UNIONS like this A bit more elegant and...

SQLServer, union, values

Nov 12 2023

Azure, Business Intelligence, Technology

Timeout on Power BI table refresh

by mattias

No Comments

While refreshing your PowerBI semantic model in the Desktop always succeeds, you might experience that once you deploy it to the service some of the bigger tables intermittently start to...

connectionstring, dataset, PowerBI, refresh, reporting, timeout