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. 

     

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi galbo1993 ,

 

Can you provide more detail around "PowerBI is creating multiple queries towards the sql server" please?

 

How are you seeing these connections?

When is it happening?

- when you first open your PBIX,

- when refreshing in Desktop,

- or when refreshing in the Service etc.?

 

There's loads of reasons why PBI would make multiple calls to the server, so will also need detailed info on your queries and their structures e.g.

- are you using a lot of merges in your queries?

- are your queries all folding back to the server?

-- if not, then what are the functions being used at the steps where folding fails?

 

Pete

  • 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