Forum Discussion

tjd's avatar
tjd
Impactful Individual
10 years ago

HIdden Local Date Table

Using DAX studio, I looked at my PBI Desktop tables and noticed that I have 3 hidden LocalDateTable tables.  Is this supposed to be happening?  How does one go about unhiding a hidden date table and deleting it?

 

2 Replies

  • pqian's avatar
    pqian
    Microsoft Employee
    10 years ago

    Yes that is expected. Those are the date tables backing your Date/Time columns. You can disable this by going into Options->Current File->Data Load->Time Intelligence

    • Markus's avatar
      Markus
      New Member
      9 years ago
      pqian wrote:

      Yes that is expected. Those are the date tables backing your Date/Time columns. You can disable this by going into Options->Current File->Data Load->Time Intelligence

      pqians hint is also very valuable for another problem: after the last pbi - update I encountered the issue that formulas referring to date-columns didn't work anymore ("LocalDateTable_ .. contains an error"). Disabling Time Intelligence did the trick!