Forum Discussion
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,
Microsoft EmployeeHi 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
Super UserIf 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,