Forum Discussion

tjd's avatar
tjd
Icon for Impactful Individual rankImpactful 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 ...
pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft 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
10 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!