Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.