Hello,
From what I understand, the App-Owns-Data Starter Kit has a pbix template that uses the report to display in the different scopes that are created. My question is how can I change that pbix? Can I put several since in my case I have more than one report?
As it seems, take the following code to do it:
public PowerBiTenant OnboardNewTenant(PowerBiTenant tenant) {
PowerBIClient pbiClient = this.GetPowerBiClient();
// create new app workspace
GroupCreationRequest request = new GroupCreationRequest(tenant.Name);
Group workspace = pbiClient.Groups.CreateGroup(request);
tenant.WorkspaceId = workspace.Id.ToString();
tenant.WorkspaceUrl = "https://app.powerbi.com/groups/" + workspace.Id.ToString() + "/";
// add user as new workspace admin to make demoing easier
string adminUser = Configuration["DemoSettings:AdminUser"];
if (!string.IsNullOrEmpty(adminUser)) {
pbiClient.Groups.AddGroupUser(workspace.Id, new GroupUser {
EmailAddress = adminUser,
GroupUserAccessRight = "Admin"
});
}
// upload sample PBIX file #1
string pbixPath = this.Env.WebRootPath + @"/PBIX/SalesReportTemplate.pbix";
string importName = "Sales";
PublishPBIX(pbiClient, workspace.Id, pbixPath, importName);
Dataset dataset = GetDataset(pbiClient, workspace.Id, importName);
UpdateMashupParametersRequest req =
new UpdateMashupParametersRequest(new List<UpdateMashupParameterDetails>() {
new UpdateMashupParameterDetails { Name = "DatabaseServer", NewValue = tenant.DatabaseServer },
new UpdateMashupParameterDetails { Name = "DatabaseName", NewValue = tenant.DatabaseName }
});
pbiClient.Datasets.UpdateParametersInGroup(workspace.Id, dataset.Id, req);
PatchSqlDatasourceCredentials(pbiClient, workspace.Id, dataset.Id, tenant.DatabaseUserName, tenant.DatabaseUserPassword);
pbiClient.Datasets.RefreshDatasetInGroup(workspace.Id, dataset.Id);
return tenant;
}
The issue is that in my pbix I access the data through a data source that I have in powerbi, if I simply change the pbix it gives an error because it tries to connect to a database that does not exist.
Do you know how I can proceed to change a pbix/add more to this code?
Thanks.
