flip-it.de :: SQL, BI and more

Main menu

Skip to content
  • Datenschutzerklärung
  • Me, myself and I
  • Impressum

Power BI User Defined Functions – DAX UDFs

24. September 2025

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 →

Posted in Allgemein

How to capture stream data within Fabric in a KQL database

22. September 2025

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 →

Posted in Allgemein

Create SVG images for Power BI by using Chat GPT

18. September 2025

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 →

Posted in Allgemein

How do I update a record in a table within Power BI using Translytical Dataflows

25. August 2025

In this post, I’d like to provide an update to the following post: https://www.flip-design.de/?p=1480 . In that post, I didn’t describe how, for example, to use a key figure to select the corresponding data record from a table and pass … Continue reading →

Posted in Allgemein

Power Shell script to send a simple JSON to an Azure Event Hub

24. August 2025

Until now, I’ve always used a C# program provided to me to send events to an Azure Event Hub. This actually became a bit too heavy-duty for me over time. So I looked for a PowerShell alternative, but couldn’t really … Continue reading →

Posted in Allgemein

Translytical – or how to write data in a database

29. Juli 2025

„Translytical“ is a term used in data management and analytics that combines „transactional“ and „analytical“ processing. source: ChatGPT This new functionality within Power BI offers the ability to write, modify, and delete data within the database. This functionality is currently … Continue reading →

Posted in Allgemein

Post navigation

← Older posts
Newer posts →

Neueste Beiträge

  • Power BI & Fabric: Automated Deployment with Azure DevOps and PowerShell
  • Power BI Desktop: Efficient Development with Large Data Volumes
  • Translating Power BI Semantic Models with PowerShell
  • Partitioning Power BI data models with TMDL
  • Power BI Desktop Bridge – Creating Power BI Reports Using the New Bridge and Codex

Archiv

  • Oktober 2026
  • September 2026
  • August 2026
  • Juli 2026
  • Juni 2026
  • Mai 2026
  • März 2026
  • Februar 2026
  • Januar 2026
  • November 2025
  • Oktober 2025
  • September 2025
  • August 2025
  • Juli 2025
  • Mai 2025
  • März 2025
  • November 2024
  • September 2024
  • August 2024
  • Juni 2024
  • April 2024
  • März 2024
  • Oktober 2023
  • September 2023
  • August 2023
  • Mai 2023
  • Februar 2023
  • Januar 2023
  • Dezember 2022
  • November 2022
  • Oktober 2022
  • September 2022
  • August 2022
  • Juli 2022
  • Juni 2022
  • Mai 2022
  • April 2022
  • März 2022
  • Januar 2022
  • Dezember 2021
  • November 2021
  • September 2021
  • August 2021
  • Juli 2021
  • Juni 2021
  • Mai 2021
  • April 2021
  • März 2021
  • Februar 2021
  • Januar 2021
  • Dezember 2020
  • November 2020
  • August 2020
  • Juni 2020
  • Dezember 2019
  • Mai 2019
  • Februar 2019
  • Dezember 2018
  • November 2018
  • Oktober 2018
  • August 2018
  • Juli 2018
  • November 2017
  • September 2016
  • Februar 2016
  • November 2015
  • Juli 2015
  • April 2015
  • September 2014
  • August 2014
  • Juli 2014
  • Juni 2014
  • Mai 2014
  • Februar 2014
  • Januar 2014
  • Dezember 2013
  • November 2013
  • Oktober 2013
  • August 2013
  • Juli 2013
  • April 2013
  • Januar 2013
  • Dezember 2012
  • November 2012
  • November 2011
  • Oktober 2011
  • September 2011
  • August 2011
  • Juni 2011
  • April 2011
  • März 2011
  • Februar 2011
  • Januar 2011
  • Mai 2009
Powered by WordPress and Foghorn