Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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

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 - 1Accessing a report that has mandatory parameters - 2Accessing a report that has mandatory parameters - 2Accessing a report that has mandatory parameters - 2Accessing a report that has mandatory parameters - 2

2 REPLIES 2
v-caliao-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

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

 

 

Anonymous
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.