The initial situation was that the data was being read live from a streaming database. Each record had a current status, and the records could be grouped by product. Now I only want to see the latest record, but also … Continue reading →

With TMDL (Tabular Model Definition Language), model creation can be carried out faster and in a more standardized way by storing code definitions as scripts. For example, a frequently required date dimension can be stored as a script with all … Continue reading →

Using TMDL, entire environments can be prepared in this way. In this example—which can, of course, also be used in production—a complete date table is created exactly as it is typically used. Months and days are sorted in correct calendar … Continue reading →

I was very happy that this feature finally went into public preview! I enjoy developing with UDFs, especially in the SQL Server environment. I had already needed this feature for the following blog post:https://www.flip-design.de/?p=1447 This follows the concept of passing … Continue reading →

I extended the PowerShell script a bit so that it now submits a more complex JSON payload, and I also ensured that the script runs reliably every 10 seconds.https://www.flip-design.de/?p=1495 while ($true) {     [Reflection.Assembly]::LoadWithPartialName(„System.Web“)| out-null     $URI=““   … Continue reading →

Last week, a friend asked me why he could no longer create functioning SVG graphics from Chat GPT that he could use in Power BI. This surprised me a bit. I then entered a query for a graphic there, had … Continue reading →