Forum Discussion
Data Refresh
I'm actually using on-premises gateway to referesh data , which is installed on my computer.
Unfortunately we have a linux server so we can't migrate the gateway there.
Is there any other way to referesh data automatically(my data source is mysql database) , not through the gateway
6 Replies
I would like to join that question. In my Case i'm using googlesheets as my source and i dont really understand the fact, that powerbi needs a local gateway when the report and its feed is complety web-/cloudbased.
Is there any chance to get rid of the gateway?
Hi Torell
The Gateway is a way to connect Power Bi service to data sources for refresh purpose only. You can find other ways or API's to use like this here but you will always need a connector from Platform to another Plateform.
https://github.com/fluf1024/PQGoogleSpreadsheet
Hi RihabBr
You don't migrate a personal Gateway (in your Computer) to an Entreprise Gateway. You will need to install it.
Here is how on Linux Server
https://big2smart.com/the-power-bi-gateway-a-practical-case/
Hi Amine,
thx for your help so far.
Just to be sure we talk about the same:
Everything is working so far. My Report is online and gets the feed to googlesheet when
refreshing the data on the websurface or locally. My goal is to set an autorefresh to the googlesheet
that needs no further syncronization with my local pc so the its autorefreshing even if my pc is not
reachable. Is this possible with the connector you mentioned above?
Cheers,
Tom
