How to pass power bi parameters to native sql query with DirectQuery mode

[balajiratnala6]

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.

[balajiratnala6 · Accepted solution]

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  @v-cgao-msft  post resolve issue by re-checking any mistakies in query formation. 

[v-cgao-msft]

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 Team

If 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