Forum Discussion

RMM2C's avatar
RMM2C
Frequent Visitor
6 years ago

Dataset not refreshing

Hello,   I have a dataset connected to 9 folders on Azure Data Lake Gen1. The folders contain CSV files and each day it is stored a new one. Therefore we have programmed the refreshing every day, r...
Dataflow
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi RMM2C ,

There are several points you may considerate:

  1. Your data source credential may expire, try to update the credential
  2. If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: On-premises data gateway , Configure scheduled refresh .Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
  3. Ensure that you've added one or more data sources of your dataset to the gateway, as described in Add a data source.
  4. Please make sure the gateway is online, and try to upgrade the gateway to latest version.
  5. Please set schedule refresh for different datasets at different times, make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities. Also we suggest that you first disable all refreshes on all capacities. Then slowly enable the refreshes one by one. Make sure refreshes are staggered apart (e.g. 1 hour apart), and that no more than max concurrent refreshes happen at overlapping time periods.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • RMM2C's avatar
    RMM2C
    Frequent Visitor
    6 years ago

    I tried everything you say and still can't access the files. However, one of the times, the refreshing error change. Now I have two. 

     

    1st

    {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Unable to connect to the remote server"}}],"exceptionCulprit":1}}} 

     

    2nd
    Unable to connect to the remote server. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.