Forum Discussion

galbo1993's avatar
galbo1993
Regular Visitor
4 years ago
Solved

Report is creating multiple queries/process in background to SQL server

Hello I am experiencing SQL  server performance issues and can see that a report from PowerBI is creating multiple queries towards the sql server. Can someone explains why and how can the powerBi /r...
Need Help
  • JirkaZ's avatar
    JirkaZ
    4 years ago

    Turn off the parallel loading for the tables in the Options. 

     

galbo1993's avatar
galbo1993
Regular Visitor
4 years ago

Hi BA_Pete 

Its a report refreshing through Power BI Service.

The query is just "select * from 1 view "

The query however is taking a lot of time and at some point failing but I do not understand why Power bi restarts it automatically.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, galbo1993 

 

What connection mode are you using? Have you set schedule refresh?

Please share the refresh history screenshot(hide privacy)

 

Janey