Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

SAP BW parameter issue while trying to Access SAP BW report

Dear Senior Community Members,         I have established a connection between power BI & SAP BW. I am able to see all the cubes & under them their corresponding reports too. Problem is that i am n...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Sokon,

 

    I am on official travel these days. Therefore, didn't get time to check the april update as of yet. I will try to replicate the issue again  at my end & will update you in some time. Further, please check out below things in the meantime.

 

1) are you able to connect to cubes & diff reports in SAP BW separately??  Means, first Try to connect to a cube separately & if you are successful in doing so then try to connect to reports without any mandatory parameters.

 

2) Watch the video on you tube on variable parameter usage in power BI. Try to relate that with your problem.

 

   Write me back the result of above two points. Njoy dashborading.

Regards,

Hemant

Hemant

Sokon's avatar
Sokon
Icon for Advocate V rankAdvocate V
9 years ago

Hi Hemant and thanks for your answer,

 

I can connect do SAP BW, no problem. I even get data, like, all data from any query that doesn't have mandatory parameters. I can connect to cubes, too (I don't need paramters there, do I?) But I have to use mandatory parameters and want to use option parameters of the query because sometimes you are not allowed to change the source and want to re-use an existing one.

 

I already know about (report) parameters, as you can learn from the videos. I couldn't find a video about entering parameters for SAP queries.

 

I startetd another post on this: 

https://community.powerbi.com/t5/Desktop/SAP-BW-connector-parameter-input-How/td-p/160489

It explains the problem with screenshots.