[ASK] Scheduled refresh by each table in the report

[Didik62]

I am looking the way for setting the scheduled refresh by each table.

I have tables that required data refresh once/day and also i have tables for once/hour.

since i have a lot of table in one report, it will need longer time for refreshing all tables with configuration once/hour data refresh.

I want to keep data refreshed as needed but in the shorter time

Anyone know how to figure it out?

Thank you

[d_gosbell · Accepted solution]

This is not possible on Report Server. The only way to do this currently for a pbix file is if you have Premium Per User or Premium Capacity. Then you can use the XMLA endpoint to send specific refresh requests to specified sets of tables.

[Didik62]

Thank you