Forum Discussion
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...
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
amitchandak
Super User
Super Usergalbo1993 , In can direct query it can impact the visuals display time.
In case of import mode, if can only slow download time and the visual display time
Thanks, I dont understand what do you mean, can you please describe more?
BTW, I found out its "Import"