Forum Discussion
Helper IMICROSOFT 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.
Super UserHi 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.
Helper IHi JD,
Thank you for your reply and suggestion.
The database was created in 1997, it's a mess but it's the only thing we have right now. If we do get a new system, we will need to extract the data from it so it remains what it is.
There is no database team, there is me and two others but noone else is familiar with databases. I'm used to a mainframe, so working with Access is a challenge.
The views sound like a great idea, I'll ChatGPT to see how to do that. I have no Admin rights to anything on my PC or the server the database is housed on. That's why I was copying it.
Let me know if you have any other suggestions. Again, thank you.