cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
joshKo Occasional Visitor
Occasional Visitor

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
blopez11 Established Member
Established Member

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,

3 REPLIES 3
blopez11 Established Member
Established Member

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

v-yulgu-msft Super Contributor
Super Contributor

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.
blopez11 Established Member
Established Member

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,

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,229 guests
Please welcome our newest community members: