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 several tabs.

 

2 of these tabs in Report B would also for information purpose fit in Report A.

But both reports have totally different data sources.

 

Is there a way to show these 2 tabs of Report B in Report A?

(maybe a dashboard in report A that links to Report B, I don't know)

Need Help

23 Replies

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

    Hi rpinxt ,
    2 suggestions:
    1. If your data is not sensitive, you can embed your Report B's 2 tabs into Report A using HTML Content visualization. You can get the embed code from below:

     

    2. Create a copy of Report B (say Report B.1) with only those 2 tabs. Provide navigation to Report B.1 from Report A using a button. Not exactly what you want but user will be able to see related tabs with just a click.

     

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn

      

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

      Thanks Anand24 for your suggestions.

      Understand option 2.

      But interested about option 1, just do no understand how that would work.

       

      So I have report A open and choose "embed report", but what to choose then to link the 2 tabs of Report B in?

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

      Well tried with a html visual but things are not working:

      Made a table with a field containing the iframe and use that in the visual.

      But it needs signing in and when I press it nothing happens.

      Also when published to the service that visual remains the same and cannot be signed in.

       

      Do you know what is going wrong?

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

        rpinxt ,
        You'll have to use the "Website or Portal" embed link. It won't ask for permissions but it does have some drawbacks.
        You can google "Power BI Publish to Web link drawbacks". This particular option was known as Publish to web earlier.

         

        Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

        Proud To Be a Super User !!!
        LinkedIn
         

        Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

        Proud To Be a Super User !!!
        LinkedIn
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rpinxt ,

     

    To do this, you would first need to publish both Report A and Report B to the Power BI service. Then, you can create a new dashboard in Report A and add two web content tiles to the dashboard. In each web content tile, you would enter the URL for the two tabs from Report B.

     

    Alternatively, you could use the new app navigation feature to customize the navigation for your app users and link to other content that is related to your app but not in the app itself. For example, you can link to tabs from Report B in your Report A app.

     

    Refer: Designing custom navigation for Power BI apps is now available | Microsoft Power BI Blog

    Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

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

    Thanks Anonymous this sounds likes it would work for me but could you explain a bit more how to do it?

    - Create a new dashboard in Report A

    - Add web content tiles to the dashboard

     

    How do I create a dashboard IN Report A?

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

    lbendlin could you let me know how this would work?

     

    "In a workspace you can create a new report that doesn't have its own dataset. Instead it borrows pages from existing reports and their dataset."

     

    Or have a link where this process is described?
    I never made a report in a workspace. I always make it in desktop and publish it to the workspace.

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

      rpinxt ,
      From desktop, you can go to Get Data -> Power BI Datasets and then select the appropriate dataset which is already published.

       

      Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

      Proud To Be a Super User !!!
      LinkedIn
      • rpinxt's avatar
        rpinxt
        Icon for Solution Sage rankSolution Sage
        2 years ago

        Thanks Anand24 but lbendlin was mentioning a way where you in Services ("In a workspace") make a report that does not use a Dataset but you borrow pages from already published reports.

         

        So I do not understand why you mention Desktop and get data.

        I want to show visuals from different datasets in one workbook without making 1 mega workbook with 2 datasets in it.