Skip to main content

Power BI

Needs Votes

Input Parmeters for HANA

Vote (157) 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

5248df48 7b80-40ea-b152-f4919c69288b 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

8c547f65 4479-4445-99a5-b700e7c0ad54 on 06 Jul 2020 00:13:18

RE: Input Parmeters for HANA

Must have indeed!

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 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

329febeb aad9-4f32-9547-d0737ab3af27 on 05 Jul 2020 23:51:52

RE: Input Parmeters for HANA

Need this!

's profile image Profile Picture

3cbad2da e8a0-4819-a5ac-c41931316099 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

1be15f26 72dd-4897-aebd-2c54df36850d 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

852765b6 58e9-473d-891c-8055854dc715 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

1032548b 6059-493b-a089-11ad41ecdbf7 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

b3e2650f 1421-4888-8cb5-49e4a7e15277 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

c38c3609 afb3-46ef-8607-4bbfde50921d 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.