Forum Discussion
Error refreshing Access database data tables on a network in PowerBI desktop
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 :-)
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
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 :-)
