Access Database On-Prem Enterprise Gateway

Question

We are using the enterprise gateway, but I&nbsp;am having trouble getting an MS Access DB added. I need to have it refresh on a scheduled basis.&nbsp;What is the best way to get an MS Access DB to refresh on a schedule?

zoloturu · Answer

Anonymous,&nbsp;Do you need to have a report in Power BI Service to be refreshed or Power BI Desktop?&nbsp;Here is an article on how to set schedule for a report in Service -&nbsp;https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

anonymous · Answer

I built the report in PBI Desktop, published it to the service. I've created dashboards off of that. I need all of that to refresh on a regular basis without me having to open up the PBI Desktop file and click "refresh" and then click "publish".

zoloturu · Answer

Anonymous,&nbsp;Go to your workspace -&gt; Datasets -&gt; Find dataset related to your report -&gt; Press Schedule refresh -&gt; Go to Scheduled Refresh and set time and frequency

anonymous · Answer

We have an on-prem enterprise gateway installed, but I do not have a personal gateway installed.&nbsp;I need instructions for my IT guy to add the access databse to the gateway. He was able to add sharepoint, but it doesn't appear that it will support ms access.&nbsp;

anonymous · Answer

HI&nbsp;Anonymous,
&nbsp;
Access database is a file, I'd like to suggest you add new datasource with 'file' type.&nbsp;
Access Database in Power BI Online &nbsp;
&nbsp;
Regards,Xiaoxin Sheng

Forum Discussion

Access Database On-Prem Enterprise Gateway

7 Replies

Related content

Best Practice for connecting to on prem databases

Copy activity from on-prem to Fabric SQL Database

Mirroring on-prem SQL Server database

Lakehouse query output to on-prem sql database

On-Prem Data Gateway proxy issue