Forum Discussion
Scheduled cache refreshing Issue
HiV-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
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.
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?
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.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.