Forum Discussion

CMcAlpine's avatar
CMcAlpine
Frequent Visitor
10 years ago
Solved

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...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    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. 

MattAllington's avatar
MattAllington
Community Champion
10 years ago

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.