Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
DirectQuery with SQL statement from Power BI advanced option throwing error DirectQuery as below
Solved! Go to Solution.
@amitchandak Thanks for reply. Issue resolved. semicolon at end of query caused that issue. Removing semicolon from query resolved issue.
Thanks,
balaji R
@amitchandak Thanks for reply. Issue resolved. semicolon at end of query caused that issue. Removing semicolon from query resolved issue.
Thanks,
balaji R
@balajiratnala6 . Either the credential or path is wrong or it is a very old version of the SQL server not supported for direct query
Make sure you are able to connect to SSMS on the same machine.
Also, share the version of the SQL server used
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |