Forum Discussion
Unable to create gateway connection for Access database using ODBC connection type
Hi Ynr225
Could I ask you to please try and move the access database to a new location and see if that fixes it?
Hi GilbertQ ,
I tried the above method but no luck still i am receiving the same error message in Power BI service.
Hi Ynr225
Could you check and make sure that the same user who is refreshing via the Gateway also has the same permssions to the Access File?Also maybe the Service account running for the Gateway needs to have additional permissions to the Access file?
Hello GilbertQ ,
I have lot of network drives and I was moved file to one of the network location and was able to create the gateway connection. But the user don't have access to that network drive and can't provide access because it was another team member network drive. I have checked the permissions as both of drives have read only access to the access database files.