cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
megavic
Advocate I
Advocate I

Error refreshing Access database data tables on a network in PowerBI desktop

Hi,

 

I'm having an issue when refreshing queries from an Access database on the network.

This was previously working OK, but currently when refreshing I get the error: 

"DataFormat.Error: Could not use [Access DB Filename]; file already in use."

All other tables the cancel load due to the above issue, however the only user accessing the DB is the PowerBI desktop app.

It's like it's tripping over itself when refreshing, the offending table changes randomly.

 

I can refresh the data manually by clicking refresh on every data table but this is a real headache and obviously not ideal!

 

Any help appreciated,

 

Example screenshot:

 

image.png

1 ACCEPTED SOLUTION

Hi Qiuyun,

Thanks for your help, yes the access DB is on a shared network with the filepath layout as per your comment.

The four tables are all from the same database with one way relationships.

Updated to the latest version and this is still an issue.

I have band aided the issue by unticking 'Enable parallel loading of tables' in Options --> Current File, Data Load.

Obviously this makes the query refresh take slightly longer but removes the annoyance of individually refreshing tables.

I think I'll go with this for now as work is hectic at the moment.

Again, thanks for you help 🙂

View solution in original post

7 REPLIES 7
set314
Frequent Visitor

This only works in the desktop. Is there a solution for refreshing in the service with a gateway?
v-qiuyu-msft
Community Support
Community Support

Hi @megavic,

 

From your description, it seems that the access database is shared on network with \\<server name>\users\<user name>\..., right?

 

In your scenario, as there are four queries, how did you create those four tables? Were there any dependency between those tables? Please try to share the detail steps how you create .pbix file, so that we can try to test on our side.

 

By the way, which desktop version did you run? How about the result after updating the desktop to the latest one?

 

Best Regards,
Qiuyun Yu

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

Hi Qiuyun,

Thanks for your help, yes the access DB is on a shared network with the filepath layout as per your comment.

The four tables are all from the same database with one way relationships.

Updated to the latest version and this is still an issue.

I have band aided the issue by unticking 'Enable parallel loading of tables' in Options --> Current File, Data Load.

Obviously this makes the query refresh take slightly longer but removes the annoyance of individually refreshing tables.

I think I'll go with this for now as work is hectic at the moment.

Again, thanks for you help 🙂

Worked for me too. Thanks

Excellent!

BillR
Frequent Visitor

Worked for me. Glad you found it.

Lol me too!

 

Glad this has helped someone else Smiley Happy

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Dev Camp Session 30

Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.