Forum Discussion
Refresh error time out
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.