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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

You can try to add calculated columns even in DirectQuery mode. On the right side in the Fields panel right-click on the table name and choose New column. Then you can simply use DAX (with several limitations) to create all columns needed, e.g.:

 

Year = YEAR(YourTable[Posting Date])

Month Number = MONTH(YourTable[Posting Date])
  • 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