Refresh from Oracle database and live connection (over 1M Rows).

[pbi1908]

Hi everyone, 

Firstly sorry if my question is a bit "stubid" since i it's my first steps in the Service, refresh etc. 

I have an Oracle database, i connected to this though the oracle client and i am getting data for 1 week (600-700 rows) in order to be fast. I would like to published the report and i would like to schedule a refresh, as i saw i need to install a gateway (pic below). My question is if i install this gateway and schedule the refresh 4 times per day and then share the report with other users everything will work well ?

My second question is i would like also to create some reports from the same db but with more historical data so i will have many many data more than 1M rows. So how can i do it? I guess that i will need a live connection to Power BI but how can i do it ? Should i need a new servert ?

Thanks in advance. 

[v-luwang-msft · Accepted solution]

Hi  @pbi1908 ,

According your describution ,you  need to instell a gateway on your local computer:

https://powerbi.microsoft.com/en-us/gateway/ 

About how to operate it ,refer:

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources 

Best Regards

Lucien