Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Power BI service gateway on Managed instance in sql server


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!

Helper I
Helper I
Super User III
Super User III

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?

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors