Power BI service gateway on Managed instance in sql server

[frankvb]

Hi,

We have reports set up with data in databases in a managed instance in SSMS.
For the refreshes from power bi service we have a gateway. We noticed some problems once we tried to refresh reports with data with different databases, with separate gateways.

They show the gateway connection works, after putting in the right credentials.

Then however when we try to refresh we get an error message, saying we lack the credentials to connect.

Any idea why this might be happening? or what we should check?

It should be perfectly possible to have report with two different gateways (to different databases)?

thanks in advance!

[frankvb]

No, it's in the cloud:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

[lbendlin]

you would think, but it is actually not supported. ALL on-premise data sources in a dataset must be served through the SAME gateway cluster.  This is a known limitation.

Please explain what you mean by "managed instance" - is that still considered on-premise?