Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Access Database On-Prem Enterprise Gateway

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

7 REPLIES 7
zoloturu
Memorable Member
Memorable Member

@Anonymous,

 

Do you need to have a report in Power BI Service to be refreshed or Power BI Desktop?

 

Here is an article on how to set schedule for a report in Service - https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Anonymous
Not applicable

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".

@Anonymous,

 

Go to your workspace -> Datasets -> Find dataset related to your report -> Press Schedule refresh -> Go to Scheduled Refresh and set time and frequency

Anonymous
Not applicable

We have an on-prem enterprise gateway installed, but I do not have a personal gateway installed. 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.

 

HI @Anonymous,

 

Access database is a file, I'd like to suggest you add new datasource with 'file' type. 

Access Database in Power BI Online  

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Yes I've done that in the PBI Desktop file, but how do I get this to refresh without manually refreshing the file and then clicking publish, without a personal gateway?

Hi @Anonymous,

 

Nope, current it seems like only allow with personal gateway.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.