Solved: Refresh Access Table

LL66 · ‎02-26-2018

My dashboard uses data from an Oracle database and an Access table. I'm able to refresh manually, but haven't been able to set auto refresh. Any ideas on how to set the automatic refresh?

v-yuezhe-msft · ‎02-27-2018

@LL66,

In your scenario, you can install on-premises gateway(personal mode) and use it to refresh your dataset. Directly enter credentials for the two data sources(Oracle and Access) in Power BI Service, this way, you will be able to set schedule refresh.

In addition, please note that Power BI Service can only leverage 64 bit drivers, please use 64 bit access.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yuezhe-msft · ‎02-27-2018

@LL66,

In your scenario, you can install on-premises gateway(personal mode) and use it to refresh your dataset. Directly enter credentials for the two data sources(Oracle and Access) in Power BI Service, this way, you will be able to set schedule refresh.

In addition, please note that Power BI Service can only leverage 64 bit drivers, please use 64 bit access.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Refresh Access Table

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024