cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
biswarup

How to excute Oracle Package in Power BI without any webapi

Submitted by on ‎03-02-2023 06:19 AM

I am trying to execute Oracle Package in Power BI desktop, but getting error. Package is used for open oracle table. How to run this type of request.

Status: Investigating

Hi @biswarup 

To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. You can refer to the following document to get more info .

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎03-02-2023 11:03 PM
Status changed to: Investigating

Hi @biswarup 

To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. You can refer to the following document to get more info .

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Ailsa Tao

biswarup
Frequent Visitor
‎03-02-2023 11:29 PM

We are able to connect Oracle database but not able execute packages. If i run select statement, it is working file. Please let me know, how to execute procedure / package of oracle.

 

Package retun type is void. 

Idea Statuses