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
nyn_prshr
Frequent Visitor

On Premises Gateway for Linux Server

Hello Everyone,

 

I have a MySQL data source that It's on a Linux Server and I would like to configure data source on the Power BI web service and create a Schedule Refresh. But, it requires the on-premises gateway to be installed on Linux Server.


As I know that it is not possible to install a gateway in Linux server. So, could you please suggest for any possible alternatives?

 

 

Thanks

1 ACCEPTED SOLUTION
blopez11
Resident Rockstar
Resident Rockstar

You don't have to install the gateway on the same server

Install it on a Windows VM that would be able to access data source

 

We have one gateway, that has access to both Oracle and SQL server data sources

View solution in original post

6 REPLIES 6
gwolszczak
Frequent Visitor

So the answer is it's not possible to install the gateway on Linux? It makes little sense, in such case we need to maintain a windows machine dedicated just for the gateway, meaning additional cost...

systeembeheerKP
New Member

What kind of rights and how should the Microsft gateway server needs access to the Linux MYSQL server? ODBC? SSH?

blopez11
Resident Rockstar
Resident Rockstar

You don't have to install the gateway on the same server

Install it on a Windows VM that would be able to access data source

 

We have one gateway, that has access to both Oracle and SQL server data sources

What configuration you should perform on the PBI Cloud server to connect to the windows virtual server where the gateway will be installed. Thank you.

I have a Raspberry Pi/Linux server that runs MariaDB with the dataset I'd like refreshed. Is the solution to install the onprem gateway on that always-on machine inside a Windows VM (headless)? That, in turn, should allow me to toggle on the Schedule Refresh, every day after midnight, so I have the newest dataset for the report when opening it on mobile, even when not on WiFi but on 5G/outside of the LAN, correct?

@blopez11 Thanks for your valuable answer.

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.