Unable to connect to SQL DB server (error 25)

[Anonymous]

Hi guys, 

So I've tried to connect (get data) from SQL DB server as a DirectQuery and got an error 25 - Connection String is not valid. But when I tried to import data from that server it was successful and I was able to visualise it. However working with a large set of data (couple hundreds of rows and 10+ columns) it would be more logical to connect via DirectQuery. Is there anything you can suggest? 

Edit: Has anyone had this issue before and if yes, how did you resolve it?

[Icey · Accepted solution]

Hi @Anonymous ,

Please check if this post is helpful: SQL setup - Direct Query.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.