topic Re: Refresh one table only out of the many in Report Server

Refresh one table only out of the many

kabra_ashish — Tue, 01 Oct 2019 16:04:13 GMT

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?

Re: Refresh one table only out of the many

jcampbell474 — Tue, 19 Nov 2019 00:32:20 GMT

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

Re: Refresh one table only out of the many

kabra_ashish — Tue, 19 Nov 2019 04:14:45 GMT

Still haven't found any.

Re: Refresh one table only out of the many

d_gosbell — Tue, 19 Nov 2019 04:37:58 GMT

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.

Re: Refresh one table only out of the many

OBMBI — Mon, 16 Aug 2021 11:26:07 GMT

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-premium/