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

[galbo1993]

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

[BA_Pete]

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]

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]

Hi, @galbo1993 

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

Please share the refresh history screenshot(hide privacy)

Janey

[JirkaZ · Accepted solution]

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