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 *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.

 

Need Help

8 Replies

  • 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.