By default, the report sources are in import mode but when I published the report, it automatically picked up the scheduled cache refresh.  The report has different information sources. The following are some extra subtleties

The original report normal dataset and the linked dataset are fetching from same datasource based on datasourceId retrieving using Datasets - Get Datasources In Group (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup) api.

API output:

One of the data source from the normal dataset:

{      "datasourceType": "ODBC",      "connectionDetails": {        "connectionString": "dsn=power bi werp access"      },      "datasourceId": "5afa7f15-c429-4cf0-9c54-778a5ad1d167",      "gatewayId": "13fcb419-8701-4387-ab33- xxxxxxxx"    }

Same source from the linked dataset:

{

      "name": "2019669",

      "connectionString": "Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(ce561568-46f3-4b9b-b264-e3680a17d0ca)$;Location=Vendor;Extended=12321312,

      "datasourceType": "ODBC",

      "connectionDetails": {

        "connectionString": "dsn=power bi werp access"

      },

      "datasourceId": "5afa7f15-c429-4cf0-9c54-778a5ad1d167",

      "gatewayId": "13fcb419-8701-4387-ab33-xxxxxxxx"

    }

The scheduled cache refresh appears to be completing normal however the report data is NOT getting refreshed. Any idea why?

The master dataset that I’m checking is refreshing without any issues. The linked dataset refresh is also completing normally

However the data in the linked dataset is not same as the master dataset.  

Is there an approach to check which master dataset the linked dataset is connected to?