Video Microsofts Guy in a Cube - Patrick batch upload spreadsheets to OneLake Explorer and db table

[dd88]

I am searching for a video by Microsofts Guy in a Cube - Patrick. video approx 10-12 months old

From memory, the video demonstrated batch Excel spreadsheets on the desktop OneLake, upload spreadsheets to OneLake and into a db table. At the end of the workflow the spreadsheets were moved into a Done folder, done by automation or script.

I have inherited work from the administration team, which kept all spreadsheets locally, a total of 1,319+ spreadsheets.

I now need to do the same task, upload the spreadsheets in OneLake, and create powerbi reports for management and executives.

i didnot bookmark the video.

on youtube I am going through the videos, however have not yet found the video

https://www.youtube.com/@GuyInACube/videos

Does anyone have the video link please?

TIA

[dd88]

Thank you @Anonymous  thats great ..

[Anonymous · Accepted solution]

Hi @dd88 ,

Maybe you can refer to below video:

https://youtu.be/JZCnfkLjEMw?si=9lzyh95lnhIe0ieM

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.