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.
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
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |