I have a scheduled daily refresh that pulls data into Power BI from a local Access database. The refresh is working, but after every refresh, the record lock that is applied on the database (while the refresh occurs) is not released upon the completion of the refresh. (i.e., the ".laccdb" file lock in Access). The laccdb file cannot be deleted in windows explorer (a message pops that says "this action can't be completed because the file is open in microsoft mashup evaluation container". The only way I can remove the lock is by restarting my computer. Does anyone know of a solution to this problem?
v-xiaoyan-msft
on:
export to excel
Idrissshatila
on:
Power Query Filter Rows Basic UI bug