Joining two Direct Query's from different sources?

Question & Answer
, , , ,
1

I have two direct query’s from two different sources, ‘source1’ and ‘Source2’. I do left joining the two datasets with ID. When I do a join the final dataset is going to SPICE.

If I refresh the Joined Dataset. Will both source1 and Source2 datasets get refreshed or not as they are direct query’s ?

2

Hi @praveen.gp – Concept of refresh only applies to SPICE dataset. Direct Queries will be triggered against the data source directly at the time of execution.

2 Likes
3

Hi @awsvig
Thanks for the reply.

Here in my scenario,
The dataset1(direct query) is left joined with dataset2(Direct query). So here the dataset1 is showing as the SPICE after joining with dataset2 which is still a Direct query.

when the joined dataset gets refreshed will the queries run in background ?

4

Hi @praveen.gp - Yes the queries will be triggered to get the latest data from data source when the dataset is refreshed.

2 Likes