Setup auto refresh data connection to network hosted Access DB

[Anonymous]

I have an existing Access DB hosted on another machine on my enterprise network. I would like to connect to it in such a way that I am able to schedule systematic refreshes once it is published. I have the IP address of the machine available. Please can you advise how to do this, preferably without any migration as the db is an integral part of the existing infrastructure.

[Icey]

Hi @Anonymous ,

Is this problem sloved?

If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @Anonymous ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey

[Anonymous]

Not resolved sadly 😞

[Icey]

Hi @Anonymous ,

Did you install any Gateway to refresh the data?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey]

Hi @Anonymous ,

Automatic refresh is not available within Power BI Desktop and the only refresh option within Power BI Desktop is the Manual Refresh you can find in the top ribbon. You can refer to this article: Data refresh in Power BI.

And if you require automatic refresh of your data, publish the report to Power BI Service and configure scheduled refresh.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Maybe I wasn't clear enough initially, sorry. I am looking for a way to configure the Scheduled Refresh, given that my data source is an Access db hosted on a local network machine. Currently when I go into Settings, Data Source Credentials is greyed out, and so is the contents of the Scheduled Refresh section.