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

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