Connecting Access Database - Scheduled data refresh using Enterprise Data Gateway

Power BI
1

Dear,

Is it possible to scheduled refresh Access database which sits in shared drive using enetrprise gateway? I know that it is possible using Personal gateway.

When we publish Power BI report using access database, online service treats access database as file (there is no access database option in gateway), though we try to provide fully qualified url for the path, it doesnt work.

Anyonce succeed on this, please provide some lead on this.

Thanks.

2

HI @sschaefer ,

Yes, it is possible to schedule a refresh for an Access database sitting on a shared drive using the Enterprise Gateway. Here is a detailed guide:

Prerequisites

  1. Enterprise Gateway Installation: Ensure that the on-premises data gateway (Enterprise mode) is installed and configured.
  2. Database Connectivity: Ensure that the shared drive is accessible from the machine where the gateway is installed.

Steps to Schedule Refresh

1. Set Up the Data Source in the Gateway

  • Open the Power BI Service.
  • Navigate to Settings.
  • Go to Manage Gateways.
  • Under the appropriate gateway cluster, click on Add data source.
  • Choose File as the data source type.
  • Fill in the required details:
    • Data Source Name: Give your data source a meaningful name.
    • File Path: Provide the network path to the Access database file (e.g., \\ServerName\ShareName\Database.accdb).
    • Authentication Method: Based on your network setup, provide the necessary credentials.

2. Configure Scheduled Refresh

  • Open your report in Power BI Service.
  • Go to Datasets.
  • Find your dataset and click on the ellipsis (...) next to it.
  • Select Schedule Refresh.
  • Configure the refresh settings including the frequency and time.
  • Ensure that the correct gateway and data source are selected.
  • Confirm the settings and save.

Troubleshooting Tips

  • Gateway Connection Issues: Verify that the gateway can access the network path and that there are no permission issues.
  • Authentication: Ensure that the provided credentials have access to the shared drive.
  • Gateway Logs: Check the gateway logs for any errors if the scheduled refresh fails.

Additional Resources

By following the above steps, you should be able to schedule a refresh for your Access database using the Enterprise Gateway. If you encounter any specific issues, feel free to ask for further assistance.

For more advanced guidance, refer to the Data Mentor platform to post specific queries.

Cheers,

Enterprise DNA Support Team

1 Like
3

@sschaefer ,

Maybe you can check Data Mentor response - thread is created at:

Good luck

1 Like