Hello friends!
Today I have a big problem that I cannot extend the user who requests information from the RDS through Power BI using the solution that Amazon provides at this link:
According to the documentation, for Power BI to access RDS data in a VPC it is necessary to install the Microsoft gateway on an EC2 machine in the VPC and then this solution establishes an outbound connection to Microsoft Azure Service Bus over the Internet and is configured in Microsoft Power BI to connect to data sources that it can access.
In the gateway and RDS communication, the user is always unable to limit access to the tables that Power BI can access depending on the source user.
Has anyone experienced this and have a solution?
Thanks!
