Forum Discussion

vpshamsbi's avatar
vpshamsbi
Frequent Visitor
3 years ago

Access database - Scheduled data refresh using Enterprise gateway

Dear, Is it possible to scheduled refresh access database which sits in user machine using enetrprise gateway? I know that it is possible using Personal gateway.   When we ublish Power BI report u...
Need Help
ibarrau's avatar
ibarrau
Super User
3 years ago

Hi. We need more information to help you. What's the data source? before saying "Yes you can use the enterprise gateway for a database" we need to know what we are dealing with. That's usually the way to go with regular databases like SQL Server.

Regards,

vpshamsbi's avatar
vpshamsbi
Frequent Visitor
3 years ago

Data source is "Access Database"

  • ibarrau's avatar
    ibarrau
    Super User
    3 years ago

    Ok. This is consider an old database. As far as I remember, you can only use Personal Gateway with this source. I don't think I have seen a post or article about a new compatibility with Enterprise Gateway and if you try adding a source with that gateway there is no Microsoft Access option at the drop down list.

    You probably need the same connector installed for getting data with PowerBi Desktop to be installed at the Gateway machine too. This one: https://www.microsoft.com/en-us/download/details.aspx?id=54920

    I think you can test it with the "file" data source if you want to try, but there is not doc specifying that functionallity.

    You don't need to be scared, you can use a personal gateway to configure a schedule refresh.

    I hope that helps,