Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connecting to a network folder

Here is what I'm trying to do: I want to connect to a network folder that includes three excel files (same format) and combine them into one report. Below is a screenshot of a folder including file...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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."

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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.