Schedule refresh one table of data model

Hii Rahul_SC 

Power BI cannot schedule-refresh a single table inside a dataset  the refresh always runs at the dataset level. If you need only the MySQL table to refresh multiple times a day, the only workaround is to separate that table into its own dataset (or use DirectQuery if possible). Once separated, you can schedule frequent refresh only for that dataset while keeping the others on a normal schedule. There is no built-in option to refresh individual tables within a shared data model.

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/

Hi Rahul_SC,
Refreshing only certain tables in the model is not possible in Power BI.

One work-around I can think of is creating a separate dataset with only this one table, publish it, pull it into existing/main dashboard using live dataset connection and create the relationships. You can then only refresh the singular table dataset. Since live dataset connection uses DirectQuery, refreshed data will be automatically refrlected.