Forum Discussion
Solved
How to pass power bi parameters to native sql query with DirectQuery mode
I am trying to pass power parameters to native SQL query with DirectQuery mode as placeholders as below select sr.enddate at time zone 'UTC' at time zone '"&setTimeZone&"' from sub_result sr ...
Issue resolved. Initially i have given wrong parameter placeholder , due to that have some problems . To resolve that problem, changed EnableFolding to false. After given right parameter placeholder , not changed EnableFolding to true that causing issue.
Anyhow helped me Anonymous post resolve issue by re-checking any mistakies in query formation.
Issue resolved. Initially i have given wrong parameter placeholder , due to that have some problems . To resolve that problem, changed EnableFolding to false. After given right parameter placeholder , not changed EnableFolding to true that causing issue.
Anyhow helped me Anonymous post resolve issue by re-checking any mistakies in query formation.