cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seemak
Frequent Visitor

Migration From SAP BO to Power BI

Hi everyone, i am about to be involved in the migration from SAP BO to power BI, can anyone guide me on the same, if they have done a similiar project or have any documentaion regarding the same.

 

1 ACCEPTED SOLUTION

Hi @seemak,

In my opinion, I think connecting the database and design report by power bi should be simple than migrating to these databases and products.
For this scenario, you can try to use rest API to get data from SAP BO, they did not require additional payment for premium license:

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

SAP BusinessObjects BI Universe Connector Technical Guide

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
v-shex-msft
Community Support
Community Support

Hi @seemak,

What type of migration did you mean? Direct export data to power bi side or fully migration the business and product to power bi? 

For the first one, you only need to find the export data feature or api, then you can export data externally and import these records to the power bi side.
For the second one, they are not simply to do. You need to rebuild these reports and dashboards and fully replace them with MS platforms and products. In my opinion, I'd like to suggest you ask your admin to contact to MS team to create a ticket about business migrations to get further support.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi 

i think there is no direct connector for SAP BO in power bi, what is understand is in BO it's usually too many procs etc are created but you can rationalize them in power bi and create a single overall semantic model, Then the client don't need to pay for BO. then we can build in reports in PBI. 

 

 

Hi @seemak,

In my opinion, I think connecting the database and design report by power bi should be simple than migrating to these databases and products.
For this scenario, you can try to use rest API to get data from SAP BO, they did not require additional payment for premium license:

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

SAP BusinessObjects BI Universe Connector Technical Guide

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you so much for this information.

You cannot expect to be able to move from BO to a free version of Power BI. You will need to use Power BI Premium, and the cost will likely be comparable to BO.  What other reasons do you have for the request?

lbendlin
Super User
Super User

When you say migration - are you expecting to be able to lift and shift the BO universes to Power BI Datasets/Dataflows/Dataverse?  Or are you ok with starting over?  To what extent have you been using the actual reporting capabilities of BOE?  Or were your users only running extracts?  Is the team that designed the universes part of the transition project?  

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors