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?