Forum Discussion
Refresh error time out
I was having this problem too, and sometimes the error message said it was related to a certain query, other times to another query - both of them involved merging data from other queries.
I inserted a few Table.Buffer in the beginning and at the end of a few queries that were involved in the data merging, and it started refreshing in the service again.
Thank you for your reply paulob_involves but the error doesn't reference to any query in particular, or at least I don't know where to look.
Could you please develop a little bit more where you finded the error and how you solved it with some screenshots? Like that I'm going to be able to see if we are talking about the same case.
Thank you.In the service (web), under dataset configurations you can click in Refresh History, for me it shows in the details the problematic table:
"Timeout expired. The timeout period elapsed prior to completion of the operation. Table: SF_fDataSales."
From there I went to Power Query, and in the query steps I edited the formula of one of the first steps of this table, including a Table.Buffer function. Then I did the same for one of the last steps.
But that's a weird solution for a weird issue, I was about to open a support ticket when this solved my problem, and I don't know why it worked. If you're on Pro license I'd advise you to open a support ticket instead.
I have noticed this as well in the error logs. After doing a bit more research and troubleshooting, it seems as if this error is specific to cloud data sources. I was able to run a successful refresh in the service with a dataset containing non cloud data sources. Any dataset with a cloud datasource will experience this exact same issue.
I am assuming the table your error log was referencing was a Salesforce table (SF_fDataSales?).
Thanks for suggestion on leveraging Table.Buffer. Will give that a shot and see what the outcome is.
