Is there a work around for direct query? You cannot use unpivot in direct query from what I have found.