Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |