Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

1 Reply

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    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.