migrate PBI report with SAP HANA source to repoint to Snowflake DW

[ramkula]

Hi Experts !

We are trying to migrate our PBI reports that have SAP HANA connection (sources) to point  to Snowflake source system. Is there any option to change the connection in the existing report without creating a new report ?

Can you please list down the steps for the same ? I tried Transform data--> change data source .. but this is not working

Thanks !!

[v-saisrao-msft]

Hi @ramkula,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @ramkula,

Have you had a chance to review the solution we shared by @MFelix? If the issue persists, feel free to reply so we can help further

Thank you.

[MFelix]

Hi @ramkula ,

The question is that SAP HANA connection works differently from the Snowflake source so you need to redo the first step on the connection so you get that change correctly.

First check the documentation on each one:

https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/overview

https://learn.microsoft.com/en-us/power-query/connectors/snowflake

I would advise you to do the following:

• Connect to Snowflake for one specific table
• Now go to the advance editor and copy the first line of code
• Then go to the other query were you got the SAP HANA and replace the first step with the one from Snowflake

If you want to make this in a more efficient manner try to use the TMDL editor since you can edit all your queries at once using change and replace.

[ramkula]

Thanks MFelix !! We are able to do this step, however since the naming standards between SAP HANA ( Itemid) & Snowflake (ITEM_IDENTIFIER) is differnt, what is the easiest way to migrate the PBI report without breaking ?

[MFelix · Accepted solution]

Hi @ramkula ,

When you refer to the naming standards do you mean for tables, columns, schemas?

If you refer to the step names that are created when you do a connection to a specific datasource you can simply rename the step to the one you need what matters is the parameter value inside each step not the stepo name.

Can you post a code sample of the difference so I can understand the question a little bit better?

You can replace the sensitive information by any character strings.