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.
Hi,
I want to load data from SQL Server I write SQL query for it. My SQL query code work perfect when I select import Data connectivity mode but getting below error.
please help why I am getting error ??
Solved! Go to Solution.
Hi @lavdeep ,
There are currently a few limitations to using DirectQuery:
You can learn more :https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery,
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @lavdeep ,
From your error message, there is something wrong with the bracket ")" in your SQL query code, maybe miss , excess or in wrong place. Please check it.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xicai
thanks for reply
If SQL query code incorrect then it should not work with data connectivity import mode but SQL query code execute without any error. I am getting the error when I select direct Query mode with same SQL query code
Hi @lavdeep ,
There are currently a few limitations to using DirectQuery:
You can learn more :https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery,
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |