Unzip protected files with passwords

Hi Khalefa,

To connect to Blob Storage from Power BI, you can use the "Get Data" option and select "Azure Blob Storage" as the data source. Once you have connected to your Blob Storage account, you can select the folder where your zipped files are located.

To bring in zipped files that are password protected, you will need to use a third-party tool to unzip them. One such tool is 7-Zip, which has a command-line interface that you can use within Power BI's "Power Query Editor".

Once you have extracted the files, you can use the "Excel.Workbook" function to read in the XLS files and then use Power Query to combine them into one fact table.

Finally, you can combine all of the XLS files into one fact table using the "Append Queries" function in Power Query. To do this, select the "FactTable" column from each of the XLS files and then use the "Append Queries" function to combine them.

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly