Failure writing file XXX : An impersonation error occurred using the security context of the current

[Anonymous]

I created a subscription to a paginated report on Power BI Report Server with the following requirement : 

Automatic Excel file that will be delivered to a Windows File Share  like below : 

I get this error : 

Failure writing file XXX Automatic Extract.xlsx : An impersonation error occurred using the security context of the current user.

TestAB is my username should I use the email instead or what ?

[AmiraBedh · Accepted solution]

I think the Windows File Share folder where the report is being saved doesn't have the appropriate permissions for the account under which the Power BI Report Server service is running. You need to grant read and write permissions to that account.

To explain to you the situation in Power BI Report Server, there are settings related to impersonation. These settings determine under which account the reports are executed and delivered. You should check the following settings:

• Service Account: the Power BI Report Server service is running under an account must have the permission to write to the specified file share

• Data Source Impersonation: If your report uses a data source with impersonation enabled, ensure that the impersonation credentials are valid and have appropriate permissions.

It's also a good practice to use a full UNC path (e.g., \\server\share\folder\filename.xlsx) to specify the destination. I always use this converter : Universal Path Converter