Forum Discussion
Power BI Data Refresh to AS400
To enable automatic data refresh for your Power BI report using an ODBC connection to AS400, you'll need to set up an On-Premises Data Gateway. Here’s a step-by-step guide:
- Install the On-Premises Data Gateway: Download and install the gateway on a machine that has access to your AS400 database.
- Configure the Gateway: During installation, sign in with your Power BI account. Once installed, open the Gateway app and configure it to connect to your data source (AS400 via ODBC).
- Data Source Settings in Power BI: Go to Power BI service, navigate to "Settings" > "Data sources" and link the ODBC connection to your Gateway.
- Set Up Data Refresh: In the Power BI service, go to the report, select "Schedule Refresh" under the dataset settings, and enable the refresh schedule (daily, weekly, etc.).
- Ensure Connectivity: Make sure the machine running the Gateway is always on and can reach the AS400 database.
Once the setup is complete, the data will automatically refresh based on your schedule, and you can share the updated report with your managers.
Your solution is so great lbendlin
Hi, Anonymous
After you install the on-premises enterprise gateway on your host, you can create a new gateway in Power BI service with the following link:
Follow the link below to fill in the corresponding information:
Power Query IBM Db2 database connector - Power Query | Microsoft Learn
Then configure this gateway connection for your semantic model:
Finally, set up a scheduled refresh:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.