Error Message can't refresh

[Anonymous]

Hello

I have this issue when I want to refresh my database on Power BI Service :

==> I checked twice the path to find the file. Someoe could help me please ?

Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Impossible de trouver une partie du chemin d'accès 'Z:\\Bibliothèque\\Direction technique\\KPIs\\Fichiers sources KPI PowerBI\\Data KPI AVA\\Liste Administrateurs Compte.xlsx'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"Z:\\Bibliothèque\\Direction technique\\KPIs\\Fichiers sources KPI PowerBI\\Data KPI AVA\\Liste Administrateurs Compte.xlsx"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Dim Infos Administrateurs Compte.
URI du cluster: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
ID d'activité: b62cf7f9-14cd-4ff7-b640-1813f07be7d8
ID de demande: c56d429d-4075-d5e9-c13f-3360275ac6c6
Heure: 2023-11-10 14:34:21Z

[Bipin-Lala]

​This is a common issue that I've helped many developers in our organization resolve when they're trying to connect to a local file on a corporate server.

​The Core Issue

​The error occurs because your Power BI report is looking for a file on Drive Z:. While that mapped drive exists on your personal machine or a specific on-premises server, the On-premises Data Gateway (the service handling the refresh) runs as a background service account. These service accounts operate in "Session 0" and cannot "see" or authenticate against mapped network drives like Z:.

​The Fix: Switch to UNC Paths

​To resolve this, you must change the file path in your Power BI Desktop file from a mapped letter (Z:\) to a UNC (Universal Naming Convention) path. This provides a direct network address that the Gateway can resolve.

​1. Identify the Server Name

​Instead of Z:\, you need the absolute server address:

• ​Open Windows File Explorer.
• ​Right-click on your Z: Drive.
• ​Select Properties or look at the path in the address bar.
• ​It should look something like: \\ServerName\SharedFolder\Development\...

​2. Update and Republish

1. ​Open your .pbix file in Power BI Desktop.
2. ​Go to Transform Data and update the Source step of your query with the new \\ServerName\... path.
3. ​Republish the report to the Power BI Service.

​Once republished, the "Refresh" option will be able to communicate with the Gateway correctly.

Let me know how it goes.