Schedule refresh one table of data model

[Rahul_SC]

Hi All,

I have a power bi report which is connected to CSV, excel files of one drive and mysql aws cloud database tables. I have RLS applied as well in this model. 

I want to apply a schedule refresh of just one table which is on mysql cloud. This tables gets updated multiple times in a day. I do not want to apply schedule refresh on all the datasets in this model.

Guide me how can I do this.

[v-hjannapu · Accepted solution]

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.

[v-hjannapu]

Hi @Rahul_SC,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.

[v-hjannapu]

Hi @Rahul_SC,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

[Anand24]

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.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Aala_Ali]

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/

[rohit1991]

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.

[Rahul_SC]

@rohit1991 thanks for responding. 

I think mysql does not give option for direct query. Only sql server supports direct query.

And, if I use direct query, then I think I can not use RLS. I have applied RLS using this table.