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?

Noak's avatar
Noak
Helper IV
9 years ago

Hi GilbertQ,
thank you for your reply.


I changed the comant timeout to 20 minutes and the refreshing is working until it gets to 900,000 rows. At that point it stops. and doesn't send any error - just stops (like it finished but it didn't there ar more rcords to update).

I know the pbi can refresh up to 100 million records.
I asked our SQL engineer to look at the code, what do you think is the reason for this simultaneous stopping?

 

BR,

Noa.

GilbertQ's avatar
GilbertQ
Super User
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?