Table/Source specific Refresh Schedule

[Anonymous]

Hi,

Assume the following scenario...

I have two tables...

Table 1: Stores historical data for the past 3 years up to last month.

Table 2: Stores data of the current month from 1st to Day-1.

Both columns have the same set of fields with the same data types. One point to note is that the source of Table 1 is SQL server DB and the source of Table 2 is a JSON document that I am fetching from Web that is converted to the same format as Table 1.

Is it possible to create a refresh schedule to refresh Table 1 at the beginning of every month and refresh Table 2 on a daily basis?

I will be using a UNION of these two tables for the reporting...

[v-yuta-msft]

@Anonymous ,

Does these two tables in one dataset/report? If they are, I'm afraid schedule refresh could only be set on dataset level, not table/data source level.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

These two tables are in the same dataset. Only the source of these two tables is different. 

Actually, I am aware that the refresh schedule can be set at the dataset level and one report can have only one dataset.

The reason for posting the question in the forum is that I wanted to know if there is any workaround.

[TomMartens]

Hey,

unfortunately it's not possible using scheduled refresh.

Regards,
Tom