Forum Discussion
Power BI Enterprise - Access Database
I've been searching all morning to see if there's a way to do this, but essentially i have many many data sources set up through the Gateway and require another query to an on prem access database. I'm currently utilising the Enterprise Gateway and cannot see any Access DB connectors.
Am i going crazy/blind or is this something coming?
MS Access is not a server, just a file. You can certainly connect to a file using the personal gateway - I'm not sure if it works with the enterprise gateway or not. To test it, configure a power bi desktop file that connects to the access DB in its resting location (visible to the gateway of course). Then publish and see if it refreshes.
3 Replies
MS Access is not a server, just a file. You can certainly connect to a file using the personal gateway - I'm not sure if it works with the enterprise gateway or not. To test it, configure a power bi desktop file that connects to the access DB in its resting location (visible to the gateway of course). Then publish and see if it refreshes.
The enterprise gateway does support file/folder for scheduled refresh. Definitely try what Matt suggested. Let me know if that doesn't work.
Thanks guys, i'll try to treat it as a flat file and go from there!
