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.
I have a Windows Server instance set up in my AWS VPC. This server has an on premise gateway installed and I have connected to the gateway from the Power BI dashboard (so the connection seems to be working OK). I have tested the connection from the Windows Server to my RDS Postgres instance and everything works, in other words, I can connect (using psql) from the machine the gateway is running on to my database.
I am trying to now set up a postgres data source in the Power BI dashboard but when I add the credentials I get a generic error message:
"Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."
How can I debug this? There are no further details and I'm not sure what the problem is.
@aosaigh,
As you have no issues connecting to the database from the gateway machine, you should be OK to add the database within gateway in Power BI Service.
Have you seen Show details at the tail of the above error message? If so, expand it to view detailed error message. If you don't have "Show details", please export gateway log following the guide in this article.
Regards,
Lydia
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.