Expression.Error: Access to the resource is forbidden (Data lake store Gen2)

[saurabhpradhan1]

Hi,

I am using PowerBI desktop to connect to Azure Data lake store Gen 2. For providing credentials I am using storage key. Sometimes while executing queries I get "Access to resource forbidden" error. This error resolves on its own after a day or so. I am not sure what exactly is causing this error and it is difficult to debug as the error occurs at random intervals.

Also, I am using data bricks to write new data in the data lake store, however, this should not cause any issue.

[nishantrana]

This should help  assign the Storage Blob Data Reader role to the user.

https://nishantrana.me/2020/09/07/error-access-to-the-resource-is-forbidden-while-trying-to-connect-...

[v-jayw-msft]

Hi @saurabhpradhan1 ,

It's quite hard to debug, i'd like to suggest you to create a support ticket for further analysis and contact your IT department at meantime.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.