Forum Discussion

Gautier's avatar
Gautier
Frequent Visitor
9 years ago
Solved

Connect to Business Object Webi report through RESTful request

Hi,   I have found a workaround to get access to my Webi reports using the SAP Restful API. It works very well with Power BI. Basically the GET request I am sending looks like this:   http://<ba...
  • Gautier's avatar
    Gautier
    9 years ago

    Continuing my previous post:

     

    2 issues arise when I upload to Power BI service and try to refresh through the data gateway:

     

    1) functions are not accepted - fixed easily by adding the logon function within the main query as a subquery

     

    2) the main query credential (anonymous) isn't accepted by Power BI services  - fixed by using relativepath in my webcontent()

     

    Also I have added to my query a first subquery to retrieve the report ID of the latest instance of the report stored in Business Object.

     

    If anyone is interested to see the details I am happy to share my query.

     

     

     

Gautier's avatar
Gautier
Frequent Visitor
9 years ago

Continuing my previous post:

 

2 issues arise when I upload to Power BI service and try to refresh through the data gateway:

 

1) functions are not accepted - fixed easily by adding the logon function within the main query as a subquery

 

2) the main query credential (anonymous) isn't accepted by Power BI services  - fixed by using relativepath in my webcontent()

 

Also I have added to my query a first subquery to retrieve the report ID of the latest instance of the report stored in Business Object.

 

If anyone is interested to see the details I am happy to share my query.

 

 

 

sbo94120's avatar
sbo94120
Frequent Visitor
9 years ago

yep just share the global query it's a interesting feature to explore

regards