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

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

 

 

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

    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.