Forum Discussion
Connect to SQL Server on a Remote Desktop
Hello! I am looking for some assistance on getting my Power BI Desktop to connect with the SQL server I currently utilize at my workplace. When I attempt to connect I get an error stating that ...
Why is it needed to be configured as import mode? the documentation says that DirectQuery is also supported for SQL server connections, but for some reason I tried and was unsuccessful
Hey santiago_ortiz
I hope you've already resolved this situation.
About your question: You can use DirectQuery. In most cases the conectivity mode is Import, so, it is a default text.
And to be clear, your problem is not the conectivity mode, but rather the fact not being able to connect the database trough the network.
Regards,
Marcel