Forum Discussion

luxpbi's avatar
luxpbi
Helper V
7 years ago

Refresh error time out

Hi, 

 

Since Saturday I'm having troubles refreshing my Power BI reports from the Service. 
If I update them with the Desktop I have no issues, but when I try to do it with the service (Scheduled or On demand) it keeps working for hours and then it crashes: 

"Timeout occurred when sending or receiving a request".

My Gateway is working fine, and does not show any error message. 


Any ideas why? 

 

Thank you in advance. 

 

Regards.

Need Help

9 Replies

  • paulob_involves's avatar
    paulob_involves
    Advocate I
    7 years ago

    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.

    • luxpbi's avatar
      luxpbi
      Helper V
      7 years ago

      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.

      • paulob_involves's avatar
        paulob_involves
        Advocate I
        7 years ago

        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.

  • pierre_k's avatar
    pierre_k
    Regular Visitor
    7 years ago

    Hi, I'm experiencing the same issue. The report was working perfectly and updating every 3 hours until last Friday. From then, it fails systematically to connect to Salesforce Reports. It's worth noticing that I have no problem to connect to Salesforce Objects (as I use both).

     

    In the WebApp connectors authentication are all goor for SFDC Objects, and in error for Reports. When trying to reconnect with my SFDC credentials, they seem to be accepted but the authentication process get stuck with the looping dots until timeout.

    In the Desktop App, everything good with SFDC Object just like on the WebApp, but the behavior is a bit different for the SFDC Reports connector. It seems to accept the authentication and shows the Reports list window. But then it loads it endlessly.

     

    Here is the little track that I try to follow:

    I think it's nothing to do with the actual authentication to SFDC, and may be related to the way Power BI processes the reports list brought back by SFDC Rest API. SFDC applied its latest release on August 15th. I can't see the exact date of the latest Power BI release. So it probably the SFDC Reports connector which changed or the SFDC REST API which changed the data format of the response.

    • luxpbi's avatar
      luxpbi
      Helper V
      7 years ago

      In my case I have not a Salesforce connection, so I have submited a ticket because the problem persists....:smileysad: