Scheduled Refresh with Access Databases

[st-mb]

Hello,

I have a report that has an Access database as the data source. I initially ran into issues with the Power BI desktop application where it would fail to refresh (as it was locking the database due its behaviour in querying the data source using multiple threads). On the desktop app, unchecking "Enable parallel loading of tables" in "Options > Data Load" resolved this issue completely.

I've recently placed this report to the Power BI website and configured a scheduled refresh on the dataset, but I am seeing similar issues where almost all scheduled refreshes will fail due to locking the database. Is there a setting or .cfg file for the on-premises data gateway software to force similar behaviour of disabling parallel loading of tables (or possibly some other solution I am overlooking)?

If it helps, here is a copy of one of the errors I've received when trying to initiate a refresh manually from the website:

Last refresh failed: Tue Jan 16 2018 11:21:57 GMT-0500 (Eastern Standard Time)
Cannot connect to the mashup data source. See error details for more information.Hide details

Underlying error code: -2147467259 Table: tblOwner.
Underlying error message: The database has been placed in a state by user '' on machine '' that prevents it from being opened or locked.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataFormat.Error
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 2959c3a1-c483-43f4-b8e1-17cf578822c2
Request ID: 3c54d97b-d858-4e29-861c-3dacaaa495a0
Time: 2018-01-16 16:21:57Z

Thanks for your time!

[Greg_Deckler · Accepted solution]

There are config files in the installation directory, such as:

C:\Users\[user]\AppData\Local\Microsoft\On-premises data gateway (personal mode)

• ApplicationInsights.config
• Microsoft.PowerBI.DataMovement.GatewayCommon.dll.config
• Microsoft.PowerBI.DataMovement.PersonalGateway.exe.config
• Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.dll.config
• Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config
• PersonalGatewayConfigurator.exe.config