Is it possible to migrate existing power BI reports to use SAP HANA source instead of SQL server

[ramyakumar12]

We have Power BI reports which are built on Sql Server data source . However we are currenlty migrating from SQL Server to SAP HANA system . How can the Power BI reports be switched from SQL to SAP HANA ?

[Anonymous · Accepted solution]

@ramyakumar12  - 

I don't know if there are any migration tools, but I would try some tables out in Power Query.

In short, the amount of work will depend on how similar the data is between the SQL Server and SAP. This will require some tinkering in the Advanced Editor - M scripting.

If the structure of a table is identical in the sources, you could swap out the first step and the rest would just work.

Otherwise, add a new source for SAP and transform it to a point where it is identical to some step of the SQL Server query. Then, when you're ready, you can replace all of the SQL Server steps up to that point with the steps from SAP.

Hope this helps,

Nathan