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

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