Forum Discussion
Helper IIOn Premise Gateway - Error connecting to Access Database DataFormat.Error
I solved the issue.
For those having this same problem, it has everything to do with the Access DB being hosted on a network drive. There are various links on Google to get user permissions corrected.
What I ended up doing is placing the Access database on a server in a folder off the main directory on the same server that is hosting the Enterprise On-Premise Gateway. I assume it should also work if the file is placed on another server as well. I then connect to the file through http NOT through network folder (This is the important part).To Recap:
- To edit the contents inside the file, I navigate to \\server\folder\file.accdb
- To have PowerBI consume the file and get data, I navigate to http://server/folder/file.accdb
This post on another explains the issue in more technical detail for those interested...
https://forums.asp.net/t/1929989.aspx?The+Microsoft+Office+Access+database+engine+cannot+open+or+write+to+the+file+
Memorable Member
Helper III solved the issue.
For those having this same problem, it has everything to do with the Access DB being hosted on a network drive. There are various links on Google to get user permissions corrected.
What I ended up doing is placing the Access database on a server in a folder off the main directory on the same server that is hosting the Enterprise On-Premise Gateway. I assume it should also work if the file is placed on another server as well. I then connect to the file through http NOT through network folder (This is the important part).
To Recap:
- To edit the contents inside the file, I navigate to \\server\folder\file.accdb
- To have PowerBI consume the file and get data, I navigate to http://server/folder/file.accdb
This post on another explains the issue in more technical detail for those interested...
https://forums.asp.net/t/1929989.aspx?The+Microsoft+Office+Access+database+engine+cannot+open+or+write+to+the+file+