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
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?
    • 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!