{"id":635,"date":"2025-02-15T07:23:47","date_gmt":"2025-02-15T07:23:47","guid":{"rendered":"https:\/\/datadandies.nl\/?p=635"},"modified":"2025-02-15T07:23:47","modified_gmt":"2025-02-15T07:23:47","slug":"viewing-the-query-plan-of-power-bi-dataflows","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2025\/02\/15\/viewing-the-query-plan-of-power-bi-dataflows\/","title":{"rendered":"Viewing the query plan of Power BI Dataflows"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Did you know you can view the query plan of Power BI Dataflows?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simply right click on a step in the Dataflow and click on \u201cView query plan\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This shows what plan is used to execute the query. You can also see if queries are being folded (if transformations are being done by the database where you get your data from). <a href=\"https:\/\/learn.microsoft.com\/nl-nl\/power-query\/query-plan\">https:\/\/learn.microsoft.com\/nl-nl\/power-query\/query-plan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Did you know you can view the query plan of Power BI Dataflows? Simply right click on a step in the Dataflow and click on \u201cView query plan\u201d. This shows what plan is used to execute the query. You can also see if queries are being folded (if transformations are being done by the database&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2025\/02\/15\/viewing-the-query-plan-of-power-bi-dataflows\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[31,12,3],"class_list":["post-635","post","type-post","status-publish","format-standard","hentry","category-blog","tag-dataflows","tag-performance","tag-powerbi"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=635"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"predecessor-version":[{"id":636,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/635\/revisions\/636"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}