SAP Hana Data Ingestion

Hi lotus22 

You can add a query parameter in Power Query Editor to filter the rows and change its value later after publishing to the service. 

Query Parameters | Microsoft Docs

Edit parameter settings in the Power BI service - Power BI | Microsoft Docs

You can also consider creating a dataflow to query and transform data first. This is like Power Query Online version and stores data in the service. Then you can connect to the dataflow to get data and create reports in Power BI Desktop. 

Configure and consume a dataflow - Power BI | Microsoft Docs

Other reference for query parameter:

Power BI Desktop Query Parameters, Part 1 (biinsight.com)

Hope this helps.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.