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 MemberNeed to maintain all are the same bit of versions.
1. Power BI Desktop
2. Access Database
3. On-premises Data Gateway
Please refer the link.
If the issue is persists, can you please try to copy the network drive file to local drive and try to re-pro the issue.
If the issue is persists, please let us know.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?
- UAV-Test-Pilot
venal 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.
- venal
- 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+