Call oracle procedure in powerbi failed

[phchu1226]

Hi all,

I am trying to call oracle procedure in powerbi with the select query

I tried using call or beign end to execute the procedure, it did not work.

Is it not able to do so? my oracle version is 11g.

Thank you in advance.

[v-xiaotang]

Hi @phchu1226 

In this scenario, SQL statement is optional, but not necessary. Not proficient in SQL, but you can connect to your datasource directly. Here are 2 articles for your reference,

(1) https://community.powerbi.com/t5/Desktop/New-to-BI-Writing-SQL-queries-to-parse-data-I-am-obviously/...

(2) https://radacad.com/only-get-the-last-few-periods-of-data-into-power-bi-using-power-query-filtering

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[phchu1226]

Hi @v-xiaotang,

May I know is it possible to do this from "SQL statement (optional)"??

First call procedure, then select the particular table, so that the data is up-to-date everytime after refreshed..

or any other alternatives?

Thank you.

[phchu1226]

@v-xiaotang ,

excuse me, is there any update?

[phchu1226]

H i@v-xiaotang ,

According to the image you attached above, he said the box is for SQL statement, so why I am not able to use "CALL PRO_TESTING('AB,'ABC')??

After that, is it impossible to do what I want? (first call stored procedure from powerbi then select table)

[amitchandak]

@phchu1226 , I doubt you can call like that , Try to call this as column or table

[phchu1226]

Hi @amitchandak ,

The procedure is used to refresh the table (insert/update new data) and then select that table to retrieve the latest dataset.

Therefore, I want to execute the procedure at the beginning while I am refresh the dataset in powerbi everytime.

I dont quite understand "Try to call this as column or table"?

[amitchandak]

@phchu1226 , I was thinking if this can be a function then we could have used it in "With" clause

example

With a (select func_testing('','') ) as

select * from b