Forum Discussion
Solved
Power BI Refresh From Access Database
I have connected to an access database on my power bi desktop (IMG1). I can refresh the data on power bi desktop with the refresh button and it loads in with the latest data from the access database...
- Hi there
Have a look at this to assist you
https://community.powerbi.com/t5/Power-Query/Using-MS-Access-as-a-data-source-with-On-Premises-Data-Gateway/td-p/451433
Hi Ivolution93 ,
1. When you configure gateway, the file path should be the access database path, not the .pbix file path:
2. After configuring gateway for the access dartaset successfully, find the dataset and choose 'Refresh Now' or configure 'Scheduled refresh' for it, check the refresh history which show the refresh is completed.
3. Now you can click the refresh button in the report page to refresh data or refresh the browser to get the latest data in your access database.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.