Forum Discussion

Yoga's avatar
Yoga
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Data source change in service

Hi there, I have developed a report and data model in Power BI desktop in Development machine using Direct Query option and trying to deploy in Test server for QA testing the PBIX file but connect...
Need Help
  • Yoga's avatar
    Yoga
    8 years ago

    Thanks XIaoxin for reply.

     

    We maintain one TNS Name in all Dev, Test, Stage and Production servers. Since I use the same TNS in PBIX file, We are able to move the files to all servers without any change as expected. So no need to change in power bi services running in different servers.

     

    Thanks,

    Yoga

Yoga's avatar
Yoga
Icon for Advocate II rankAdvocate II
8 years ago

Thanks For the reply Xiaoxin.

 

Once connection information is set (which is Development connection), I need to check in the file and hand over to Deployment team. So I am unable to change the connection to Test DB in the PBIX file and publish. Also this will go to Stage and Produntion environments, so I cannot modify my PBIX files for that.

 

Trying solution as below as of now,

1. Have the DNS name same in Dev, Test, Stage and Prod server.

2. PBIX file connects through DB through the Server name (TNS name), but in each workspace different Gateways data set connects to different DBs with same server name. So seems it works. I am still working on it.

 

Ex:

TNSNames.ora in Dev server

TNS_SALE

{

...

server=xxxx

}

 

Gateway installed in this server having server as TNS_SALE 

 

TNSNames.ora in Test server

TNS_SALE

{

...

server=xxxx

}

 

Gateway installed in this server having server as TNS_SALE 

 

Service:

I have Two app worspaces, Dev and Test. Each connects to its respective gateway. Since the PBIX file is having same Server name, it will connect to respective DB.

 

Please suggest will this work, or any other solution?

 

Thanks,

Yoga

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Yoga,

 

It is impossible to change it on power bi service. If you want to change the datasource, you need to modify the pbix file.

 

>>So I am unable to change the connection to Test DB in the PBIX file and publish.

You can try ask other users who has modify permission to download pbix file from power bi service, then update the datasource connection string, publish to replace the current file.

 

Regards,

XIaoxin Sheng

  • Yoga's avatar
    Yoga
    Icon for Advocate II rankAdvocate II
    8 years ago

    Thanks XIaoxin for reply.

     

    We maintain one TNS Name in all Dev, Test, Stage and Production servers. Since I use the same TNS in PBIX file, We are able to move the files to all servers without any change as expected. So no need to change in power bi services running in different servers.

     

    Thanks,

    Yoga