Forum Discussion

saagarkinja's avatar
saagarkinja
Advocate II
10 years ago

SAP BW connectivity issue

Dear All,   I am trying to integrate and fetch data from SAP BW using Power BI SAP BW direct connector.   However,after some time it pops up below error message, ------------- DataSource.Error:...
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Can you clarify if you are in the Desktop or Service? I am assuming Desktop and are you using the SAP Hana Database connector, I do not see the specific one for SAP Business Warehouse. I guess, how are you connecting to it?

  • saagarkinja's avatar
    saagarkinja
    Advocate II
    10 years ago

    Hi Smoupre,

    Thanks for your kind revert.

     

    I am using Power BI SAP BW Direct connector (Preview) in Power BI Desktop. I am connected to domain and able to communicate with SAP BW server.

    Post selecting desired measures and dimensions ( I selected 2 measures and 4 dimensions), is starts "Loading into Data Model".

    After some time, it returns this error mentioned.

     

    Please let me know, if any specifics required.

     

  • tristanstcyr's avatar
    tristanstcyr
    Helper I
    10 years ago

    We have a BW connector in preview.

     

    What does your query look like?

    • saagarkinja's avatar
      saagarkinja
      Advocate II
      10 years ago

      HI Tristan, 

      Thanks for your kind revert.

       

      Yes I am using Power Bi SAP BW direct connector (Preview). I am able to connect and select dimensions and measures.

       

      Please note, I am not using MDX ( I wrote multple MDX referring their Info Cubes but not working). I am selecting it manually.

       

      In advance editor page, it is very simple,

       

      ------------------

      let
          Source = SapBusinessWarehouse.Cubes("----------", "----", "---"),
          #"$INFOCUBE" = Source{[Name="$INFOCUBE"]}[Data],
          #"$---------" = #"$-----------"{[Id="$------------"]}[Data],
          #"Added Items" = Cube.Transform(#"$-------", {{Cube.AddAndExpandDimensionColumn, "[----]", {"[---].[---]"}, {"--------------------------------------"}}, {Cube.AddAndExpandDimensionColumn, "[----------]", {"[--------].[LEVEL01]"}, {"--------"}}, {Cube.AddAndExpandDimensionColumn, "[---------]", {"[--------].[LEVEL01]"}, {"---------------------"}}, {Cube.AddAndExpandDimensionColumn, "[---------]", {"[------------].[---------]"}, {"------------"}}, {Cube.AddMeasureColumn, "-------------------", "[Measures].[------------]"}, {Cube.AddMeasureColumn, "------", "[Measures].[-------]"}})
      in
          #"Added Items"

      ----------------------------------------------

       

      Please let me know, if any specific details required.