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

[manalla]

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

[manalla]

Hi can some one please help with this?

[NagarjunaBIUser]

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.

[manalla]

@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?

[manalla]

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!