Forum Discussion
CaioSilva
Jan 12, 2021Copper Contributor
[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 ...
- Jan 14, 2021Guys, 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.
CaioSilva
Jan 14, 2021Copper Contributor
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.
- MoldJun 24, 2026Occasional Reader
Thank God, you did this, man.
It saved my day. - JudasLupoMar 07, 2022Copper ContributorCan 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.