Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
st-mb
Frequent Visitor

Scheduled Refresh with Access Databases

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!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.