Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
Jul 30 2024
Azure, Business Intelligence, Technology

Fabric : Introduction to Fabric API

by Mattias De Smet
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 De Smet
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 De Smet
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 De Smet
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
Nov 11 2023
Azure, Business Intelligence, Technology

Azure Data Factory and DB2 Codepages

by Mattias De Smet
No Comments
Having the option to connect to DB2 from Azure Data Factory is a great help in migrating from more legacy database platforms to the cloud. Or to ingest these systems...
adf, as400, azure, Azure Data Factory, DB2, etl

Posts pagination

1 2 3 4 … 10

Curious technological cases present themselves to me in my day to day life. While solving them, I write down my findings and hope I can help others with this summary.

Read more

  • Fabric Data Engineer Associate (DP-700)
  • Fabric Analytics Engineer Associate (DP-600)
  • Power BI Data Analyst Associate

Buy me a coffee

Categories

  • Azure (21)
  • Business Intelligence (30)
  • Navision (4)
  • Technology (12)
  • Uncategorized (8)

Tags

access_token api .net authorization Azure Data Factory active directory array assembly adf authentication administration 0NF airflow azure as400 admin automation ad agent analysis services
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe

  • March 2025
  • February 2025
  • December 2024
  • November 2024
  • August 2024
  • July 2024
  • November 2023
  • August 2023
  • July 2023
  • June 2023
  • January 2023
  • August 2022
  • June 2020
  • May 2020
  • April 2020
  • April 2018
  • March 2018

Buy me a coffee

Mattias De Smet

Microsoft BI and Azure solved cases
2020 Mattias De Smet