HIdden Local Date Table

[tjd]

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?

[pqian]

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]

---

@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!