Forum Discussion

cecyarmida's avatar
cecyarmida
Frequent Visitor
7 years ago

Dataset refresh has stopped working with different errors each time I try to refresh

Hi all,

On Friday I relased a new version of my data set and Saturday and Sunday it refreshed correctly. But it failed on Monday morning, my dataset connects to an Azure Function Proxy.  I can still refresh my dataset on desktop but fails once it is published.

 

Most times I get this error with different table:

The command has been canceled. Table: XXXX


Has anything changed that I need to be aware? 

Many thanks,

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Looks like there may be a human intervention for canceling it at the data source end or the query may reach a threshold determined by the source system admin, that leads to auto-cancellation. Please check the scheduled refresh history.

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi cecyarmida,

     

    Can you post the error messages here? You can mask the confidential parts. I just need these IDs and the error details. Please post the latest error messages.

     

     

    Best Regards,

    Dale

    • cecyarmida's avatar
      cecyarmida
      Frequent Visitor

      Thank you Dale,

      Today I got a different error, on my chages I added a List.Contains from a biffered List:

       

      Message: [Unable to combine data] Section1/Job/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Table: Job.
      Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
      Activity ID: dc3f443d-633b-408b-baaa-1cdfd5d3ca1b
      Request ID: 147d4c30-b820-4116-8683-af5c0673e697

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi cecyarmida,

         

        1. Did you use the Data Gateway (personal mode)? I would suggest you try the Data Gateway (the other one).

        2. What does the table JOB look like? Is it a normal table from a data source?

        3. I also found many error messages like "the gateway is unreachable". Please check out.

         

        Best Regards,

        Dale