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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bdahlstrom
Regular Visitor

Column ref. to 'ColumnX' in table 'XX' can't be used with a variation 'Date' bc it doesn't have any

I'm receiving the following error:

 

Column reference to 'Business Date' in table 'Day Key' cannot be used with a variation 'Date' because it does not have any. Column reference to 'Business Date' in table 'Day Key' cannot be used with a variation 'Date' because it does not have any. Column reference to 'Business Date' in table 'Day Key' cannot be used with a variation 'Date' because it does not have any. Column reference to 'OPEN DATE' in table 'Cost Center' cannot be used with a variation 'Date' because it does not have any. Column reference to 'OPEN DATE' in table 'Cost Center' cannot be used with a variation 'Date' because it does not have any. Column reference to 'OPEN DATE' in table 'Cost Center' cannot be used with a variation 'Date' because it does not have any.

 

Both columns referenced are 'Date' types in power query and do not error out when I open in power query. Auto/Date time is turned off. The 'Business Date' does have a relationship with a seperate date column but the relationship appears to be working appropriately. These sources haven't been changed in months and has only been an issue since I updated to the latest version of desktop.

1 ACCEPTED SOLUTION
bdahlstrom
Regular Visitor

Want to document how I corrected this issue. There were relationship errors unrelated to the stated column reference errors.

 

Turn on Auto Date Time, Refresh, correct stated errors unrelated to day key or cost center, Turn off Auto Date Time, refreshes as normal. 

View solution in original post

4 REPLIES 4
bdahlstrom
Regular Visitor

Want to document how I corrected this issue. There were relationship errors unrelated to the stated column reference errors.

 

Turn on Auto Date Time, Refresh, correct stated errors unrelated to day key or cost center, Turn off Auto Date Time, refreshes as normal. 

HotChilli
Super User
Super User

OK, I think you need to look elsewhere.  Are there calculated columns in your model? Maybe in a date table.

HotChilli
Super User
Super User

The only times i know this error shows up is when 'Auto date time' is off but something somewhere is using references to , for example .[Date], .[Month]

Can you narrow down where the error is coming from, is it 2 calculated columns or measure?

They are both imported colums with type 'Date'. Auto date time slows the functionality way down and it hasn't been an issue until I tried refreshing today. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors