Forum Discussion
Refresh error time out
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.
Exactly, Salesforce data merged with a table stored in Sharepoint.
where did you place these 2 buffers. you said first steps and last steps. Did you make it the first step and last step or after a specific step?
