Forum Discussion
Connecting to a network folder
Hi Anonymous ,
How about the result if connect one excel file in this folder using excel connector? Does the error message contain any detail information such as network, timeout, access forbiden or error code?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lid-msft I did connect to a single file via excel connector just fine. I can connect to a local folder (including same files that don't work when saved in network folder) but I need to connect to a network folder.
I can send the entire error message to your inbox. It only says: "Operation is not valid due to the current state of the object."
Hi Anonymous ,
Sorry for that, We cannot reproduce this issue. But if you can connect the single file in network folder using excel connector, we connect them as multi table then combine them.
Based on your error detail provided, We have found several similar situation:
https://community.powerbi.com/t5/Power-Query/PowerQuery-import-from-Folder-dont-work-for-network-folders/td-p/751164 (check URI in Advanced Editor)
https://community.powerbi.com/t5/Power-Query/Error-when-loading-data-from-certain-folders/td-p/670966 (Python Script as a workaround)
If it doesn't meet your requirement, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.