Forum Discussion
Schedule refresh one table of data model
- Anonymous9 months ago
Hi Rahul_SC,
Thank you for reaching out to the Microsoft fabric community forum.
In Power BI there is no option to schedule refresh for only one table inside a dataset. Refresh always happens for the full dataset. Since only your MySQL table is changing multiple times in a day, you have two practical options, you can enable Incremental Refresh on the MySQL table so only new or changed data gets refreshed instead of the full history. This reduces load and refresh time or to separate the MySQL table into a different dataset and connect it using a composite model this way you can keep frequent refresh for MySQL and normal refresh for the rest. MySQL also supports DirectQuery using an on-prem gateway, but performance and RLS behavior should be tested properly before using it in production. Unfortunately, there is no direct way today to refresh only one table inside a single dataset.
please go through with the below document hope it may resolve your Issue:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Community Support Team.
Hi Rahul_SC
I hope you are well,
if you cant use the direct query so you can use Incremental Refresh and If you need full control over refresh → Split the dataset into two datasets and use a composite model.
here is similar issue as yours you can check it also:
https://community.fabric.microsoft.com/t5/Service/Refresh-schedule-for-composite-model/m-p/4822091
If this helps please mark my answer as Solution and drop a Kudos
Aala Ali
Pricing & Profitability Specialist | Data Analyst at Zain Telecom
Group Leader – Microsoft Sudan Fabric User Group
linked in profile: https://www.linkedin.com/in/aala-ali/