Forum Discussion

sraj's avatar
sraj
Responsive Resident
5 years ago
Solved

Date - Data type

Hi Everyone,   My Date Created field/option is not showing the hierarchy calendar, the data type is set to Date but its still not showing for me to get the Year, Month, Day options.  Can someone pl...
Need Help
  • sraj's avatar
    sraj
    5 years ago

    Found the issue, I had my data connectivity mode to "DirectQuery" once I changed it to "Import" I was able to see the calendar and the date hierarchy.  This is strange that it doesnt work for both the modes, anyways I am glad I tried this.  Thank you!!

sraj's avatar
sraj
Responsive Resident
5 years ago

Found the issue, I had my data connectivity mode to "DirectQuery" once I changed it to "Import" I was able to see the calendar and the date hierarchy.  This is strange that it doesnt work for both the modes, anyways I am glad I tried this.  Thank you!!

Setiadini_15's avatar
Setiadini_15
New Member
5 years ago

hi, seems like i face same issue like you. can you explain how to solve it?

my data is not automate make relationship

appriciate your help~

  • sraj's avatar
    sraj
    Responsive Resident
    5 years ago

    Make sure your data connectivity mode is set to IMPORT, for some reason it didnt work with DIRECT QUERY.  See if this works for you.