Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

Show visual from Report A in Report B?

Think if this is possible it is only possible in services I guess.   So we have a Report (lets call it) A. That report has several tabs, nothing special.   Now we also have Report B, with also s...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

In your workspace select New Report

Pick the dataset

 

 

Auto create or create from scratch.

 

 

Then recreate the visuals or copy/paste them across reports.

 

 

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

Thanks lbendlin !

This looks promising.

However I seem not to be able to copy 1 visual of the original to the new blank report.

I can copy the original vizual but it does not let me paste it in the new blank report.

 

Do you know what I am doing wrong?

 

Also it seems I can only choose 1 dataset.

How would I get visuals from Report B into the newly generated (blank) report?

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

    Another option is to open the original report in the workspace and then save a copy.  After that you can edit the copy and add/remove visuals and pages.

     

     

    • rpinxt's avatar
      rpinxt
      Icon for Solution Sage rankSolution Sage
      2 years ago

      Ok thanks again lbendlin but that is only half of the issue.

      I make a copy of Report A, but I don't need to take things out.

      I need to add visuals that are in Report B and report B is a different dataset than Report A.

       

      So is my conclusion right that you cannot do this with Power BI?

      You cannot show visuals from 2 different reports and datasets in 1 report in the services?

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

        You can do that in Power Bi Desktop.  Connect to different datasets. Join them if you want (but not required). Create visuals based on these datasets.

         

        It doesn't seem possible to do that in the Power BI service just yet.  (You could consider using dashboards but that may not be the UX you want).