Excel file located on network drive as a data source in gateway

[Anonymous]

Hello,

Is there a way to add an excel file that is located on a network drive as a data source in gateway? As i have read it is possible but i'm getting error that connection can't be established. When i changed location of that excel file to my local hard drive everything went as i planned.

Best regards,

Lukas

[v-xicai · Accepted solution]

Hi @Anonymous ,

How do you connect to these files in Power BI Desktop? If you use Excel connector in Power BI Desktop to connect to  your files, please follow the guide in this similar thread to add all the Excel data sources within gateway.

However, if you use Folder connector in Power BI Desktop to connect to your files, please add data source within gateway using Folder option.

Best Regards,
Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.