Forum Discussion
MICROSOFT ACCESS DATABASE - Load error; file already in use.
Hi Carol,
I wanted to reply specifically about this part of your post "My intention is to copy our production database to this Access db for using with Power BI."
I can't recommend against this course of action strongly enough. You are far better off working with your database team to have views created in the production database that you can pull into your model. They can setup a service account that has read only access to the database that you can use to connect in PowerBI desktop.
Pulling the data into an access database then into Power BI is just adding a transport step for no benefit.
Also, if the views exist in the production database, your database team will have visibility to how data is being pulled into power bi and if there are changes in the data, the views can be updated as well.
Hi Carol,
I wanted to reply specifically about this part of your post "My intention is to copy our production database to this Access db for using with Power BI."
I can't recommend against this course of action strongly enough. You are far better off working with your database team to have views created in the production database that you can pull into your model. They can setup a service account that has read only access to the database that you can use to connect in PowerBI desktop.
Pulling the data into an access database then into Power BI is just adding a transport step for no benefit.
Also, if the views exist in the production database, your database team will have visibility to how data is being pulled into power bi and if there are changes in the data, the views can be updated as well.
Unfortunately, it doesn't seem like I'll be able to do the views. The database is an mdb format and I don't want to upgrade yet to accdb. The only option I have is to save the database as an accdb and work with it in a different folder.
The problem is Power BI is not able to read the mdb tables. I could change to another type of connection but I don't have admin rights to my PC and it's too much of a hassle to try and get that done. Also, using SELECT VIEW per the URL mentioned will not work in Access unles an option is changed, which could cause issues with queries. Although, I don't think that would be a big issue in this database.
I like the view suggestion and once the db is upgraded I will employ, so I've accepted it as the solution. Thank you.