cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Martyes1 Visitor
Visitor

Data Modeling Help - ShowAsVariationOnly Error

Hello Everyone,

 

When I attempt to apply query changes to my data model I get this error: Failed to save modifications to the server. Error returned: 'Table 'LocalDateTable_e63b5d89-53a-48e5-839e47964572od92' with ShowAsVariationOnly property set to '1' must be a target of a variation notation is enabled. '.

 

Has anyone came across this and know how to fix it? Also, do you know where in the Power BI edit screen I can find the name :

 

 'LocalDateTable_e63b5d89-53a-48e5-839e47964572od92' ?

 

Thanks,

Marty

1 REPLY 1
Moderator v-caliao-msft
Moderator

Re: Data Modeling Help - ShowAsVariationOnly Error

@Martyes1,

 

Which modification did you make in your data model? Please try the steps below and check if this issue persists or not.

 

  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

Regards,

Charlie Liao