Unable to connect to the data source undefined (ACCESS)

[Anonymous]

I'm having trouble connecting any table from any access:

The gateway is working for reports that do not have access

The file mapping on the gateway works and says it has a "connected" status

Every update displays this error

I already tested with a gateway installed on another machine but has the same problem

[v-zhenbw-msft]

Hi @Anonymous ,

Try to restart the gateway and use the on-demand refresh.

Or you can try the way of this thread.

If it doesn’t meet your requirement, we suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

make sure the gateway has the latest Access engine installed and that the connection user has write access to the file location of the access database.

[Anonymous]

@lbendlin 

thanks for helpping

The answer to both questions is yes. Even yesterday I configured the gateway I'm connected to just because I had the same problem, and it worked connected in this new one. This morning, however, it gave the same problem as the other gateway.