Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jamesholland198
Frequent Visitor

ShowAsVariationsOnly property set to '1' must be a target of a variation

Hi,

 

I have a number of reports which connect to a PowerBI dataset via DirectQuery.

 

Whenever I try to refresh these reports in Desktop (to pull in any new fields I add to the main dataset) I get the error:

 

DirectQuery to AS - BI Master Dataset
Failed to save modifications to the server. Error returned: 'Table 'LocalDateTable_db4877ee-c5af-4962-9ebd-c4047ab8df00' with ShowAsVariationsOnly property set to '1' must be a target of a variation when variation notation is enabled. '.
 
I have tried disabling/re-enabling Auto date/time but it hasn't helped.
 
This is turning into a very big problem as I have about 30 different reports which connect into this dataset.
 
Any help would be hugely appreciated.
 
Thanks,
1 REPLY 1
amitchandak
Super User
Super User

@jamesholland198 , Hope you have tried the steps in this order

 

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.