Very clear explanation. Maybe you happen to know how to check for errors in the Contents column? For example, I have a list of pdf files, some of which won't transform into readable data. Power query stops rendering other files if it finds one that does not return any readable data. Very frustrating :(
You should still be able to replace errors in the expansion step, did that not work in your case? Whichever step produces errors, if you replace the errors there with something else, the next steps should continue working. But if not, is it possible to filter your query down to only the PDFs you need before expanding? You can filter on path, name, other metadata if you have anything useful to work with there.
Congratulations, excellent video!
Excellent video, crystally clear. 👍❤Subscribed immediately
Thank you!!
Very clear explanation. Maybe you happen to know how to check for errors in the Contents column? For example, I have a list of pdf files, some of which won't transform into readable data. Power query stops rendering other files if it finds one that does not return any readable data. Very frustrating :(
You should still be able to replace errors in the expansion step, did that not work in your case? Whichever step produces errors, if you replace the errors there with something else, the next steps should continue working. But if not, is it possible to filter your query down to only the PDFs you need before expanding? You can filter on path, name, other metadata if you have anything useful to work with there.