question

ApeJei-6437 avatar image
0 Votes"
ApeJei-6437 asked JessicaJ-6071 edited

Link to open report power BI from ssrs

Hi all guys, I realized a report with report builder. On this report I have a textbox with a URL. I would like open the link in a new page of browser. The link is to achive another report realized on power BI with filters.

In the "action" "go to the url" I have written ="javascript:void(window.open('https://app.powerbi.com/groups/me/reports/ReportSection4c6f39280b57223d8705?filter=ORDERS/ORDER_ID eq '" + Fields!AU.Value + "'"', '_blank'))" In this case if I click on it doesn't run.

I tried also with html tag in the value: ="<a href='https://app.powerbi.com/groups/me/reports/ReportSection4c6f39280b57223d8705?filter=ORDERS%2ORDER_ID%20eq%20%27000009631601%27' target='_blank'>" & Fields!AU.Value & "</a>" but the report is opening on the same page.

How is possible to open in a new page of browser the link? I have a lot of others link that run very well but to achive power bi report I have to use right mouse button and open in a new TAB/WINDOW.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @ApeJei-6437 ,
I am not familiar with Power BI. You could get help in the Power BI forum: https://community.powerbi.com/
Best Regards,
Joy

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ApeJei-6437 avatar image
0 Votes"
ApeJei-6437 answered

Ok thanks but the problem is in report builder whit expression "javascript:void(window.open( etc.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JessicaJ-6071 avatar image
0 Votes"
JessicaJ-6071 answered JessicaJ-6071 edited

Double check your double and single quotes. I'm not sure if you need the _blank part in the js link to open in a new window -- mine doesn't seem to, however, it could be that my links usually reroute anyways. I think the following should work, but, it's difficult for me to tell without actually being able to replicate the link/reporting situation.
="javascript:void(window.open('https://app.powerbi.com/groups/me/reports/ReportSection4c6f39280b57223d8705?filter=ORDERS/ORDER_ID eq '" & Fields!AU.Value & "','_blank'))"

Inspect elements in a browser to ensure that it looks correct in the HTML.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

You may also want to try replacing the slash on the filter with a %2 and spaces with %20. If you're using SQL server as a source, and you're doing this sort of thing often, I recommend trying to build a scalar function to generate these links to reduce future problems -- make the report section and filter variables or something along those lines.

="javascript:void(window.open('https://app.powerbi.com/groups/me/reports/ReportSection4c6f39280b57223d8705?filter=ORDERS%2ORDER_ID%20eq%20'" & Fields!AU.Value & "'))"

0 Votes 0 ·