Access database - Scheduled data refresh using Enterprise gateway

[vpshamsbi]

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 using access database, online service treats access database as file, though we try to provide fully qualified url for the path, it doesnt work.

Anyonce succeed on this, please provide some lead on this.

Thanks.

[ibarrau]

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]

Data source is "Access Database"

[ibarrau]

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,