topic Re: Scheduled Cache Refreshing issue in Developer

Scheduled Cache Refreshing issue

prabakaran — Wed, 06 May 2020 20:03:32 GMT

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.

Re: Scheduled Cache Refreshing issue

v-easonf-msft — Thu, 07 May 2020 02:11:44 GMT

Hi , @prabakaran

What data source you are using?

I'm little confused about this word"The report data sources are in import mode but the new report refreshing technique has been changed from *Scheduled refresh* to *Scheduled cache refresh*".

How did you convert the data source from import mode to directquery mode? By creating a new report and then copying the visualizations one by one?

Maybe you can take a try to configure a new datasoucre in your gateway.

Best Regards,
Community Support Team _ Eason

Re: Scheduled Cache Refreshing issue

prabakaran — Thu, 07 May 2020 20:56:55 GMT

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?

Re: Scheduled Cache Refreshing issue

prabakaran — Fri, 08 May 2020 15:30:57 GMT

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?

Re: Scheduled Cache Refreshing issue

v-easonf-msft — Tue, 12 May 2020 09:27:25 GMT

Hi , @prabakaran

This is too strange .In theory, when there is a model of mixed data sources of import and directquery, the service will only display the option of “Scheduled Refresh ” rather than “Scheduled Cache Refresh”.

Please check if there is some query that the option "Include in report refresh" is not selected.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Scheduled Cache Refreshing issue

v-easonf-msft — Wed, 27 May 2020 07:20:59 GMT

Hi , @prabakaran

Could you please tell me whether your problem has been solved?
If it is, could you please add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason