Forum Discussion
abc_777
Solution Specialist
Solution Specialistmssql and PBI
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,
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
1 Reply
- amitchandak
Super User
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