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.
I have a SQL query against an Oracle Database where I'm trying to use a paremeter to create a dynamic query. The parameter is called in 3 separate locations.
Following this post, I created the parameter, edited the PowerQuery to include the declaration of the variable, and all seemed great... But I still got an error for "Not all variables bound"
I found another post from an Oracle user with a similar issue, and @v-qiuyu-msft said if it's in the where clause, replace the typical &Param with &Number.ToText(Param)&, but then I get an error of "Invalid host/bind variable name"
I have a sneaking suspicion that this is due to the exact way the parameter is being used in my query.
I feel like I've covered my bases, but if you have any questions, feel free to let me know. I would GREATLY appreciate any advice.
I thought I did it correctly, but I'm getting a new error now.
ORA-01747: invalid user.table.column, table.column, or column specification
Let me try providing a terribly watered down example...
Note: RegTerm is the name of the Parameter in Power BI
let RegTerm = RegTerm, Source = Oracle.Database("[xxxxx]", [HierarchicalNavigation=true, Query= "with aid as( #(lf)select #(lf)t1.id #(lf), t1.year_code #(lf)from t1 #(lf)left join terms #(lf) on term_code = &RegTerm #(lf)inner join t2 #(lf) on t2.id = t1.id #(lf) and t2.term_effective = user.func1(ID, Text.From(&RegTerm)) #(lf) and user.func2(ID,Text.From(&RegTerm)) = 'Y' [...] #(lf)) #(lf)select * #(lf)from aid a"]), #"Changed Type" = Table.TransformColumnTypes(Source,[xxxx]) in #"Changed Type"
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |