Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |