topic Recreate report dataset when using import api in Developer

Recreate report dataset when using import api

repl-satyveer-s — Fri, 03 Aug 2018 20:00:50 GMT

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.

Re: Recreate report dataset when using import api

v-jiascu-msft — Mon, 06 Aug 2018 12:34:24 GMT

Hi repl-satyveer-s,

Can you share a snapshot of your issue, please? It works perfectly on my test.

Best Regards,

Dale

Re: Recreate report dataset when using import api

repl-satyveer-s — Wed, 08 Aug 2018 20:09:07 GMT

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.