Forum Discussion
Scheduled Cache Refreshing issue
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
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?