Is there any common key can be mapped from both data sources? if yes, you probably could use data blend.
You can blend data from two different datasources.
Data blending is a method for combining data that supplements a table of data from one data source with columns of data from another data source.
Have a look to the article below for more information on how to blend data and when to use it.
I hope this helps
I tried that option earlier and linking is happening with date fields.
But the data is coming as NULL.
Any other thoughts will be helpful.
Any sample workbook can be share to address your issue?
As I'm using live connections sharing workbook is not possible.
I will try with extracts and let you know.