Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

hi

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

 

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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's avatar
      abc_777
      Solution Specialist
      4 years ago

      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