Extract data in Power Query from a .mdb file saved as a ZIP

[arathnayake]

Need assistance in extracting data in Power Query from a .mdb file saved as a ZIP.

[jennratten · Accepted solution]

You will need to use a Binary function to access the contents of the zipped folder.  Then you can use the Access Database connector to access the contents of your .mdb file.  The binary functions have different options so I use a custom function for this.  

Sample pbix

Get Data from a File in a Zipped Folder.pbix

Documentation on the Access.Database Connector

https://docs.microsoft.com/en-us/power-query/connectors/accessdatabase 

In this example I have four objects in the query pane inside of Power Query.

1. The custom function that accesses the contents of the zipped folder.
2. A parameter for the path to my zipped folder (ending in .zip).
3. A parameter for the name of my mdb file (ending in .mdb).
4. A query that invokes the custom function and then uses the Access.Database connector to access the contents of the mdb file.

Preview of the FileContents query showing the content is successfully accessed.

[arathnayake]

Great, this worked well. Thanks.