Reply
Occasional Visitor
Posts: 1
Registered: ‎01-10-2019
Accepted Solution

Can I import oracle DB from Power Bi Service version?

Hi all!!!

 

Can I import Oracle DB from a Power BI Service version that works on the web other than the Power BI Desktop version?

 

Can I import oracle DB from the Power BI service version available on the web other than the Power BI DeskTop version that I use?

 

I'd really appreciate it if you could explain how!!


Accepted Solutions
Established Member
Posts: 127
Registered: ‎10-04-2016

Re: Can I import oracle DB from Power Bi Service version?

If you want your report to be refreshed in the service from an on-premise Oracle database, you will need to install a gateway somewhere in your environment, that has access to the Oracle database.  Once you install the gateway, provision the Oracle data source for the gateway.  Then publish your pbix file to the service, and it should be able to refresh from the Oracle data source through the gateway

 

How to install and setup oracle data source for the gateway was in the links I provided

Thanks,

View solution in original post


All Replies
Established Member
Posts: 127
Registered: ‎10-04-2016

Re: Can I import oracle DB from Power Bi Service version?

You can, but you'll need to install a gateway that has access to your Oracle data source

Please see the following links for reference

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle

 

Good luck

Community Support Team
Posts: 5,419
Registered: ‎09-21-2016

Re: Can I import oracle DB from Power Bi Service version?

Hi @joshKo,

 

As of now, it is not available to directly connect to Oracle DB from Power BI service.

 

In Power BI service, you can connect live to database in the cloud including Azure SQL Database, Azure SQL Data Warehouse, Spark on Azure HD Insight, and SQL Server Analysis Services, and database on-premises including SQL Server Analysis Services Tabular model. For any other types of databases, you'll need to first use Power BI Desktop or Excel to connect to, query, and load data into a data model. Then, publish the .pbix file to service so that you can refer to that data model on service.

 

Reference: Data sources for the Power BI service

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Established Member
Posts: 127
Registered: ‎10-04-2016

Re: Can I import oracle DB from Power Bi Service version?

If you want your report to be refreshed in the service from an on-premise Oracle database, you will need to install a gateway somewhere in your environment, that has access to the Oracle database.  Once you install the gateway, provision the Oracle data source for the gateway.  Then publish your pbix file to the service, and it should be able to refresh from the Oracle data source through the gateway

 

How to install and setup oracle data source for the gateway was in the links I provided

Thanks,