Forum Discussion

prabakaran's avatar
prabakaran
Frequent Visitor
6 years ago

Scheduled cache refreshing Issue

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 *Sch...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

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's avatar
prabakaran
Frequent Visitor
6 years ago

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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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's avatar
      prabakaran
      Frequent Visitor
      6 years ago

      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's avatar
        V-lianl-msft
        Community Support
        6 years ago

        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.