Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Data source error - DM_GWPipeline_Gateway_MashupDataAccessError

We are trying to refreshing this report through Gateway connected to MS Access, and got the below error message. Does anyone encounter similar issue and resolved it? Please advise. -------- Data ...

Need Help

V-lianl-msft
6 years ago
Hi Anonymous ,

Try using a personal mode gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem#list-of-available-data-source-types
Or refer to this thread:
https://community.powerbi.com/t5/Service/On-Premise-Gateway-Error-connecting-to-Access-Database/td-p/849442

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin

Super User

6 years ago

Access uses .ldb files for locking. Does the user in the gateway connection have write permissions?

Anonymous
Not applicable
6 years ago
Yes, the user has full permission to the location where access located.
- V-lianl-msft
  Community Support
  6 years ago
  Hi Anonymous ,
  
  Try using a personal mode gateway
  https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem#list-of-available-data-source-types
  Or refer to this thread:
  https://community.powerbi.com/t5/Service/On-Premise-Gateway-Error-connecting-to-Access-Database/td-p/849442
  
  Best Regards,
  Liang
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.