{"id":1480,"date":"2025-07-29T16:44:39","date_gmt":"2025-07-29T14:44:39","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1480"},"modified":"2025-07-29T16:44:39","modified_gmt":"2025-07-29T14:44:39","slug":"translytical-or-how-to-write-data-in-a-database","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1480","title":{"rendered":"Translytical \u2013 or how to write data in a database"},"content":{"rendered":"\n

„Translytical“ is a term used in data management and analytics that combines „transactional“ and „analytical“ processing.<\/strong> <\/strong><\/strong><\/p>\n\n\n\n

source: ChatGPT<\/p>\n\n\n\n

This new functionality within Power BI offers the ability to write, modify, and delete data within the database. This functionality is currently in preview. It also currently only supports data sources available within Fabric. Additionally, it only requires the Python programming language.<\/p>\n\n\n\n

First, this functionality must be enabled in the Admin Portal. This may seem unnecessary at first, but the functions can only be created via the service.Diese Funktionalit\u00e4t wird generell aktiviert, d. h. sie kann nicht nur einzelnen Benutzergruppen zur Verf\u00fcgung gestellt werden.<\/p>\n\n\n\n

Nun kann man innerhalb eines Arbeitsbereiches, der selbstverst\u00e4ndlich mit einer Fabric Kapazit\u00e4t verbunden sein muss, die sogenannten UDF\u2019s erstellen.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Once this has been created, a new function can be stored in this container.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

To write or modify corresponding data, a corresponding data source must be configured. This is done using the following switch:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

You can then select a data source. This screenshot shows the selection of supported data sources. It’s important that the data source is located within Fabric and that a SQL endpoint is offered. Then you can select it here.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

I’m not really a Python expert myself, but when you’re in the function’s edit mode, you can select appropriate templates.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Once the connection has been established, it must be passed to the function. In this example, I’m using only one. Of course, several can be used for different use cases. Here, the data source is simply sqldb, so no adjustments are necessary.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

As you can see here, any SQL query supported by the source can be passed.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Here’s a complete example:<\/p>\n\n\n\n

In this example, I’ve configured two separate functions within the function, each of which accepts a parameter and uses it for filtering in the Where condition. This simply updates the corresponding data.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

I then created the report within Power BI Desktop. It’s important to establish a live connection. Technically, this isn’t absolutely necessary, meaning data can also be imported, but to ensure the results are visible promptly, this is better used for this purpose. To implement filtering with slicers, the new one must be used.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

To trigger the functions, I implemented two buttons and selected them via the actions and used the parameter from the slicer.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Even though a Direct Query connection was used here, the updates to the database aren’t visible in the report until approximately 30 seconds later. However, the database update was made immediately. The reason for this is that the semantic model caches the data and doesn’t immediately make the changes visible. Unfortunately, changing the configuration on the service doesn’t make any difference.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

„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 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1480"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1480"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1480\/revisions"}],"predecessor-version":[{"id":1493,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1480\/revisions\/1493"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}