Data sources shared between workspaces?

PeterPetkov — Tue, 23 Jul 2019 12:20:35 GMT

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?

Re: Data sources shared between workspaces?

petrVolfMBI — Fri, 27 Jan 2023 10:18:08 GMT

Hi @PeterPetkov,

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

Re: Data sources shared between workspaces?

PeterPetkov — Fri, 27 Jan 2023 11:49:33 GMT

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

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

topic Data sources shared between workspaces? in Developer

Data sources shared between workspaces?

Re: Data sources shared between workspaces?

Re: Data sources shared between workspaces?