Data Geteway for Linux machine (performance)

[Anonymous]

Hello,

I have a MySQL running on Linux. As I understand I can't install Data Geteway on the same machine, because it can be installed only on Windows.

The question is next: if I deploy PBI Data Geteway on the remote Windows machine, are there any performance issues? I mean in this case, as I understand, data from Linux machine should be first transfered to Windows machine with PBI Geteway and only after that to PBI Service. Data refresh will be much slower, than in case when data source and Data Geteway are on the same machine. Am I right?

[Anmolgan]

@Anonymous Latency will be a factor here, but I dont think the data refresh will be slower, it always depends upon you report and how much dataset it contains, can you provide more information ont he size of any sample report that you trying to build from the MySQL Linux server?

[Anonymous]

Let assume that sample dataset contains 1-1.5 million of records.

But the most I want to know whether I correct understand how data is transfered in case of PBI geteway on different machine than source data. I mean is it Linux-Windows-PBI Service, or still Linux-PBI Service?

[Anmolgan · Accepted solution]

@Anonymous  its basically linux-windows-powerbi service, in case of such a huge million of records, you can try to increase the bandwidth around your on-premise and test out 1 report refresh and see how much time does it consume, if the linux and windows are on same network then I dont think the data refresh will be that much longer, it will entirely depend on you windows server bandwidth speed.