cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frankvb
Helper I
Helper I

Power BI service gateway on Managed instance in sql server

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!

2 REPLIES 2
frankvb
Helper I
Helper I
lbendlin
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

Announcements
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!

secondImage

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.

secondImage

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