We need to connect a Access db to the Power BI via the gateway (so we can have an automatic refresh).
I believe we need to use the ODBC connection to be able to have automatic refresh.
I have not have much success implementing it.
Has anybody else successfully connected via the ODBC?
We have successfully connected a SQL database to the Power BI using the on-premises Data Gateway, refreshes automatically 8 times a day.
Azure cloud server (Ms server 2019)
Ms Access (2019) database, split FE and BE both in Access (no plans for SQL backend for Access)
on-premises Data Gateway