Forum Discussion

AndyBean's avatar
AndyBean
Frequent Visitor
6 years ago
Solved

Dataflows Storage Account Key Retrieval Forbidden

I have some dataflows that have been working without issue until recently. These data flows connect to on-premise SQL DB's and pull data out and store it in our organisations Data Lake (ADLS gen 2). We are not using the default data store and our using our own data lake store in our own tenant.

recently the owner (myself) and other users are recieving the following error when conencting and trying to read the data from PowerBI Desktop:

 

DataflowsStorageAccountKeyRetrievalForbidden: DataflowsStorageAccountKeyRetrievalForbidden
Details:
Error=DataflowsStorageAccountKeyRetrievalForbidden
RequestId=61ba4213-56ca-4252-870a-xxxxxxxx
RequestUrl=https://wabi-north-europe-redirect.analysis.windows.net/metadata/v201606/cdsa/dataflows/xxxxxxxxxxxxx

 

I've searched the forums and only found 1 other post, which doesn't have a resolution so looking for some help.

 

The data flows connect to the data source without issue

The data flows write the data to the ADLS gen2 storage without issue and are running on a daily schedule (no issues)

I can access the data via Azure portal and via storage explorer as i'm setup as 'Reader and Data Access' role in Azure

I can see the data flows in PowerBI Desktop

but when attempting to connect to pull data into PowerBI Desktop I get this error.

 

to re-clarify this was all working as expected back in March and April and no permission have changed

 

Regards

 

Andy