Forum Discussion
Date - Data type
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!!
Hello sraj ,
Sometimes it won't create date hierarchy. probably you can create column for year, month, querter, day and create new hierarchy.
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!!
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~
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.
