Forum Discussion
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
- AnonymousNot 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-msftMicrosoft 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
- cecyarmidaFrequent 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-msftMicrosoft 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