Refresh one table only out of the many

[kabra_ashish]

I have a Power BI report with multiple tables in the data model. The on-premises gateway has been created and mapped. A weekly scheduled refresh has been created and it works fine.

Out of these tables I have ONE table which needs to be refreshed daily while continuing to keep all the other tables refresh weekly. Is this possible?

[OBMBI]

If you're using Premium per Capacity or Premium Per user, you can connect to your datamodel refresh an individual table using the SSMS integration with PowerBI. See the tutorial below.

https://guyinacube.com/2021/01/27/avoid-the-full-refresh-with-incremental-refresh-in-power-bi-premiu...

[jcampbell474]

I am very interested in having this capability.  Did you figure out a solution?

[kabra_ashish]

Still haven't found any. 

[d_gosbell]

Currently the only options for this would be:

• Incremental Refresh or
• manual refresh commands via XMLA Endpoint (currently in preview)

However both of these options currently require a Premium workspace.