Good afternoon, my name is David. I tell you my situation to see if you can tell me or if it is possible what I am trying to do.
I have several postgresql databases hosted on RDSs on a private network. In a virtual (e.g. hostname: VM1 - power bi account VM1@... com) on the same network I have Power BI desktop, I can correctly load all those databases from data sources and view the tables. Now the topic is as follows, I need to be able to access those sources from other computers outside that network. It is possible to share from power BI the accesses to those origins, we are talking about different email accounts since it would be for several users.
I clarify by the doubts:
-I can't use a VPN to be on the same network as rds.
-The information of the postgresql bases when they are updated must be reflected in power bi automatically.
-Access permissions should be managed from Power BI
-You would not have to enter access credentials to the RDS in each user who needs to have access, you should be able to share directly from Power BI.
The idea of all this is that several users can access the data of the databases and generate reports without having to interact directly with them or provide them with access data.
Is it possible to do this? Thank you very much.