Forum Discussion

Didik62's avatar
Didik62
Frequent Visitor
4 years ago
Solved

[ASK] Scheduled refresh by each table in the report

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

dataset refresh
Scheduled data refresh
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    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.

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    4 years ago

    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.