Forum Discussion

Noak's avatar
Noak
Helper IV
9 years ago
Solved

Data Refresh Error

Hi , My organization is working with SQL Server pbi connection. It was a rough journey to integrate SQL Server with pbi , last week we succeed to do it and then got this error while refreshing data...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Noak, if it is always getting to the same amount of rows then it could possibly be a timeout on the SQL Server side? Or somewhere inbetween.


    I am sure that the SQL Engineer will be able to check the code and possibly add indexes to make the query return faster?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi  Noak,

 

Can you share some detail information to help us clearly know your issue?


For example:


1. Database type(SQL Server, SSAS, or other type of sql?)

2. Connect mode(Import, directQuery, liveconnection?)

3. Refresh type(manually or scheduled refresh?)

 

In addition, can you share some screenshots of your dataset? It will be help to know the connection state of gateway.(you can find it at Settings -> Dataset)

 

 

Regards,

Xiaoxin Sheng

  • Noak's avatar
    Noak
    Helper IV
    9 years ago

    Hi Anonymous,


    1. Database type(SQL Server, SSAS, or other type of sql?) SQl Server

    2. Connect mode(Import, directQuery, liveconnection?) Import

    3. Refresh type(manually or scheduled refresh?)Manually & Schadualed

     

    I removed the gateway an reinstall it , the data succeed to refresh 2/3 times and then again I'v got an error please via screen shots:

     

     

     

    • GilbertQ's avatar
      GilbertQ
      Super User
      9 years ago

      Hi Noak, it appears that you are getting timeouts, which would be consistent as to why it sometimes works and then other times it does not work.

       

      You would need to ensure that connectivity is fast enough from the Power BI Service, to where you have installed the Data Gateway?

       

      As well as how much data you are returning, and how efficient your SQL Query is to import the data. Those could all affect why it is timing out.

       

      One way to test is when there are few people in the office, and see if you manually refresh if that is successful? If it is, then it can indicate that during the data there is not enough bandwidth to refresh?

      • Noak's avatar
        Noak
        Helper IV
        9 years ago
        Hi GilbertQ ,
        we tried to manually refresh during the weeknd (0 people in the office) still got the same error.
        .