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

     

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

 

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.