Parameter related issue while connecting to SAP BW reports that has mandatory parameter selection

[hemantsingh]

Hi,

    I am able to connect to cubes in a SAP BW and also able to access data in them. There is a list of predefined BW reports that I want to access for further analysis & dashboard creation purpose. Whenever I tried to access a BW report I present with an error that says 

" Parameter.Error: A required cube parameter was not provided ". Please find below the screenshots for the same.

Does anyone know how can I enable/resolve this parameter related issue?

Note: - The report i am trying to access in SAP BW has 3 mandatory parameter selection in SAP BW bex query designer. In other words, if I need to access the report in SAP BW than I need to pass 3 parameters in bex query designer along with other optional parameters to access/view the report.

Awaiting some fruitful inputs.

RegardAccessing a report that has mandatory parameters - 1Accessing a report that has mandatory parameters - 2Accessing a report that has mandatory parameters - 2

[v-caliao-msft]

Hi @hemantsingh,

Here is a blog which describes how to use parameter in query, please check if it helps or not.
http://biinsight.com/power-bi-desktop-query-parameters-part-1/

Regards,

Charlie Liao

[hemantsingh]

Hi @v-caliao-msft,

   My sincere thanks to you for reverting & helping me in resolving the mentioned issue. Further, I have read the article you shared & will share with you the result whether the solution discussed in article resolved the issue or not.

Regards,

Hemant