Forum Discussion
Error when loading data from certain folders
I worked on this problem some more and found out that the problem only occurs when the sample file is being loaded from a folder located on a server. If I use a local file as sample file, everything works fine; the query can afterwards even pull data from the problematic folder, use the function that was created with the local file, and display correct results. To me this looks like a bug, even more since everything worked fine before the last update. Can somebody confirm this? Or do I miss something?
Hi Anonymous
"he sample file is being loaded from a folder located on a server"
Do you mean this file is not in the same sever as the on-premise gateway?
If so, it can't refresh correctly because the data source and on-premise gateway should be in the same server.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello v-juanli-msft,
thank you for trying to solve my problem. Unfortunately your answer does not help me since the files are located in the same server as the gateway. I do not think there is a problem there anyways, since I can't even load the specified data into PBI Desktop, so I guess the problem has nothing to do with the gateway.
To be more precise, I can't load files from these folders as Sample Data - as I mentioned before, if I copy one of these files to my local PC, use it as Sample Data to create the function for transforming data from its folder, and then use this function on the folder, I can load data from there.
What is more, if I try to rebuild the query, I can't select these folders as the source for sample data at all. When I try to, I get an error message saying the operation is not valid due to the current state of the object, i.e. the error message that is also shown in the existing query. However, single files (e.g. Excel files) from the exact same location do not cause any problems.
The question is, where is the difference between selecting a folder and selecting a file? And why does this not affect all folders, but only those at specific locations?
Regards
Moritz
its happening to me also. If sample file is on server folder, it is no go.. if it is local, but data is in the same server folder, everything works fine.
It happens in Powerbi desktop and excel also..
AgencyPowerBi(or anybody else who knows what's going on here): Did you happen to find a solution by now, or the reason for the error to occur? I'm still clueless about this one. I was able to relocate the data I was trying to load back then to a different folder, but now I want to load some Excel files that I don't manage myself, so I need to pull them from a folder that causes this error. Any help appreciated!
Excel 365
PQ > Get Data > From File > From Folder
PBIDGet Data > File > Folder
Unexpected Error still occurs in both Excel 365 and PBID when folder is located on the network.
Is it possible that noone from Microsoft noticed this issue in half a year?
