Forum Discussion
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
I am facing below issue
Need help on it.
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.
2 Replies
Hi balajiratnala6 ,
Please check the limitations listed in the documentation.
Dynamic M query parameters in Power BI Desktop
Similar threads:
Dynamic M query parameters fail to load data - Microsoft Power BI Community
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
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.
