Forum Discussion
Add Column - Date Strange issue
Hello!
I am attempting to add column, Date, Month name.
I am able to add it as a number (i.e Jan is 1) but when i set it to name, It tells me the function isnt possible in direct query?
I do not understand why i am able to do one but not the other?
I have tried many work arounds, but i am confused as to what i am doing wrong!
Thank you all
There is a limited set of Power Query transforms that are allowed in Direct Query. It looks like one of the date functions is allowed and one isn't.
You can probably do it in DAX with a measure (or possibly a calculated column - you will have to try it).
Or add it in the source db.
Or use Import model (or composite model) if there are lots of new columns required
6 Replies
Thought this may help explaining the issue
There is a limited set of Power Query transforms that are allowed in Direct Query. It looks like one of the date functions is allowed and one isn't.
You can probably do it in DAX with a measure (or possibly a calculated column - you will have to try it).
Or add it in the source db.
Or use Import model (or composite model) if there are lots of new columns required
Have you investigated using a composite model? You could create a calendar table in powerbi and add all the relevant columns you need while maintaining direct query to the Fact tables. You will need a relationship between the calendar and Fact tables
