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. Second one at 5 your freq and teradata at daily freq.

I am not finding this flexibility in report server once I deployed my report.

Any suggestions to acheive this?

Thanks
General Comment

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Hi can some one please help with this?
    • 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?