Skip to main content
Microsoft Idea

Power BI

Needs Votes

Input Parmeters for HANA

Vote (160) Share
's profile image

on 31 Aug 2016 05:35:42

Allow users of the Power BI Service to pass value to HANA Input Parameters. Currently Power BI desktop support HANA input Parameters. Once the model is publish into the service the HANA input Parameter cannot be changed. HANA Input Parameters are needed for Restricted calculated columns. Users need the ability to change the values in the Service at direct refresh to HANA

Comments (19)
's profile image Profile Picture

Sourav Paul on 10 Jul 2020 17:22:28

RE: Input Parmeters for HANA

Its a one of the important functionality and Power BI should make this option available to change input parameter values at run time from Power BI.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:18

RE: Input Parmeters for HANA

Must have indeed!

's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:02:26

RE: Input Parmeters for HANA

This feature would not only be highly appreciated but it is certainly a must when it comes to capitalising the advantages of Direct Query connection for HANA.

The use of input parameters to push down filters towards the bottom projections of a Calculation View is part of SAP best practices to improve performance. This cannot be fully leveraged unless parameters can be adjusted by the end-user during the report execution.

's profile image Profile Picture

Gustav on 05 Jul 2020 23:51:52

RE: Input Parmeters for HANA

Need this!

's profile image Profile Picture

Sundar Viswanathan on 05 Jul 2020 23:42:32

RE: Input Parmeters for HANA

This is the key feature missing for a long time. It is preventing the adoption of PBI reports at larger scale. The direct query to Hana is preferred to apply the user access and limit the data transfer by passing the user selections back to Hana to truely benefit both performance and UI. Awaiting for the good news.

's profile image Profile Picture

Vijay on 05 Jul 2020 23:42:31

RE: Input Parmeters for HANA

This is very useful feature, otherwise in HANA view we have to do somany joins and calculations.

's profile image Profile Picture

Rien Scheerlinck on 05 Jul 2020 23:36:10

RE: Input Parmeters for HANA

I hereby confirm: all previous comments should be taken into account. The current implementation is a showstopper for reports based on HANA. The input parameter has to act as a real prompt when refreshing the dataset.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:24

RE: Input Parmeters for HANA

This is an absolute requirement when working with Hana Calculation views. It stops having to pull large amounts of data over the network to Power BI.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:33:21

RE: Input Parmeters for HANA

I'm surprised this has been posted for more than 2 years, this important feature is still missing,

's profile image Profile Picture

Ricardo Pedro on 05 Jul 2020 23:24:12

RE: Input Parmeters for HANA

In our Organization we have several projects Connect to Sap Hana this feature is crucial to our Projects.