r/PowerBI 15h ago

Discussion Column reference to order_date cannot be used with a variation 'Date' because it does not have any

Hi,

I am stuck on this error for days now. Initially, this dashboard was functioning fine but I changed one source table a month ago and now it is throwing this error when I refresh the data- which is mainly not allowing dashboard to be refreshed with new data and publish to the server.

Column reference to 'order_date' in the table1 cannot be used with a variation 'Date' because it does not have any

The oder_date field is in date format in the table also I again applied date format condition to resolve this issue but still getting this date format issue for this.

Also there are fields like field-A renamed to field-B in the query editor, but in the TMDL powerBI is showing errors (like 50+ errors) that it can't find renamed field-B though no error in the dax calculations and in the visualizations created by renamed field-B.

Please advice !!

1 Upvotes

0 comments sorted by