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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors