Forum Discussion
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 ...
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
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!