Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Error - failed to save modifications to the server

Help! I cannot do anything anymore and I get this non understandable error:   Last thing I did was get data from excel...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Please follow below steps to check whether it resolves your problem:

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

     

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

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Please follow below steps to check whether it resolves your problem:

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

 

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

 

Best regards,
Yuliana Gu

Nathan43's avatar
Nathan43
New Member
7 years ago

Hi Support Team,

I experience the same "LocateDateTable" error fter editing the name of an existing table. I tried refreshing the data after unticking "Auto Date/Time" in the Data Load options menu, but the result is a Something Went Wrong message.

 

Is there a more recent fix than the process reported here on October 26, 2017?  My power BI desktop installation is current through December 2018.

 

Many thanks