Forum Discussion
Advocate IIData source change in service
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
Hi Yoga,
AFAK. you can't direct modify your datasource in power bi service.
>>1. How can I point DB connection of the PBIX file to respective DB in its app work spaces? Means, In Test app workspace, reports should get generated from Test DB data. In Stage app workspace, it should ahow stage data and same for Production.
For your situation, you can change connection string before publish, then choose the specific workspace to store the reports with match datasource.
Steps: (prerequisite: all datasource has similar table structure and relationship)
1. Create report on current device.
2. Install the gateway and make sure it can connect to actual data source and sign in your power bi account.
3. Change datasource connection string to actual datasoruce string before publish to power bi service. (after this operation, current report will not available)
4. Add actual data source to current gateway.
5. Use gateway which contains above datasource to manage the report refresh.
>>2. Is this the right way to stage my PBIX file (creating different app workspaces (Test, Stage and Production) and connect to respective database in that worspaces? Or please suggest professional standard to follow for deployment.
Actually, after finish publish reports, you can't modify datasets of published reports.(you can only edit the authorization certificate)
Regards,
Xiaoxin Sheng
YogaThanks 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
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
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