{"id":4642,"date":"2020-05-23T16:14:12","date_gmt":"2020-05-23T08:14:12","guid":{"rendered":"https:\/\/tommykwan.com\/blog\/?p=4642"},"modified":"2020-05-23T16:14:12","modified_gmt":"2020-05-23T08:14:12","slug":"auto-date-time-for-new-files-option-global-data-load-setting","status":"publish","type":"post","link":"https:\/\/tommykwan.com\/blog\/it\/power-bi\/auto-date-time-for-new-files-option-global-data-load-setting\/","title":{"rendered":"Auto date\/time for new files option (Global Data Load Setting)"},"content":{"rendered":"[Ref <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-auto-date-time\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft<\/a>]\n<p>Auto date\/time tables are permanently hidden, even from modelers. They cannot be seen in the\u00a0<strong>Fields<\/strong>\u00a0pane or the Model view diagram, and its rows cannot be seen in Data view. Also, the table and its column cannot be directly referenced by DAX expressions.<\/p>\n<p>Further, it&#8217;s not possible to work with them when using\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-analyze-in-excel\" data-linktype=\"relative-path\">Analyze in Excel<\/a>, or connecting to the model using non-Power BI report designers.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Ref Microsoft] Auto date\/time tables are permanently hidden, even from modelers. They cannot be seen in the\u00a0Fields\u00a0pane or the Model view diagram, and its rows cannot be seen in Data view. Also, the table and its column cannot be directly referenced by DAX expressions. Further, it&#8217;s not possible to work with them when using\u00a0Analyze in<a class=\"read-more \" href=\"https:\/\/tommykwan.com\/blog\/it\/power-bi\/auto-date-time-for-new-files-option-global-data-load-setting\/\" title=\"Read More\"> <span class=\"button default\">Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-4642","post","type-post","status-publish","format-standard","hentry","category-power-bi"],"_links":{"self":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts\/4642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/comments?post=4642"}],"version-history":[{"count":1,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts\/4642\/revisions"}],"predecessor-version":[{"id":4643,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/posts\/4642\/revisions\/4643"}],"wp:attachment":[{"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/media?parent=4642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/categories?post=4642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tommykwan.com\/blog\/wp-json\/wp\/v2\/tags?post=4642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}