Unzip protected files with passwords

Question

I need to connect from power bi to blob storage and bring zipped files protected with passwords.on the other side, I have the same type of files but in xls format. the final output is to combine all files after unzipping them into one fact table.can anyone support suggesting the M code or the approach walkthrough

artemus · Answer

I think your out of luck unfortunatly. While there is custom M code for unziping a file, it doesn't work for many kinds of zip files. I am unaware of any M code that does this today.

ichavarria · Answer

Hi&nbsp;Khalefa,&nbsp;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.&nbsp;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".&nbsp;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.&nbsp;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.&nbsp;&nbsp;Best regards,&nbsp;Isaac ChavarriaIf this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;and giving Kudos&nbsp;to help the other members find it more quickly&nbsp;&nbsp;

khalefa · Answer

ichavarria&nbsp;thanks for your response but can you advise for the mcode to do so

Forum Discussion

Related content

Unzipping File - Power Query

Network Protection Audit

Password protect power bi desktop + inactivity timeout with password prompt to take up session

Password Protected Excel File from SharePoint

can't import data from a password-protected workbook!