Forum Discussion
sprakash1192
Helper II
Helper IIIncorrect syntax near keyword OPTION
I have a view using CTE in my SQL databse. I am trying to import the data from the view in Power BI using: select * from WeekCalendar OPTION (MAXRECURSION 0) ; The above SQL runs perfectly ...
I already had.
But I changed some of my SQL scripts and not use CTE, I am fine with the issue now.
amitchandak
Super User
Super UserEnable Query profile and check what query power bi sent.
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages