mssql and PBI

[abc_777]

Hi,

I know when I pull data from MSSQL using power bi that time other people like shop or warehouse get slow to MSSQL

but after completion of data pull why those people get slow to enter data in MSSQL

does PBI keep a connection to MSSQL or is there any reason PBI makes MSSQL slow even not pull data?

regards,

[amitchandak · Accepted solution]

@abc_777 , No, if you are using import mode after data pull it should not slow down.

MySQL creates cache files when the big query is run, just check is causing issues. Or open connections