Forum Discussion

psev66's avatar
psev66
New Member
1 year ago
Solved

Dataflow - update the credentials for AzureBlobs

I am using my user account to create a dataflow gen1 in a Power BI Pro workspace. My connection is to an on prem SQL database through an enterprise gateway. The gateway connection has been created us...
  • andrewsommer's avatar
    1 year ago

    The gateway service account doesn’t matter but the data source on the gateway does.  The data source needs credentials to the data source and then you need to assign that data source to individuals who are allowed to use it.  When those individuals use that data source, they are connecting to the data source with the credential stored on it and not theirs.

  • Akash_Varuna's avatar
    1 year ago

    Hi psev66 The gateway's data source is configured with stored credentials that allow it to connect to the data source. When individuals use that data source through the gateway, their access is mediated by the stored credentials rather than their personal credentials.