Power BI unzip: import and unzip the files from OneDrive

The video is to share a methodology in organizations by using Microsoft power automate to save email attachment with zip extension of csv file to one drive (for business) when email arrives, refresh power BI report dataset at power BI service when new zip file created on one drive. The business scenario is considering the situation when the data source file in predefined layout is subscribed from an online services system or sent by individual in a regular manner.
This video is the part two which focus on sharing a method to create power query unzip custom function in power BI for reading imported csv zip file, extract file name and update date from one drive.

You may find the unzip query codes from the Mark White BI Blog URL address:
http://sql10.blogspot.com/2016/06/rea...

For more info of my BI & Analytics, please refer to the following website links:

My BI & Analytics Website:
https://sites.google.com/view/mikegua...

My blog website :
https://mikeyubianalytics.blogspot.com/