Forum Discussion

balajiratnala6's avatar
balajiratnala6
Helper I
3 years ago
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 ...
Need Help
  • balajiratnala6's avatar
    balajiratnala6
    3 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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