Forum Discussion

Ynr225's avatar
Ynr225
Helper II
1 year ago

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...
Need Help
GilbertQ's avatar
GilbertQ
Super User
1 year ago

Hi Ynr225 

 

Based on the error above what it is saying is that the Access is already open. And what that means is you need to close the file. So that is not open and being used by anyone, or it can be read via the Gateway.

Ynr225's avatar
Ynr225
Helper II
1 year ago

Thanks for responding GilbertQ , I checked from my side and confirmed that no one has opened Access database. Again i tried to create the gateway but no luck. I can see the same error.

 

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 year ago

    Hi Ynr225 

     

    Could I ask you to please try and move the access database to a new location and see if that fixes it?

    • Ynr225's avatar
      Ynr225
      Helper II
      1 year ago

      Hi GilbertQ , 

       

      I tried the above method but no luck still i am receiving the same error message in Power BI service.

       

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        1 year ago

        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?