Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
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
Proud to be a Datanaut!
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.
Hi, @galbo1993
What connection mode are you using? Have you set schedule refresh?
Please share the refresh history screenshot(hide privacy)
Janey
Turn off the parallel loading for the tables in the Options.