Forum Discussion
Solved
[SOLVED] Power Query - Try don't work with Folder.Files
Oi pessoal! Esta é minha primeira discussão, então eu tenho um problema ao tentar carregar pastas diferentes (no OneDrive) no Power query Excel. Usei a instrução try para corrigir isso, tentando ...
- Guys, i solved this using a following statement:
Source = try Table.Buffer(Folder.Files(AnyPathHere)) otherwise Folder.Files(OtherAnyPathHere)).
Using Table.Buffer the try statement works again.
Guys, i solved this using a following statement:
Source = try Table.Buffer(Folder.Files(AnyPathHere)) otherwise Folder.Files(OtherAnyPathHere)).
Using Table.Buffer the try statement works again.
Source = try Table.Buffer(Folder.Files(AnyPathHere)) otherwise Folder.Files(OtherAnyPathHere)).
Using Table.Buffer the try statement works again.
Can confirm, I had queries that would get corrupted just because Windows display language was different between users. It just saved me a ton of work and now anyone can refresh said queries.