Forum Discussion

phchu1226's avatar
phchu1226
Icon for Helper IV rankHelper IV
4 years ago

Call oracle procedure in powerbi failed

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...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

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/td-p/41415/page/2

(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's avatar
phchu1226
Icon for Helper IV rankHelper IV
4 years ago

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's avatar
    phchu1226
    Icon for Helper IV rankHelper IV
    4 years ago

    v-xiaotang ,

     

    excuse me, is there any update?