Sir, Every video of yours is amazing, but this one is on another level! Fantastic and excellent work!
@bcti-bcti7 күн бұрын
Thank you! That's so kind of you to say. Hope the content helped.
@ronaldagee7417Ай бұрын
Just when I thought I had it all figured out, you showed me an easier way. Thank you for the Power Query videos; they have saved me a significant amount of time.
@bcti-bctiАй бұрын
So glad to hear that the video improved your workflow. Thanks for watching.
@IvanCortinas_ESАй бұрын
As always, clarity and complete control of the situation. Extremely pro. I love these types of examples and your way of telling them, always to the point. Thanks, Bryon!
@bcti-bctiАй бұрын
Wow, Ivan! Such nice compliments. I'll try to keep up the work. Cheers.
@jazzista1967Ай бұрын
Great study case. I just had the same issue yesterday when i was building a data model that had the same error when trying to refresh my changes in PQ . You pointed me in the right direction. Thanks for posting
@bcti-bctiАй бұрын
Perfect timing!!! Glad it helped. Thanks for watching.
@jazzista1967Ай бұрын
@@bcti-bcti Yes Indeed. And it was exactly a prior step that i applied ( Covert dates from text to real dates) like you showed in the video. Thanks again! Man, you content is gold
@sharmarudraАй бұрын
Awesome Video.
@bcti-bctiАй бұрын
Thank you. You support is greatly appreciated.
@tonybatty504Ай бұрын
Lots of interesting and useful elements. Thanks
@bcti-bctiАй бұрын
Glad you found it useful. Thanks for watching.
@kkravchАй бұрын
Great job! Clear explanation with attention to details that matter. Professor!
@bcti-bctiАй бұрын
Thank you!!!!
@gitgosc707518 күн бұрын
absolutely georgeous!
@bcti-bcti18 күн бұрын
@@gitgosc7075 Thank you!!
@chrism9037Ай бұрын
Great video, thanks for explaining this so well!
@bcti-bctiАй бұрын
Thank you. As always, your support does not go unnoticed.
@robbe58Ай бұрын
As always, a tutorial at the top of the bill. Magnificent work, dedication, and explanation. 💯 👍
@bcti-bctiАй бұрын
Thank you so much. I'm glad I was able to meet your high expectations. 😁
@kebincuiАй бұрын
Brilliant as always 👍
@bcti-bctiАй бұрын
Thank you!!!! That's very nice of you to say.
@sujanmdsifulАй бұрын
Awesome 😂. I am proud of you brother
@bcti-bctiАй бұрын
Thank you! That means a lot to me.
@anpham7108Ай бұрын
The way you teach is SUPER as always, thank you. I have a question in mind, how do you deal with tables that span across pages?
@bcti-bctiАй бұрын
THAT is a fantastic question. I hadn't though about that. I will do some testing and let you know. Cheers.
@ahmedshalaby9343Ай бұрын
i have a problem in an append query , I append folder contain many sheets inside the sheets there are different format like mm-dd-yy or dd-mm-yy what do you suggest ?
@bcti-bctiАй бұрын
My guess is that you will have to find something on each sheet that indicates the country of origin to determine the correct date format. You can't really use the dates because January 2nd (01/02/2025) could be validly read as February 1st. Can you send a sample file so I can perform a more in-depth analysis? (license@bcti.com)
@ahmedshalaby9343Ай бұрын
@@bcti-bcti thanks for your quick reply
@celestebenitez6688Ай бұрын
What if its not a table but just text and numbers. What if you are extracting something that's always on the first page (name and address) And a grand total on the last page. But the last page varies from file to file? One doc the total is on the first page. On another is on page 3, then 5 and so on. Can you do an exercise like that?
@bcti-bctiАй бұрын
That's a lot of specific needs. As each project is unique, I would need to see the PDF files to come up with a strategy.
@celestebenitez6688Ай бұрын
@@bcti-bcti ok, no prob. Just let me know where I can send sample files.
@bcti-bctiАй бұрын
@@celestebenitez6688 You can send the file to training@bcti.com