Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cloned Report Doesn't Copy Custom Columns

I have a Power BI Report which acts as a template report. In this report I created a custom column. I clone this report using powerbi api then update data in it, this way there are multiple reports cloned from this template report which contain different data.

 

When I open the cloned report I get this error in the chart where custom column is used, all else works fine.

 

 

This error message is pointing to the custom column. When I edit this new cloned report I found the issue which is the new created column which appears and acts just fine in template report, does not appear in the copied/cloned report at all.

 

The custom column is missing in dataset.

 

Are custom columns not copied to the reports which are cloned using Power BI API? If they are copied then what am I missing?

 

Note: In template report this newly created column information appears in the edit queries section. As mentioned it works fine here. 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    when you say template report do you mean a report (.pbix) file that you keep as a sort of master file, or do you mean an actual template (.pbit) ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes the template report I am mentioning is a .pbix file that I created as a report in PBI Desktop Application. Published it to a workspace in PBI Portal, then using PBI API I cloned it in another workspace. All reports mentioned have .pbix extension.

       

      Though I am unable to download the cloned report from portal as it says something like, 'only reports created by PBI Desktop can be downloaded'.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi  Anonymous ,

     

    Have you created this custom column in Service?As this error is showing that there was a change to the underlying dataset, which is causing problems.Pls add this custom column in desktop then repulish it to Service to see whether the error still exists?

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      All changes I made, they were in Desktop app, the only thing that is different from desktop app is. Data I am feeding in Master Report (Desktop App) is from excel file, while the one in Service is created by Power BI API and data is being fed using addRows(don't recall exact name) API which uses JSON format.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ，

         

        Just now,I tried to reproduce your senario,I get data from Excel,create a custom column,then publish to service.

        When the report exists in Service,I cloned it to another workspace by Rest Api,and all the columns appear,everything works fine,see below:

        So would you pls check whether there's anything wrong during the clone.

        Here is API link,you can copy report via this link:

        https://docs.microsoft.com/en-us/rest/api/power-bi/reports/clonereport

        Then fill in the json code as needed:

         

        If your issue still occurs,pls create  a support ticket via below link and our relevant personnel will help to handle it.
        https://powerbi.microsoft.com/en-us/support/
         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!