Network folder

[Anonymous]

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 file connector. However, in power bi services it doesn't let me add the source. 

Below is the path to get to an excel file within power bi desktop:

Below is an error I'm receiving. I tried to use my full email address and also other variations but it shows that my credentials are invalid. 

[v-diye-msft · Accepted solution]

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]

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.