Forum Discussion

galbo1993's avatar
galbo1993
Regular Visitor
4 years ago
Solved

row_number over partition sql server - error and performance in PowerBi

Hello Having a view containing this command : row_number over partition  results in timeout when executing the view from PowerBi. Its working fine if executed in SSMS.  I got to know from a coalleg...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi galbo1993 ，

     

    Generally speaking, I think most commands should be supported. What easily affects performance is the amount of data, and if you have very large data, a simple command may also cause slow queries.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

galbo1993's avatar
galbo1993
Regular Visitor
4 years ago

Thankyou so much for nice response. But do you know anything specific for the mentioned command regarding more performance issues onPowerBi?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi galbo1993 ，

 

Generally speaking, I think most commands should be supported. What easily affects performance is the amount of data, and if you have very large data, a simple command may also cause slow queries.

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly