Data sources shared between workspaces?

[PeterPetkov]

Hi,

I'm researching how to integrate power bi in my company's products. So far, the selected approach is using power bi embedded, service principal, azure capacity, and multy-tenancy using workspace-based isolation. 

The report i'm using for tests, have a web api data source with basic authentication. The problem i've noticed is that when i upload the report to two workspaces, instead of getting separate data sources, they points to single data source in the default gataway.

workspace1 -> test report -> dataset1 -> datasource 1

workspace2 -> test report -> dataset2 -> datasource 1

As result i can't set the corresponding datasource credentials for each workspace.

Technical details:

I'm using C# Microsoft.PowerBI.Api, single user with admin access to both workspaces. 

Reports are uploaded through Imports.PostImportWithFileAsync(), then i use Gateways.UpdateDatasourceAsync() to update credentials

I'm i missing a setting somewhere, or i'm on a wrong path at all?

[petrVolfMBI]

Hi @PeterPetkov,

do you have any progress on this? I am currently facing the same issue.

[PeterPetkov]

Yes.
After report is uploaded, i'm creating a new datasource using
UpdateDatasourceConnectionRequest and UpdateDatasourcesRequest classes and calling

client.Datasets.UpdateDatasourcesInGroupAsync(workspaceId, datasetId, updateDatasourceRequest);