Forum Discussion

haider378's avatar
haider378
Regular Visitor
4 years ago

Date parameter SAP Hana

Hi,   I have query from SAP hana that contain start date and end date, I am try to manage this start and end date with Power Query parameters. below is my query   --Khi Branch Receipts by Haider ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

haider378 
You cannot use the parameter inside the sql query. The parameter is created to be used in power bi with M query. For example, I can replace a date value with the parameter in the advanced editor. 

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

haider378's avatar
haider378
Regular Visitor
4 years ago

Thanks for your response,

What I understand it is not possible to change Query using parameter

  • Eric_Cunha_2022's avatar
    Eric_Cunha_2022
    New Member
    4 years ago

    I use DateTime parameters in SQL queries in Power Query for data from the Data Warehouse.
    I don't know how to use M parameters in SQL queries of SAP Hana yet, but it's possible.