Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Network folder

Hi. I can't add my network folder path to my existing Gateway as a data source. When I refresh data within power bi desktop it works just fine and connects to an excel spreadsheet. I'm using Excel fi...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    1. If you can access your file / folder in the File Explorer(Or you can try to add a network location by right click in File explorer),  you can directly connect them in power bi desktop via excel/csv/folder connector, after you publish this report to power bi service, the direction should be exist in "Settings" - "Datasets" - "Gateway Connections".

     

    2. Use the full path of the server/folder - you likely have the network drive mapped to one of your local drives. It needs to be the full path, not the mapped one.

     

    3. I'd like to recommend using parameters.

    Please refer to: https://community.powerbi.com/t5/Power-Query/Data-Sources-with-Data-Gateway/m-p/720082 

    More to this topic: Deep Dive into Query Parameters and Power BI Templates

     

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

Is the Folder Location of the P:\ on the Gateway Server?

From the above it would appear that you need to use Domain\UserName in the settings.
EG: LiquidityServices\Lukas.Klimek

The On-Premise Windows servers do not understand UPN or email addresses.