Forum Discussion

wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago
Solved

Enterprise Gateway mapped network drive issue

I'm hoping I'm missing something but here's the scenario I encounter when trying to set up Enterprise Gateway.   I built a simple Power BI Dektop file that pulls data from an Excel stored on our co...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    Hi wynhopkins,

     

    Generally yes. Mapped drives are only available on your machine locally, which is not available on your network, the UNC path is the workable path for the shared drives in your network environment.

    Also the error told that "can't connect to the mushup data source." For the gateway service, it won't recognise the W:\ through the network, which is only a shortcut of the shared path on your local machine.

    Regards

     

wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

thanks v-micsh-msft

 

So while my Power BI desktop file creates a connection based on W:\  I will always need to go into that query and manually change this to the \\SERVER-NAME\etc path if I want to be able to refresh via Gateway?

v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi wynhopkins,

 

Generally yes. Mapped drives are only available on your machine locally, which is not available on your network, the UNC path is the workable path for the shared drives in your network environment.

Also the error told that "can't connect to the mushup data source." For the gateway service, it won't recognise the W:\ through the network, which is only a shortcut of the shared path on your local machine.

Regards

 

  • Skinned's avatar
    Skinned
    Icon for Advocate I rankAdvocate I
    8 years ago

    Hi....

     

    I have the same issue here but even if i use the UNC patch, the gateway doesnt allow me to use these files. It says "No se puede conectar con el origen de datos del mashup"

     

    I think that is beacause when i connect to this share folder, i connect under "Connect using different credentials" option.

     

    And when i tried to connect from power bi service it doesnt allow me to connect using windows credentials neither using "other credentials".

     

    What can i do to solve this?

    • msones's avatar
      msones
      Regular Visitor
      8 years ago

      I'm having the same issue... I can't connect to a shared drive that requires different credentials than my windows login. Help?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Same issue, credentials are for a Synology NAS share, which has its own credentials.

        If I could use Windows credentials on the NAS share, I would...

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I am having a similar issue here with same error on gateway on-premises.

      My server is running Linux.
      I can map a folder as network drive, but once I try to add on gateway configuration I get this same error.
      do you think this is an issue with linux server?
      I tried to use both ways: Y:\ or the \\192.168.0.2\folders, but without success.

      What should I do?

  • rdjmaddress's avatar
    rdjmaddress
    Regular Visitor
    2 years ago

    You have repeated this answer through this thread or it has been quoted.   

     

    My question is:  If a mapped drive is a shortcut, why can't Power Query or PowerBI simply translate that information from the shortcut (Mapped drive letter D:) and grab the full UNC to use even if it it only displays the Mapped drive letter?  Seems like an oversight in the programming especially when a novice (me) uses the browse button to connect to the data source.