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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.