Can we change from one database/source to a different database/source in Power BI

[poojithas]

Hi All,

I have created a dashboard based on Excel as a source. Now I would like to change the source to Hadoop tables without redeveloping the report again. Can someone please let me know if this is possible. If yes, what will be the pre requisistes and steps to be taken care of.

Thanks in advance.

Regards,

Poojitha

[selimovd]

Hey @poojithas ,

in Power Query you can just replace the Query that loads from Excel with the Query that loads from Hadoop.

When the result looks the same you can just replace them.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[poojithas]

Hi @selimovd 
Can you please give few more details.

Does it mean then we can go to the edit query and then change the source in the advanced editor? Can we directly change from Excel to Hadoop from this place? 

Thanks

Poojitha

[selimovd · Accepted solution]

Hey @poojithas ,

not, that's not possible.

Go in Power Query, create a new Query and choose Hadoop:

Then you can do your transformation in that query until the result looks exactly like the result from your Excel-Query.

Afterwards go to the advanced editor in the Hadoop-query, copy everything. Then open the advanced editor in the Excel-query and replace that query with the copied one from the hadoop query.

The initial hadoop-query you can delete. After you close and apply the underlying table will refresh and in the report everything will look the same.

Be aware that the result has to look identical. Otherwise, it won't work.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic