We are trying to build a dashboard with two tabs connected to two different data sources respectively.
By making a selection on tab A (connected to data source A), we are expecting a value can be passed as a database parameters for data source B. Then tab B will display the data for only that passed parameter.
Due to the huge size of data source B and the required refresh frequency, we only want the data to be queried for the specific selection.
Can you create a simple bridge table than can hold these parameters?, Possibly join this table to both Data sources?.
Then apply cross data-source filtering, (edit relationships). But measures would have to be calculated keeping these duplicates in mind (using LOD).