Switch Databse to live server

[pityman]

Hi,

My power bi currently is connected to a local DB.. If i want to switch it to live server (DB structure is the same, local db is backup from live server) does it possible?

Thank you

[v-yangliu-msft]

Hi  @pityman ,

You can change the data source through the advanced editor of Power query:
https://www.inogic.com/blog/2019/11/how-to-modify-power-bi-report-data-source-queries-from-advance-e...

https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @pityman ,

yes, that's possible.

Just change your local DB (localhost) to the production database (mydatabase or if it's on azure mydatabase .database.windows.net).

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