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 IPerhaps you could point me in the direction for creating the views. I created a query and set the recordset type to Snapshot so it would be read-only. I connected to the database and the query was not listed. Also, not all the queries were listed.