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

Importing multiple MDB files with folder method

Hi,

 

I created a folder on a network drive containing multiple MDB files, which i´d like to use as my primary data source for an analysis.

Each MDB file holds several tables, all in an identical structure which i want to append to several individual tables. E.g. MDB file 1 to 12 contain table A, B, C ... - with the folder method i want to append these to one big table A and B etc. On a daily basis every MDB file is replaced by a fresh export over night via a VBA script to keep them up to date. File and table names etc. all stay the same 

So far i could succesfully import the data and create all necesary relationships. Once i hit "Refresh all" within PBI though, i receive an error message saying there is an unrecognized file format in the source folder with the ending ".ldb" due to the automatic lock-file creation of Access. Is there any chance i can circumvent those "ldb."-lock-files and still use the folder method? 

I would very much appreciate your help. Thank you very much in advance 

 

Tobi 

 

4 REPLIES 4
Microsoft
Microsoft

@Toby87,

How about the result if you disable the "Enable parallel loading of tables" option and click specific table in Power BI Desktop to refresh?
1.PNG

I am not sure if the LDB files can be circumvented, based on this article, the file is used to keep track of all users that are currently accessing the database. I would recommend you also consult Access suppport to check if there are any methods.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much for the advice. Unfortunately, disabling "Parallel loading of tables" doesn´t solve the issue. The error keeps on popping up. What surprises me though – it works when I don´t initiate a global refresh but instead manually refresh each individual source. Since I have quite a lot of sources, this is not very convenient. I was hoping to find a way to globally refresh all sources with just one click respectively even be able to automatic this process with a scheduler.

 

Regards,

Tobi

@Toby87,

Do you need to load all the tables or a specific append table from query editor to report view of Power BI Desktop?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

All of the tables contain relevant information for the report, thus i have to refresh all of them daily. I am afraid there is no other way around it, unless you can think of something else. Thanks again for your help.

 

Regards,

Tobi

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Kudoed Authors