Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Error Message can't refresh

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

Need Help

1 Reply

  • Bipin-Lala's avatar
    Bipin-Lala
    Solution Sage
    6 months ago

    ​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.