Paginated reports using SAP BW 4/HANA data source

[Anonymous]

Hi all,

I'm trying to do a research on Paginated reports using SAP BW app server/SAP Hana calculation views as datasources. There are Power BI connectors for connection to SAP BW, BPC, BW4/HANA (cubes/queries) & HANA (calculation views). 

Despite its many limitations on functionality, these data sources can only be used with Power BI Desktop for creating dashboards and analytical reports (am I right?). 

There aren't any SAP data sources in a list of supported data sources for Power BI paginated reports (https://docs.microsoft.com/en-us/power-bi/paginated-reports-data-sources)

I have many doubts that Power BI can replace SAP front end tools for reporting (WebI, Analysis for Office, BEx). Could you share your experiences using Power BI on SAP datasource for creating well-formatted, standard reports?

[v-xuding-msft]

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. More people will benefit from here. Thanks in advance.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You are right. For now, you need to connect the data sources into Power BI Desktop. It is not supported for Paginated reports.

I don't have the well-formatted, standard reports with SAP. Here are some videos that you can reference.  

https://www.youtube.com/watch?v=y3se-VEDvqU

https://www.youtube.com/watch?v=hcS43uPVu2o

And there are some documents that maybe you need.

https://docs.microsoft.com/en-us/search/?search=SAP&scope=Power-BI 

Hope these can help you.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.