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/xxxxxxxxxxxx...
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
