Data Flow on Data Lake Gen2 refresh fail

Hi janatap, 

From internal trace, I found the error "Cannot get storage account key - failed with forbidden". 

I would suggest you find the Azure Data Lake Storage Gen2 account configured in Power BI admin portal. Then go to the Azure portal, check if required permission is granted for Power BI based on this document: https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2#prepare-your-azure-data-lake-storage-gen2-for-power-bi

Best Regards,
Qiuyun Yu 

Hi v-qiuyu-msft ,

I checked what you advised and everything looks OK.

Data Lake is connected to Power BI (in PBI Admin Portal) and all permissions are set the way described in the documentations (on Blob Container and all subfolders). All the settings seem to be the same as were before 18.1. when it was working properly. I can't see any alert in Data Lake resource in Azure Portal and no activity that could cause any problems.

Is there something I can/should try to setup (for example remove and add the permissions again)?

Pavel

Also I am not aware of any modifications or setup change (in Power BI Admin or Azure Portal) on 18.1. that could possibly affect Data Lake or Power BI. 

Hi janatap, 

Please create a support ticket to get help. 

Best Regards,
Qiuyun Yu

Hi 

i had the same issue and managed to get the MS team to help me out.

The document used to say that you has to asign the "Reader" role, instead that should be the "Reader and Data Acccess" role. everything worked for me after this change.

The Team are updating the docs to reflect this.

Hi MikeJohnsonZA,

you are right! Dataflows are now refreshing correctly.. Thanks a lot.

Pavel