hi

[abc_777]

hi,

power bi service keep commection with MSSQL data base even after incremental refresh?

coz my data entry people get slow connection when they enter data as and database admin said its because of power bi connection. after i stop power bi service connection now its ok.

is it a cause?

thanks

[v-yalanwu-msft · Accepted solution]

Hi , @abc_777 ;

MSSQL should be in direct connection mode, generally speaking, power BI service keep commection with MSSQL data base.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abc_777]

as power bi service keep communication to MSSQL and there is no connection close options then what would be the solution as my users from different areas get database slow when sale thing from there.

how we can use database not get slow and also can use power bi incremental refresh automaticaly

thanks