Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SAP BW load data with directquery

hi @all:smileyhappy: 

I am new to Power BI and the community and have a question:smileyvery-happy:

 

I want to use the SAP BW connector to import data from a cube into PowerBI.
I've tried the two known ways.
Using "Import" I can explicitly select the relevant InfoObjects and their attributes for the cube.
-> example InfoObject "Person" -> "Person.Level01" -> "Properties" ("first name", "last name", "displayname", "e-mail", etc.)
DirectQuery" displays all infoobjects as fields in Power BI. However, almost all attributes are missing in this cube.
-> example: infoobject "Person" -> "Person.Level01" -> "Person.Level01.UniqueName".
The attributes first name, surname, e-mail etc. are missing here.
I have this problem for all of the infoobjects in the cube. (only "uniquename" everywhere)

 

Can someone tell me what caused it and how to fix it?

 

I could also always use the "import" method, but in Power BI / SAP BW a short dump occurs when loading: "No memory for extension of an internal table available".
For "directquery" it comes only to the limitation message for 1 million data records without a dump.

 

Thanks in advance.

browniejosh

Need Help

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi  Anonymous ,

     

    The updated version of the SAP BW connector was developed by Microsoft and is called Implementation 2.0. You can select either version 1 (v1) of the SAP BW Connector, or the Implementation 2.0 SAP Connector. The following sections describe the installation of each version, in turn. You can choose one or the other connector when connecting to SAP BW from Power BI Desktop. We suggest you use the Implementation 2.0 SAP Connector whenever possible. See more detail :

    https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector .

     

    Or please check the version of Power BI Desktop on your side, and the try it again after updating to the latest version 2.70.5494.761 .

     

    Best Regards,

    Amy

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      hi v-xicai 

       

      thanks for your answer. We have the newest version of power bi and are using Implementation 2.0.

       

      The problem is, that when using "DirectQuery" I can see only one attribute of the cube.

      When using "Import" I can see all available attributes of the cube and I don't know why. (example in first posting)

       

      I could do it with "Import" but it's not a good idea to import the whole data because of its amount. 

       

      Can anybody help me?