{"id":526,"date":"2019-01-25T11:56:55","date_gmt":"2019-01-25T10:56:55","guid":{"rendered":"http:\/\/didier-terrien.atwebpages.com\/?p=526"},"modified":"2020-12-16T13:52:03","modified_gmt":"2020-12-16T12:52:03","slug":"add-a-refresh-date-to-your-report","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2019\/01\/25\/add-a-refresh-date-to-your-report\/","title":{"rendered":"Add a refresh date to your report"},"content":{"rendered":"\n<p>Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to add a refresh date to your report<\/h2>\n\n\n\n<p>Create a table using &#8216;Home\/Enter data&#8217; menu and name it as you want. Add a column named &#8216;Index&#8217;. Add one line of data typing zero in &#8216;Index&#8217; column.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"356\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-table-1.png\" alt=\"add a refresh date\" class=\"wp-image-532\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-table-1.png 652w, https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-table-1-300x164.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/figure><\/div>\n\n\n\n<p>Open Power Query and open the query of this table then create a column : <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ThisStep = Table.AddColumn(PreviousStep, \"Last refresh date\", each DateTime.LocalNow(), type datetime)<\/code><\/pre>\n\n\n\n<p>Use this column in a card visual. The date &amp; time will be updated when you refresh your report. It will not be updated when you simply open the report.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\t\t\t<div class=\"wp-block-uagb-post-carousel uagb-post-grid  uagb-post__image-position-top uagb-post__image-enabled uagb-block-b4d81b5c     uagb-post__arrow-outside uagb-slick-carousel uagb-post__items uagb-post__columns-3 is-carousel uagb-post__columns-tablet-2 uagb-post__columns-mobile-1\" data-total=\"5\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"674\" height=\"193\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png\" class=\"attachment-large size-large\" alt=\"Custom analyser\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png 674w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-300x86.png 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Custom analyser<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>With &#8216;Custom analyser&#8217; feature, Power BI Sidetools users can use external tools built by the&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"592\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png\" class=\"attachment-large size-large\" alt=\"DAX debugger\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-300x173.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-768x444.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1320x763.png 1320w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger.png 1452w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">DAX debugger in Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>DAX debugger is meant to help Power BI report developers displaying sample data from a&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"817\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager.png\" class=\"attachment-large size-large\" alt=\"External tools manager\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager.png 817w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager-300x182.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager-768x465.png 768w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Manage your external tools easily with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Since the Power BI team allowed to launch external tools from the Power BI desktop&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"414\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1024x414.png\" class=\"attachment-large size-large\" alt=\"Export to Excel\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1024x414.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-300x121.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-768x311.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1536x621.png 1536w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1320x534.png 1320w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel.png 1854w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Easily export to Excel with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>While working in Power BI desktop, we often need to export to Excel some data&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"209\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-1024x209.png\" class=\"attachment-large size-large\" alt=\"search\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-1024x209.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-300x61.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-768x156.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6.png 1286w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Powerful text and file search in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>As Power BI Sidetools creates files from your report, you are able to search through&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"294\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-1024x294.png\" class=\"attachment-large size-large\" alt=\"Visual Studio Code\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-1024x294.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-300x86.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-768x220.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5.png 1269w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Compare DAX and M formulas in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Compare DAX and M formulas in Visual Studio Code is really easy with the help&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual. How to add a refresh date to your report Create a table using &#8216;Home\/Enter data&#8217; menu and name it as you want. Add a&#8230;<\/p>\n","protected":false},"author":2,"featured_media":530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[2,3,7],"tags":[24,28,63],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Last-refresh-1.png",144,44,false]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":1,"uagb_excerpt":"Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual. How to add a refresh date to your report Create a table using &#8216;Home\/Enter data&#8217; menu and name it as you want. Add a...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/526"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":7,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"predecessor-version":[{"id":3655,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/526\/revisions\/3655"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/530"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}