Unable to add Microsoft SQL server connection

I am unable to add the custom query connection with MS SQL server. it connects to the server, it retrieves the tables but when trying to add the customer query, it throws popup with this error, I don't see any service health complications for looker studio, does someone else also experiences the same? 

alexiamni_0-1744295226143.png

 

0 0 28