Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
7 years ago

Can PowerBI pull from different SAP-BW cubes?

Do We need to do any changes so that PowerBi can pull from mutiple different SAP-BW Cubes?

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support

    hi, Anmolgan 

    You could pull from a single cube in order to build out a report. It seems that you need to reconnect it.

     

    Best Regards,

    Lin

    • Anmolgan's avatar
      Anmolgan
      Icon for Post Prodigy rankPost Prodigy

      But then I need to build out relationships after reconnecting again from another cube right? and if there is no direct relationship present would it help to build out a single cube with all other cubes and build the report from that cube? Also can you tell me how direct query works in this case? as I know I cannot fetch data from multiple cubes when using direct query unless I reconnect again, and whenver if I try to pull characterstics into the table the visualisation just break, it works fine for 1 characterstics but not for multiple ones.