Reports with same datasource in different workspaces, with different data credentials

[Anonymous]

Hi!

I'm facing an issue which I can't figure out why is happening.
We have a report template and it is being published to different Workspaces with different datasource credentials, but the datasource is always the same. We are talking about Odata feed, the data separation is done with the credentials on the datasource.
Once the reports are published, credentials entered in the service and the scheduled refresh is set, after the Report1 first time refreshes, the Report2 credentials get overwritten somehow and it gets the Report1 data.

Steps to reproduce:

1. Publish a report with one datasource credentials to MyWorkspace
2. Publish the same report with he same datasource but with different credentials to XXXX workspace
3. Re-enter the credentials online for the first report and setup a Scheduled refresh
4. Re-enter the credentials online for the second report and setup a Scheduled refresh half an hour later then the first one
5. Wait for the refreshes to happen and check the reports, they are showing the same data as the first report shows.

The lineage view shows the reports are connecting to their own dataset.

Any suggestions are more than welcome!




 

[lbendlin]

Needs more details. Is a gateway involved?

[Anonymous]

Hi!
No, for Odata feed there is no need for a gateway this is why we use this solution.