Can I set a Power BI gateway up on onedrive so it always is online?

[ThomasWeppler]

Hi Power BI community

I want to be able to always refresh data from MySQL servers. I know I need a PowerBI gateway to do this, but sometimes I might turn off the pc where the gateway is installed.

So I was thinking that if I could place the Power gateway on my onedrive, PowerBI.com would always be able to connect to the data.

Is this possible?

[ibarrau · Accepted solution]

Hi. No you can't install a gateway at onedrive. One drive is a file system storage, it can't run apps. You could create a virtual machine to keep it 24x7 in azure or install the gateway in the mysql server that you know you won't turn off. The only alternative to avoid a gateway is using a delimited cloud source that won't need it like Azure SQL Database, onedrive files, Web APIs, etc.

I hope that helps,

[ThomasWeppler]

@ibarrau Thanks for the answer.