Forum Discussion
Auto Update data table in PowerBI from my MYSQL Database Table
Hi
Im a Resher in Power BI.
Can anyone please help with my Auto Table updation.
My datas are in MYSQL table. If i need to schedule every 4 hours auto table refresh so that my power BI reporrs gets updated from the MYSQL database table, what is teh procedure for teh same?
Faisal
Anonymous , You have configure incremental load
Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
2 Replies
- Fowmy
Super User
Anonymous
You need to install Power BI Gateway and configure schedules refresh, pleas refer to these articles:https://www.youtube.com/watch?v=kdaolMKsSOA
https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
- amitchandak
Anonymous , You have configure incremental load
Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
