Power BI On-Premises Data Gateway through a VM for customers

0 votes
I work in a small company and we develop Power BI dashboards for a few clients. Data sources tend to change with each client from MySQL, MariaDB, SQL Server, Excel etc. Most clients want to setup scheduled refreshes but in order to do that we need a Data Gateway. So far I have used my machine as a gateway but that requires my computer to be on all the time which is not ideal. Since our clients data is usually stored in their own networks I believe we need an enterprise data gateway to manage all those scheduled refreshes for our current and future projects.

We don't have any physical on prem infrastructure, most of the company's developements are managed through AWS linux cloud servers. From what I've read a possible solution is to have a VM running 24/7 with the enterprise data gateway installed, although this seems a bit expensive taking into consideration Azure VM prices. Is there any other solution to my situation or is a VM the only path I can take?
Feb 21 in Power BI by surbhi
• 3,810 points
315 views

1 answer to this question.

0 votes
There isn't any other choice, To connect your data sources to PowerBI, you'll need to install and configure an on-premises data gateway, which requires an on-premises server or a virtual machine on Azure.

As you are aware, the machine setup that is suggested is:

A CPU with eight cores

Memory: 8 GB

Windows 8 64-bit or Windows Server 2012 R2 or later

Spooling storage on a solid-state disc (SSD).

If your resources are hosted in Azure, you can use the vnet data gateway, which doesn't require any setup.
answered Feb 21 by CoolCoder
• 4,360 points

Related Questions In Power BI

0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14, 2020 in Power BI by Gitika
• 65,850 points
247 views
0 votes
1 answer
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
11,650 views
0 votes
1 answer

Are 2 MM rows too much data for Power BI Online to manage?

PowerBI can easily handle 400MM rows and ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,350 points
503 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
522 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
1,771 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
604 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
694 views
0 votes
1 answer

Scalable Power BI data model on delta lake ADLS Gen2

You may use the new Delta Sharing ...READ MORE

answered Feb 17 in Power BI by CoolCoder
• 4,360 points
205 views
0 votes
1 answer

Power BI: Giving users the option to include or exclude a type of data

The best option, in my opinion, is ...READ MORE

answered Feb 18 in Power BI by CoolCoder
• 4,360 points
82 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP