Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

LocalDateTable - Failing Refresh

Submitted by Anonymous on ‎09-01-2022 01:33 AM

Is anyone else having or had a issue with PowerBI Desktop error "DirectQuery to AS - Platform & Business Service Insights

Failed to save modifications to the server. Error returned: 'Table 'LocalDateTable_60def435-cf12-4cbc-ab69-c1e56614b85f' with ShowAsVariationsOnly property set to '1' must be a target of a variation when variation notation is enabled. '."

Any help resolving this would be welcome
Status: Accepted

Simliar issue has been submited previously(ICM: 331555914), would update here as soon as possible if there is any progress about it.

 

Currently you can try that to check whether it works:

  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

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yingjl
Community Support
Community Support
‎09-01-2022 06:58 PM
Status changed to: Accepted

Simliar issue has been submited previously(ICM: 331555914), would update here as soon as possible if there is any progress about it.

 

Currently you can try that to check whether it works:

  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

 

Best Regards,
Community Support Team _ Yingjie Li

Anonymous
Not applicable
‎09-02-2022 01:57 AM

thanks had seen previous post, tried and solution didnt succeed thanks for reviewing

Idea Statuses