Show visual from Report A in Report B?

[rpinxt]

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)

[rpinxt]

@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]

@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]

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.

[lbendlin]

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]

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]

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]

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]

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).

[rpinxt]

Yes first thing I thought about was also pulling in the dataset of Report B into A.

But then I have maintenance in 2 places because dataset of Report B is not fully automatic.

Also it rather big so for 2 report pages of Report B in Report A I would triplle the size of Report A.

That is not really efficient.

Guess for now the best solution is to make a power point for the end user.

Link all pages of Report A in and 2 from Report B.

Was hoping something similar could be done with embeding in the service but unfortunately not.

[Anand24]

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]

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]

@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

[rpinxt]

Well I used that link I think....?

When you do that you get 2 links :

I used the 2nd one because that one you can put in a html visual.

Will have a look at the google suggestion.

[Anand24]

@rpinxt ,
Yes please do check since Publish to web link will not ask for credentials. 

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]

Well...that option is not there....

This I can choose:

And then you get 2 links.

1 for HTML and 1 with https app link

[lbendlin]

There's another option you may want to consider.  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. So you would create a report C that doesn't have its own dataset but collects pages from reports A and B.

[rpinxt]

Well @lbendlin that sounds interesting.

Our main goal is to give the end user info from both reports without him/her looking thru several reports (because datasets are different).

So making a "collection" report sounds like a possible way to go.

How would that work? Take it that it can only be done from services.

And will it be interactive like the original reports?

[rpinxt]

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]

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?

[Anonymous]

Hi @rpinxt ,

Refer :

Create a Power BI dashboard from a report - Power BI | Microsoft Learn

How to include web content (from an url) into a Power Bi Dashboard - andres gaviria - Medium

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.