Forum Discussion
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
Community 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
Post 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.