Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Time Intelligence - Auto date/time error (ShowAsVariationOnly, LocalDateTable)

Sequence of events...   1. I tried to delete a erreneous relationship between two tables, but was unsuccesful. 2. I figured it has something to do with Auto date/time option in Time Intelligence. ...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Could you please provide us more information about your report, so that we can make further analysis.

 

Regards,

Charlie Liao

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-caliao-msft - let me know what information you need.

     

    By the way, the issue fixed it self when I had to recover the pbix file after a computer restart! Thanks for that feature! :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Charlie

     

    I'm currently expeienceing the same error. It happened when I made extensive changes to date fields in Power Query and then attempted a refresh.

     

     

    Model summary:

    Big model model with 49 autogenerated hidden dimDates. I can't see anything funky about this particular date table.  According to  $SYSTEM.TMSCHEMA_TABLES, all of the date tables appear identical in structure.  Deleteing the table prevents the bug (obviously) and allows me to refresh.

     

    Solution to anyone reading this:

    1. Make a backup of your Power BI file
    2. Navigate to Options -> Data Load -> Untick "Auto Date/Time".
    3. Refresh all data
    4. Navigate to Options -> Data Load -> tick "Auto Date/Time".
    5. Refresh all data

    Error output:

     

    Thanks,

    Simon