Scheduled cache refreshing Issue

[prabakaran]

I just cloned and published an existing report as new report with some modifications.

The report data sources are in import mode but the new report refreshing technique has been changed from *Scheduled refresh* to *Scheduled cache refresh*

Scheduled cache refresh is not refreshing the dataset i.e. report is not showing the most recent data. The original report, which is in scheduled refresh works fine.

The new report dataset settings page gives me the underneath message.

The data gateway nws-enterprise-gateway is online, but one or more of your data sources is offline.

[V-lianl-msft]

Hi @prabakaran ,

Are you using this API?Reports - Clone Report 

If so, as the document says:If after cloning the report and its dataset reside in two different upgraded workspaces or "My Workspace", a shared dataset will be created in the report's workspace. 

You can see what the linked dataset looks like, and you can see the difference between a normal dataset and a linked dataset.

You cannot manually refresh or refresh based on the schedule on a linked dataset. The refresh action can be only configured in the main dataset. 

When the scheduled refresh of the master dataset is complete, you can use the scheduled cache refresh to refresh the linked dataset.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prabakaran]

Hi@V-lianl-msft ,

Thanks for API details.

It appears to me, both the 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?

Refresh historySettings page

[V-lianl-msft]

Hi @prabakaran ,

Is the master dataset refresh complete?When the of the master dataset is complete, you can use the scheduled cache refresh to refresh the linked dataset.

If the master dataset refresh is completed and the cache refresh is not successful, please try to clear the cookie of the browser and restart the browser.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prabakaran]

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?

[V-lianl-msft]

Hi @prabakaran ,

Find your report in the workspace and click view related. You can see which dataset is linked to.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prabakaran]

@V-lianl-msft,

From the view related, I was unable to discover where the dataset cache is originating from.

The dataset with scheduled cache is stating as refreshed today however the actual data is month old.

Both dataset and report view related screens.

[V-lianl-msft]

Hi @prabakaran ,

Let's go back to the previous reply.

If you are sure the master dataset refresh is completed and the cache refresh is not successful, please try to clear the cookie of the browser and restart the browser.

If you have a pro license,you can  also create a support ticket to help you.

https://powerbi.microsoft.com/en-us/support/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prabakaran]

I've cleared the browser cache but it did not work for me.

Created a support ticket.  Thanks @V-lianl-msft.