{"id":890,"date":"2024-07-15T15:44:02","date_gmt":"2024-07-15T15:44:02","guid":{"rendered":"https:\/\/fubuha.com\/?p=890"},"modified":"2024-08-11T13:38:11","modified_gmt":"2024-08-11T13:38:11","slug":"elementor-890","status":"publish","type":"post","link":"https:\/\/fubuha.com\/?p=890","title":{"rendered":"Refresh Button for DataSet in Power BI Report"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"890\" class=\"elementor elementor-890\">\n\t\t\t\t<div class=\"elementor-element elementor-element-18861f9 e-flex e-con-boxed e-con e-parent\" data-id=\"18861f9\" data-element_type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0c072de elementor-widget elementor-widget-heading\" data-id=\"0c072de\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.22.0 - 26-06-2024 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Refresh Button for DataSet in Power BI Report<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dd8a331 e-flex e-con-boxed e-con e-parent\" data-id=\"dd8a331\" data-element_type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c6eb4db elementor-widget elementor-widget-text-editor\" data-id=\"c6eb4db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.22.0 - 26-06-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Refreshing a DataSet from a report item &#8211; adding a Refresh Button to a PowerBI report<br \/>To create a refresh button for a data set, follow the steps below.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-07c02f9 e-flex e-con-boxed e-con e-parent\" data-id=\"07c02f9\" data-element_type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-090691f elementor-widget elementor-widget-text-editor\" data-id=\"090691f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>1. Check if you have Power Automate in your Power BI visualization tools. If not, install it from Power BI visuals.&#8221;<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":141,\"sizeSlug\":\"full\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"wp-image-141\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-8.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>2. Click on the Power Automate for Power BI icon.<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":135,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-135\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-2-1024x563.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>3. On the report page screen, the Power Automate component window will appear &#8211; click on the three dots (located at the bottom of the component), and then click on &#8216;Edit&#8217;.<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":134,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-134\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-1-1024x562.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>4. On the screen, the Microsoft Power Automate window will be displayed. At the top of the window, click on &#8216;New,&#8217; and then select &#8216;Instant cloud flow<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":136,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-136\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-3-1024x559.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>5. You have been redirected to a new flow &#8211; click &#8216;New step&#8217; &#8211; in the search window, type &#8216;Power BI&#8217; &#8211; the list will be filtered. From the list below, select &#8216;Refresh a dataset&#8217;<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":137,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-137\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-4-1024x722.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>6. Next, fill in the 2 fields &#8211; Workspace and dataset &#8211; specify the location and the specific dataset you want to refresh from the report position. Then, click &#8216;Save&#8217;<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":138,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-138\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-5-1024x566.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>7. Now, you can click &#8216;Back to Report.&#8217; A button has been created on the screen, which is used to refresh the selected Dataset. <br \/>You can edit its size\/color and position to customize it for the chosen report. Save your report and click &#8216;Publish&#8217;<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":139,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-139\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-6-1024x581.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>8. Now, you can click &#8216;Back to Report.&#8217; A button has been created on the screen, which serves to refresh the selected Dataset. You can edit its size, color, and position to customize it for the chosen report. Save your report and click &#8216;Publish&#8217;<\/p><p><!-- \/wp:paragraph --><!-- wp:image {\"id\":140,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} --><\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-140\" src=\"https:\/\/blog.fubuha.com\/wp-content\/uploads\/2023\/12\/image-7-1024x725.png\" alt=\"\" \/><\/figure><p><!-- \/wp:image --><!-- wp:paragraph --><\/p><p>9. Go to the Power BI Service and open the published report. Click the button and enjoy the refreshed Dataset on demand from the report position.<\/p><p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p><p>Creating a refresh button in a Power BI report allows users to manually refresh a specific dataset on demand. With this tool accessible from the report position, users can instantly update data without the need to navigate to other interfaces. This enhancement enables real-time adjustments of information in the report to the latest data, leading to improved and more up-to-date analysis.<\/p><p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p><p>\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Refresh Button for DataSet in Power BI Report Refreshing a DataSet from a report item &#8211; adding a Refresh Button to a PowerBI reportTo create a refresh button for a data set, follow the steps below. 1. Check if you have Power Automate in your Power BI visualization tools. If not, install it from Power [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[60],"acf":[],"_links":{"self":[{"href":"https:\/\/fubuha.com\/index.php?rest_route=\/wp\/v2\/posts\/890"}],"collection":[{"href":"https:\/\/fubuha.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fubuha.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fubuha.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fubuha.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=890"}],"version-history":[{"count":12,"href":"https:\/\/fubuha.com\/index.php?rest_route=\/wp\/v2\/posts\/890\/revisions"}],"predecessor-version":[{"id":1641,"href":"https:\/\/fubuha.com\/index.php?rest_route=\/wp\/v2\/posts\/890\/revisions\/1641"}],"wp:attachment":[{"href":"https:\/\/fubuha.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fubuha.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fubuha.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}