We have 2 different data sources and looking to populate a single report using both data sources. I have checked the data blending. Is there any other way to achieve this?
Please advise.
7 answers

You can populate data from both data source using join and in the joining condition specify 0 = 1, as shown below.
This will give you result from both the data.