When I try to add a column to extract the month name to create a date hierarchy, I type for the FORMAT function but only the below function comes up if you can help please. I need to create a date hierarchy and it's ok extract it from transform for the year of the date but if I do extract the month name it asks me to convert all the tables into Import query which I don't want. Thanks
INFO.FORMATSTRINGDEFINITIONS()
This function, whatever it is, it seems to take extremely long time to run. Now running for over one hour so far in DirectQuery mode and still on. Not having a way to stop it from running and neither having the faintest idea how long is it going to take (wouldn't it be helpful if ms guys added some sort of an stopper?) I have to kill it from Task Manager so I really don't know what it brings
INFO.FORMATSTRINGDEFINITIONS()
This function, whatever it is, it seems to take extremely long time to run. Now running for over one hour so far in DirectQuery mode and still on. Not having a way to stop it from running and neither having the faintest idea how long is it going to take (wouldn't it be helpful if ms guys added some sort of an stopper?) I have to kill it from Task Manager so I really don't know what it brings