Hello,
I am extracting data from Oracle databse using SQL code.I am aiming for an excel based control sheet which will be updated by the users and the data automatically gets pulled from Oracle through SQL code, for which, I have created parametres and subsequently embedded the parametres in the SQL code using Invoke custom function .However, whenever I am trying to load the data in the model i am getting an error message ( in the subject line). below is one of the few codes that I am using
let
Source = Oracle.Database("icanp1", [HierarchicalNavigation=true, Query="Select#(lf)#(lf)PERIOD_ID AS EARNED_PERIOD_ID,#(lf)PURCHASER_AGENT_ID AS CUSTOMER_ID, #(lf)DISTRIBUTOR_AGENT_ID AS DISTRIBUTOR_ID,#(lf)ORG_LEVEL2_ID,#(lf)ORG_LEVEL3_ID,#(lf)ORG_LEVEL4_ID,#(lf)category_id,#(lf)sub_category_id,#(lf)item_id,#(lf)cust_id,#(lf)manufacturer_agent_id #(lf)From GPO.TRANS_REPORTING #(lf)#(lf)where period_id between '"&Trans_FROM&"' and '"&Trans_to&"' and manufacturer_agent_id = '"&Manuf_id&"'"])
in
Source
"Trans_FROM", Trans_to, Manuf_id(in the code) are the parametres which I have declared in PBI . I am able to extract the data in the model but whenever I wish to apply the same, I am getting this error. I have declared the same variables as text in the excel sheet to be used by users. Pls help URGENT!!!
