I have a doubt that when i am using CAST function in DIRECT QUERY..it's not working.
EX:->
DIRECT QUERY
SELECT a.code_marketing_campaign ,b.[BusinessUnit__c] as 'Parent Campaign BU' ,b.[CurrencyIsoCode] as ' Parent Campaign Currency Code' ,CAST(b.[Description]) as 'Parent Campaign Description' ,CAST(b.category_marketing_campaign ) as 'Parent Campaign Type'
from (select distinct code_marketing_campaign from [WH_ID_EMEA].[dwh].[marketing_campaign]) a inner join [WH_ID_EMEA].[dwh].[marketing_campaign] b on a.code_marketing_campaign=b.bkey_marketing_campaign
group by a.code_marketing_campaign ,b.[BusinessUnit__c] ,b.[CurrencyIsoCode] ,CAST(b.[Description]) ,CAST(b.category_marketing_campaign );
