Forum Discussion

Botturovic's avatar
Botturovic
Frequent Visitor
9 years ago

Overcome data type problem in direct query

I know that direct query mode has limitations in modeling colums and data in general, but maybe you can help me to overcome this limitations in a particular case. This is the data type format i ha...
Need Help
Botturovic's avatar
Botturovic
Frequent Visitor
9 years ago

Thank you for yout help pawelpo,

 

i've tried to follow your instructions but i got an error message of the same type:

"this operation generates a query that is not supported in Direct Query mode."

 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Botturovic,

 

In my test, I was able to create calculated columns to generate Year column and month column. And I was able to add these two calculated columns into Axis section of the bar chart.

Year = YEAR(test04[Date])
Month = Month(test04[Date])

 

 

Besides, please try the Bin function to see whether it works for you.

 

Best regards,
Yuliana Gu