Forum Discussion

repl-satyveer-s's avatar
repl-satyveer-s
Regular Visitor
8 years ago

Recreate report dataset when using import api

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.

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi repl-satyveer-s,

     

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

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Dale

    • repl-satyveer-s's avatar
      repl-satyveer-s
      Regular Visitor
      8 years ago

      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.