Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Am using PowerBI rest api - Import operation (PostImportWithFileInGropup) to create duplicates of a report for various users in a workspace.
While using the API I would like to recreate the backing dataset for the report and not share it among the multiple reports thus created. Is there a api option that will enable that.
To illustrate,
sample_report.pbix was imported multiple times using PostImportWithFileInGropup with following args.
run1 - datasetdisplayname=sample_report_user1
run2 - datasetdisplayname=sample_report_user2
run3 - datasetdisplayname=sample_report_user3
Observed:
New reports were created with the supplied 'datasetdisplayname' param but the backing dataset was not created. All 3 share 'sample_report_user1' named dataset.
thanks.
Hi @repl-satyveer-s,
Can you share a snapshot of your issue, please? It works perfectly on my test.
Best Regards,
Dale
Hi,
So am doing the following (using Microsoft.PowerBI.Api ver 2.0.12)
var filePath = @"C:\Pta_Charts_import.pbix";
using (var fileStream = File.OpenRead(filePath.Trim('"')))
{
using (var client = new PowerBIClient(ApiUrl.Value.ToUri(), tokenCredentials))
{
var groupId = GroupId.Value;
client.HttpClient.DefaultRequestHeaders.Add("ActivityId", Guid.NewGuid().ToString());
var import = client.Imports.PostImportWithFileInGroup(groupId, fileStream, "Pta_import_report");
}
}
So I execute this multiple times with different input for datasetDisplyaName (shown in bold). Reports are getting created but the datasets is created only once.
Pta_import_report1, Pta_import_report2, etc get created and use "Pta_import_report1" as the backing dataset.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |