HelloI 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 /report be edited so that this does not happens?

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

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

JirkaZ
Solution Specialist
4 years ago
Turn off the parallel loading for the tables in the Options.
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
  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
    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