Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi hemantsingh,

 

Have you tried to select other cubes data to check this out?

In addition, make sure you have specified a Server, System Number and Client ID to establish the connection.

Currently I am not available to test this, suggestions here is:

  1. Enable tracing under Power BI desktop;
  2. Check the troubleshooting part under the following page: Use the SAP BW Connector in Power BI Desktop.

If available, upload the trace logs into OneDrive and we will help to take a look.

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi v-micsh-msft,

     

        My sincere thanks for taking out time to look into the issue & helping me in moving forward. Further, as told by you I have already specified Server,System Number and Client ID to establish the connection with PBI. 

     

    FYI, I read saagarkinja feedback on the same issue under different question. I would like to thank him for mailing me the necessary library files that were required to be placed in windows system 32 folder for making a successful connection. He also clarified that PBI doesn't work well with Bex reports instead i should try to browse infocubes. I did the same & everything is working fine.

     

        Further, v-micsh-msft saagarkinja Is there a way to restrict the no. of rows to load in PBI model from a SAP BW cube. Somewhat like loading data from SQL server by writing queries. Moreover, I would like to control the data to be load into the PB model. As of now if a specific SAP BW Cube contains data from year 2009 than PBI tries to load all the data which makes it very slow as the total no. of rows amounts to billions. 

     

      Any guesses??

     

    Regards,

    Hemant