Connecting two separate databases to the desktop version and on serever

[Anonymous]

Hi,

I need to connect to the Developer database in my desktop verison and after publishing i need to connect to the dashboard to the live data base.Is there a way to do this.Normal practice is we connect to the same data base in desktop version and in server.But i need to use two databases in the server and the desktop version.

Can someone help me on this?

Thank You

Have a good Day

[nandukrishnavs]

@Anonymous  -
create a parameter for holding the source address and use that parameter in the advanced editor.

So that after publishing it into service, you can change the parameter value.

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Anonymous]

Hi,

Thanks for the reply.Its really useful to get an idea about the scenario.Thanks again