Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Planning Power bi gateway to get data from an Oracle database on-premise

Hi,

in order to publish a pbix file that gets data from an Oracle database on-premise, I need to check the existing Power BI prod architecture. There is a machine with the gateway installed: is it right to install the Oracle client on this gateway machine before to publish the pbix file on the Power BI service?
Thanks

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Anonymous 

 

Here are details below on how to refresh data from an Oracle database which would need to go via the Gateway Power BI – On-Premise Gateway Configuration steps to an Oracle Database - Reporting/Analytics Made easy with FourMoo and Power BI





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @Anonymous 

 

Here are details below on how to refresh data from an Oracle database which would need to go via the Gateway Power BI – On-Premise Gateway Configuration steps to an Oracle Database - Reporting/Analytics Made easy with FourMoo and Power BI





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

collinq
Super User
Super User

HI @Anonymous ,

 

You might be comingling things here.  Publishing the report can be done with our without a gateway.   If you have data that is not in the cloud, then you will need a gateway.

If your data is in the cloud then you can probably just setup refreshes without a gateway.

If you want to have automatic, scheduled refreshes, AND your data is not in the cloud, then you have to have a gateway.  So, if you want to have the scheduled refresh, then you will need to install the gateway.  

To use the scheduled refresh, once you publish the report, then you use the gateway to get to the data.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors