Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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,...
Need Help
TomMartens's avatar
TomMartens
Super User
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Here you go...

     

    Parameters in DEV;

    Lineage in DEV:

     

    Parameters in PROD:

     

    Lineage in PROD:

     

    Changing Data Source Credentials:

    thanks

     

    Bruce

     

    • TomMartens's avatar
      TomMartens
      Super User
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        The DEV report is pointing to the DEV database and the PROD report is pointing to the PROD database., this part works fine as you can see from the lineage. The problem is they both are using the same credentials.  Luckliy I have an admin account that has access to both databases as a workaround, but I want to use the accounts that were created for this purpose.  The dev account has read access to dev, and the prod one has read access to prod.