Redshift connector not allowing to create a "slicer on Date/Time" where I want value in "Months"

[prerak]

The image above shows my raw data 

The image here shows QueryEditor

This image show the lack of any drill down options for date.

What solution exists for this?

I am on Redshift Connector on Direct Query Mode

[v-haibl-msft · Accepted solution]

@prerak

Now in-line Date Hierarchy is not supported in DirectQuery mode. It is also not creating an in-line Date Hierarchy when use Live Mode against SQL Server.

You can try to use Import Mode and it should works.

You can also vote this idea here to make it supported in the future.

Best Regards,

Herbert

[prerak]

@v-haibl-msft Upvoted the idea.