Forum Discussion

murali5431's avatar
murali5431
Icon for Helper III rankHelper III
5 years ago

Combining two power BI reports

Hi,

 

I have created two power BI reports using same datasource. The calculations and purpose are different in each of them.

As they are from the same datasource, is it possible to combine them into one Power BI file, as separate tabs?

 

Thanks in advance for the help!

Muralidhar

Merge files

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    murali5431  

    Copy & paste between Power BI Desktop files

    you have the ability to copy visuals between .pbix files. you can copy a visual either through the visual’s context menu or through the standard Ctrl+C keyboard shortcut and paste it into another report through Ctrl+V.

    If the fields in your model are different, you’ll see an error on the visual and a warning on the fields that don’t exist, similar to the experience you see if you delete a field in the model a visual is using. All you’ll need to do is replace the broken fields with the ones you want to use from the new model. If you are using a custom visual, you’ll also need to import it to the destination file as well.

     

     

     

    Give me Kudos If you find it suitable .

    Thank you 

     



    • murali5431's avatar
      murali5431
      Icon for Helper III rankHelper III
      5 years ago

      Hi Anonymous ,

       

      Thanks for your response! I will give it a try.

       

      But only the soure data is same. The columns used from the data source and calculations are different. So not sure how much modifications I might have to do.

       

      Regards,

      Muralidhar

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        murali5431  It will be very easy for you to copy viz from one and paste it from other

        Or 
        Even ,You can duplicate the page 1 and copy and dax measure and drag your newly created dax Measured (Copied from Report2) duplicate page  .Bingo Your Viz is ready but you need to make sure your data model is correct .

        rest thing PBI will automaticly take care .

        Enjoy 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    murali5431 , If you have the same data model and formula (calculated column and measure) with the same name are available.

     

    You can copy-paste visual from one pbix to another pbix.

     

    You can select more than one and do the same .

    • murali5431's avatar
      murali5431
      Icon for Helper III rankHelper III
      5 years ago

      Hi amitchandak 

       

      Only the soure data is same. The columns used from the data source and calculations are different. Keeping the datasource common, is there any option to combine them?

       

      Thanks for your help!

       

      Regards,

      Muralidhar