Data Refresh

[RihabBr]

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

[RihabBr]

@aj1973 

thx amine

[Torell]

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

[aj1973]

@Torell 

Honestly I haven't tried it but i kinda trust github. Why don't you try it and tell us how it works!

[aj1973]

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/

[Torell]

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?

[aj1973]

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