How many connections are supported by one On Premises Date Gateway(Personal);

[Kenichi]

Hi,

I want to connect hundreds Datasets on PowerBI web to Data sources via one "On Premises Date Gateway(Personal)".

Do you know how many connections are supported by one gateway?

Thank you in advance

Best regards

[collinq · Accepted solution]

HI @Kenichi ,

There is no limit to the number of connections that your gateway can have.  The limits will come in with performance and capacity.  And, since you are dealing with a personal machine, you will have limits on internet/network bandwidth, capacity of your machine (CPU and RAM), and any other limits that might be unique to yourself.  And, then you have to think of the data itself - is it large or small data that you are moving as that can effect your speed.  As can concurrency of refreshing them.

That said, if you are writing a report with lots of data sources that are web based, then you can just use the Service and don't need a gateway.  The rule of thumb is that you have a cloud data source your don't need a gateway.

But, even if you do not use a gateway, it is not the number of data connections you have but the types and capacity of your machine, connection type and so on.

The real limits within Power BI itself will be rows, data size, type of connection and that will affect you most likely before you are done with all of your connections.

[Kenichi]

Hi, @collinq

I'm considering these structure.

If you notice any concern, I appreciate the additional comment.

- Connection

  Atlassian JIRA -> JIRA addon for connection with PowerBI -> Gateway -> PowerBI cloud

- Refresh

  Hundreds of Datasets on PowerBI cloud are my own.

  So I can control every Dataset refresh schedule time

  I considering refresh Datasets sequentially one by one, by shifting each refresh time.

  I understand bulk refresh will put a load on Gateway PC and also JIRA server.

[collinq]

hey @Kenichi ,

From a technical perspective that should work, but does make for a lot of admin work on you and makes for a potential load as you mention, but, it should work.

[Kenichi]

Hi, @collinq

Thank you so much for your point of view!

I will try it.