Forum Discussion

Advocate I

7 years ago

Solved

SQL setup - Direct Query

Hi, We are sruggling with getting a Direct Query Connection to a SQL database on premis. We can complete a LOAD of data from the same SQL database, but when using Direct Query for the exact same ...

Need Help

v-cherch-msft
7 years ago
Hi jacschZA

Please check if below post could help

https://community.powerbi.com/t5/Power-Query/Schedule-Refresh-doesn-t-work-because-of-port-issues/m-p/537214#M20242

Regards,

v-cherch-msft

Microsoft Employee

7 years ago

Hi jacschZA

I cannot reproduce the same issue.I would suggest you update to latest version of Power BI Desktop ,please follow the instructions in the article below to troubleshoot this connection error.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-th...

Please check if below post could help.

https://community.powerbi.com/t5/Desktop/Can-t-connect-to-SQL-server/td-p/196782

Regards,

Forum Discussion

SQL setup - Direct Query

Related content

merging direct query queries

RLS over Direct Query

Direct Query issue with Snowflake

MySQL Connector - Direct Query

History Data in Direct Query