Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
akdoro
New Member

Error In Importing Data from MS Access

I have the following situationn.

 

I've a central MS Access Database which contains almost all the data that I want to analyse.

 

I have a PBI model with ~ 50 queries based on the tables of the above Access database.

 

Whenever I go for the "Refresh All" option to refresh all my data, this is what happens :

 

The queries start pulling in data from the access file and all of a sudden stops because "The Access file is already in use" . 

However no other program uses that access file and I can see that the file is 'locked' because PBI is accessing it.

 

My guess is that when one query loads, it opens the file and before it is done, another tries to do the same and hence the error is generated.

 

 

Any workaround for this folks ? It is a pain to refresh each of the 50 queries manually. Also, I've disabled parallel loading of tables.

 

I'm currently on an i7 , 12 GB RAM , 5400 RPM HDD. Will upgrading to an SSD help solve this ?

1 REPLY 1
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@akdoro,

What version of Power BI Desktop do you use? As your post, you have disabled "Enable parallel loading of tables" option, I would recommend you close all PBIX files, and close all Power BI Desktop processes in task manager, then re-open the PBIX file and check if you can refresh it.

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors