Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

anshus — Tue, 15 Oct 2024 15:31:53 GMT

My organization, we create dashboards on Power BI Desktop, and then publish to host on Power BI Server. I would like to know if there's a possibility, that output of one dashboard, can be treated as an input to another dashboard?

Example:
Dashboard 1: Creates a list of the clients according to filters used.. User then clicks on a button (or any other way), to open the Dashboard 2
Dashboard 2: Uses the Dashboard1 output as input, and filters the metrics accordingly..

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

lbendlin — Tue, 15 Oct 2024 16:44:35 GMT

Power BI Report Server does not support dashboards. Did you mean to say Report?

Power BI Report Server also doesn't support the notion of a semantic model.

Your second report would need to use the same sources as the first one.

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

anshus — Tue, 15 Oct 2024 19:43:50 GMT

Hi, Thanks for responding. I just went and checked - it is a online "Workspace", and reports are build in power BI desktop application.

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

lbendlin — Tue, 15 Oct 2024 22:53:25 GMT

Then yes, you can connect to to a Power BI Semantic Model from your Power BI Desktop.

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

Anonymous — Wed, 30 Oct 2024 07:32:42 GMT

Hi,lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,anshus .I am glad to help you.

If the effect you want to achieve is for Power BI Service, then your needs can be realized:

Data transfer and interaction between dashboards and reports in Power BI Service.

Since a dashboard can contain multiple reports and the content is not fixed, URL Filters does not support dashboards, but rather reports.
You can put the report URL used in the second dashboard as a button in the first report.
Or you can use the link in the dashboard (you need to make sure that the admin portal is enabled).

Here are my tests:

Operations in power BI Desktop("Creating url buttons in report" function)

Copy the report url of the second dashboard (the report itself, not the dashboard).
After my testing the url filters only work for the report but not for the dashboard, this is something you need to be aware of.

create the jump rul measure (to report2 )

It is important to note that some special symbols such as single quotes and spaces need to be escaped.

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

meausre code:

JumpURL = "https://app.powerbi.com/groups/xxxYourGroupIDxxx/reports/2825de85-adf5-4e84-bd8b-ea0514420a29/eba9e747ea0da7e5db78?filter=datarefreshTest%2Fanimal%20eq%20%27"&[SelectAnimal]&"%27"

You can either add a jump button to the report used by dashboard1 (to select the web URL), or add a web contant to the dashboard

ADD URL button

Select the URLmeasure we just created
[JumpURL]

At this point you can first test on Desktop, when the slicer is selected, the measure passes the value from the slicer to the URLmeasure, which is then loaded by loading it into the button and then clicking the button to realize the jump to report 2

Finally, republish the modified report1 to the service and pin it to the dashboard to realize the url jumping

Please note that url filters only work for reports, not for dashboards.

I hope that the following issue will be of help to you:
URL:
Solved: Salesforce URL to Open and Filter Power BI Report ... - Microsoft Fabric Community
Unfortunately dashboards don't support the use of URL Filters to enable the carrying of filter parameters (passed to another dashboard)
URL:
Solved: apply filters within the dashboard??? - Microsoft Fabric Community
In addition to the measure URL Filters approach I've provided above, you may also want to consider using the cross-report drilling feature.
URL:
Solved: Pass a filter parameter from one PBI dashboard to ... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard? in Report Server

Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?

Re: Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?