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.