Forum Discussion
Switch Databse to live server
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
2 Replies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi 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-editor/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.
