Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Different schedule for each source when multiple sources are involved in one report

Hi. I created model with 3 sources. Two Sql and one teradata. Now I want to schedule each of the source at different frequency based on source system refresh. That is one source at 30 mins freq...
General Comment
NagarjunaBIUser's avatar
NagarjunaBIUser
Frequent Visitor
7 years ago

Use the Live Connection in Tabular Model with import mode of three different tables and create a  sepearte partition for each and Every table seperatly and put the schedule for the each partition as per your schedule.

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Nagarjuna I am not using tabular and we are not supposed to use any SSAS.
All the sources are direct import mode. And report is deployed to report server.

Any other suggestions?
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    I am badly looking for help here. I will need to refresh one source out of 5 in a different schedule. I am limited to use only Power BI and Report server.

     

    I heard this is possible with Rest API's. Can some one point me to right direction to explore, please.

     

    Thanks!