Forum Discussion
Unable to create gateway connection for Access database using ODBC connection type
Hello All, Using connection string ODBC Microsoft Access database as a datasource in Power BI desktop, I was connected and built a report. I have published the report into Power BI service to col...
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.