{"id":1498,"date":"2025-08-25T13:00:04","date_gmt":"2025-08-25T11:00:04","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1498"},"modified":"2025-08-25T13:00:04","modified_gmt":"2025-08-25T11:00:04","slug":"how-do-i-update-a-record-in-a-table-within-power-bi-using-translytical-dataflows","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1498","title":{"rendered":"How do I update a record in a table within Power BI using Translytical Dataflows"},"content":{"rendered":"\n<p>In this post, I&#8217;d like to provide an update to the following post: <a href=\"https:\/\/www.flip-design.de\/?p=1480\">https:\/\/www.flip-design.de\/?p=1480<\/a> . In that post, I didn&#8217;t describe how, for example, to use a key figure to select the corresponding data record from a table and pass it on to an update.<\/p>\n\n\n\n<p>To achieve this, I first inserted the data records from the table into a Power BI table. Then I created a corresponding key figure using the following code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>selectedProductId = SELECTEDVALUE('SalesLT Product'&#91;ProductID])<\/code><\/pre>\n\n\n\n<p>Here, I return the unique identifier of the selected record. This key figure can then be used as described:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-1.png\"><img decoding=\"async\" loading=\"lazy\" width=\"940\" height=\"665\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-1.png\" alt=\"\" class=\"wp-image-1499\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-1.png 940w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-1-300x212.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-1-768x543.png 768w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/a><\/figure>\n\n\n\n<p>The corresponding record ID can then be used in the Python function as before to update the record. The record can now be accessed when executing the dataflow.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-2.png\"><img decoding=\"async\" loading=\"lazy\" width=\"940\" height=\"505\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-2.png\" alt=\"\" class=\"wp-image-1500\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-2.png 940w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-2-300x161.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2025\/08\/image-2-768x413.png 768w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In this post, I&#8217;d like to provide an update to the following post: https:\/\/www.flip-design.de\/?p=1480 . In that post, I didn&#8217;t describe how, for example, to use a key figure to select the corresponding data record from a table and pass &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1498\">Continue reading <span class=\"meta-nav\">&rarr;<\/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\/1498"}],"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=1498"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions"}],"predecessor-version":[{"id":1501,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions\/1501"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}