Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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).