Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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
Super User
Super User

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

7 REPLIES 7
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
Super User
Super User

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

my database is on linux ec2 server, can i use install gateway on another windows vm on ec2? i tried, the published report on powerBI service still can not refresh.

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?

Anonymous
Not applicable

@blopez11 Thanks for your valuable answer.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors
Users online (2,944)