Forum Discussion
SQL Server connection with DirectQuery
Hi, I am trying to create a dashboard that connects to a SQL Server database with DirectQuery mode. I have no problem connecting to such database in DBeaver as well as with the import mode in Pow...
Can you connect to the SQL server database and query the view/table in question with SSMS?
What version of SQL Server is it? "SELECT @@Version
Yes, I can connect to that table in SSMS.
The version is:
Microsoft SQL Server 2022 (RTM-CU9) (KB5030731) - 16.0.4085.2 (X64) Sep 27 2023 12:05:43 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 20.04.6 LTS) <X64>