Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Can we call our custom function written in oracle from the power bi direct query??
Please reply.
Solved! Go to Solution.
Hi @Anonymous,
I confirmed it internally, it's supported.
"The SQL statement in advanced option is sent to Oracle server to execute so as long as it’s a valid query including using function, PBI supports it."
Best Regards,
Qiuyun Yu
Hi @Anonymous,
I confirmed it internally, it's supported.
"The SQL statement in advanced option is sent to Oracle server to execute so as long as it’s a valid query including using function, PBI supports it."
Best Regards,
Qiuyun Yu
Hello @v-qiuyu-msft ,
is there a way to execute a package and get a table in response ?
The package have a function in wich i pass 2 parameters, something like this:
Oracle.Database("database", [HierarchicalNavigation=true, Query="
SELECT *
FROM TABLE(dbo.Package_name.function_name('"& P_1 &"', '"& P_2 &"'))
"])
The output says i can't have more than one row as response. There's a way around it ?
Thak you in advance.
Hi @Anonymous,
Based on my test, the same query to call Oracle function in SQLdeveloper can be executed in Power BI desktop DirectQuery as well. But I will double confirm it internally, will update here once I get information.
Best Regards,
Qiuyun Yu
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |