Forum Discussion
Different Data source credentials in each Workspace
I have the same set of reports deployed in 3 different Workspaces; Prod, Test, and Dev.
The datasource is on Azure so there is no Gateway involved. Once deployed I point the reports to the Prod, Test and Dev databases using parameters that I have setup in the report, this works well.
I then go to change the Data source credentials in each Workspace so that they use different user account for each environment database for Prod, Test and Dev. When I do this on one report it changes for all reports in all Workspaces.
Ideally I want different credentials for each environment which i expect should be straightforward, how can I achieve this? am I doing something wrong?
thanks
Bruce
6 Replies
Hey Anonymous ,
what type is your Azure data source, is it Azure SQL or Azure Analysis Services, or something different?
Can you please share some screenshots that show, where and how change the parameter values, making the reports point to the different databases.
Please also share some screenshots that show where and how you change the credentials.
Please share some screenshots that from the data lineage view showing that the reports are "really" pointing to the proper databases after changing the parameters.
All what you want works in deployment pipelines, so it should be working if you do this manually 🙂
Regards,
Tom
Hey Anonymous ,
this looks weird. I will test this on Wednesday, when I have some more time.
So basically what you are saying, is that after changing the parameters of the report instances pointing to the dev and prd instance, and then changing the credentials to make sure that the prd report instance is able to retrieve data from the prd database, both report instances are pointing to the prd database, right?
Regards,
Tom
