cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arathnayake
New Member

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

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

1 ACCEPTED SOLUTION
jennratten
Responsive Resident
Responsive Resident

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.

jennratten_0-1632051184451.png

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

jennratten_1-1632051258304.png

 

View solution in original post

2 REPLIES 2
jennratten
Responsive Resident
Responsive Resident

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.

jennratten_0-1632051184451.png

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

jennratten_1-1632051258304.png

 

View solution in original post

Great, this worked well. Thanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors