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+
Helper IIvenal Appologies if I didnt explain that clearly in my original post, but I thought that would be an issue so I tried that as well.
I created a new access database in 64 bit access, and connected to it from PBI 64 bit, and have Access 64 on the gateway server.
I still get the same error.
Memorable Member- UAV-Test-Pilot
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+