Dataflow - update the credentials for AzureBlobs

[psev66]

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 using a service account. When I create my query, the data is pulled from the db and shown. When I refresh I get the error: Data source credentials are missing or invalid. Please update the credentials for AzureBlobs.
My research has led me to believe this is because the gateway service account is the one trying to save data to the PBI managed storage area and it doesn't have the access rights, it's a limitation of the service.
Is the only solution to have the same account on both the dataflow and the gateway connection?

[andrewsommer · Accepted solution]

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.

[v-saisrao-msft]

Hi @psev66,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @psev66,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @psev66,

I wanted to check if you had the opportunity to review the information provided @andrewsommer,@andrewsommer. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Akash_Varuna · Accepted solution]

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.

[andrewsommer · Accepted solution]

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.