Forum Discussion

wynhopkins's avatar
wynhopkins
Most 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

     

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

Hi wynhopkins,

Yes this is common.

To have the "W:\" drive be accessed from other places, we need its UNC path.

For the local computer, the drive should be mapped already, so there is no need to use its UNC path locally. Actually when connecting to the network drive, the local NIC is still querying with the UNC.

This is similar to the thread below:

Schedule Data Refresh Issues

If any further help needed, please post back.

Regards

wynhopkins's avatar
wynhopkins
Most 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
    Microsoft 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
      Advocate 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?

    • rdjmaddress's avatar
      rdjmaddress
      Regular Visitor
      1 year 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.