Hello,
Currently, we are using PowerBI service with azure synapse sql that is behind a VNET using the on-prem gateway. If we enable the private link for PowerBI service can we use the azure synapse sql that is behind a VNET without a gateway?
One of the challenges we are facing with using a gateway with azure synapse is that we need to create a gateway connection with a service account. This stores the service account credentials in the gateway connection when a dataset/dataflow does a import it will use the service account credentials. This makes it difficult to track on synpase side which end user ran the query because we have to use a service account for gateway configuration.
Alternative, is for users to have their own gateway connection which saves their credentials, but for a large organization this means having hundreds of connections with same server/database but each have their own connection which seems like too much to upkeep.
Trying to see what options are available when connecting from PowerBI service to other microsoft solutions without the need for gateway or service accounts.
