Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a Power Bi report which I have included the Power Bi dashboard URL so that when the report is exported to PowerPoint the readers of the PowerPoint can access the Power Bi dashboard and interactive Power BI report if they wish. The issue I am having is that when the report is exported to PowerPoint and the URL is clicked on from PowerPoint it brings up the Power Bi sign in page even if the user is already signed into Power Bi. Upon signing in it brings up the recently viewed items rather than the specific Power Bi dashboard. The URL works fine if it is copied and pasted to the browser or clicked on from the report in the Power Bi service but not when clicked on in the PowerPoint extracted report.
Any ideas why this happens or how to correct?
Solved! Go to Solution.
Hi Amy,
I have gotten responses from the Product Team. They will fix it. The workaround for now is manually updating the url and adding noSignupCheck=1 at the end, so the url would be something like
https://app.powerbi.com/reports/b0feb82a-9bb5-4f9******2f6dbd8edf?pbi_source=PowerPoint&noSignupCheck=1
Best Regards,
Dale
still not working reallly OK - with ? getting 2 pages. another workaround - save as (not print) as PDF from e.g. Word
C'mon MS ... 2 years later and still not fixed ...
Here a little VBA script which will search the current PPT deck for all Hyperlinks from the PBI service and applies the fix.
Usage instructions:
Regards,
Michael
Option Explicit
Sub FixPPTHyperlinks()
' Fix the URL created by PowerBI when exporting to PPT
' More info on PowerBI support forum:
' https://community.powerbi.com/t5/Service/Power-BI-Dashboard-URL-link-defaulting-to-recently-viewed-items/td-p/312689
Dim oSl As Slide
Dim oHl As Hyperlink
Const sPattern As String = "?pbi_source=PowerPoint"
Const sAppend As String = "&noSignupCheck=1"
'Search for PBI Hyperlinks (i.e. ends with sPattern) and apply fix (i.e. append sAppend)
For Each oSl In ActivePresentation.Slides
For Each oHl In oSl.Hyperlinks
If Right(oHl.Address, Len(sPattern)) = sPattern Then
oHl.Address = oHl.Address & sAppend
End If
Next ' hyperlink
Next ' Slide
End Sub
Update: CRI 52938071
Regards,
Yuliana
Hi Amy,
I have gotten responses from the Product Team. They will fix it. The workaround for now is manually updating the url and adding noSignupCheck=1 at the end, so the url would be something like
https://app.powerbi.com/reports/b0feb82a-9bb5-4f9******2f6dbd8edf?pbi_source=PowerPoint&noSignupCheck=1
Best Regards,
Dale
Checking in 2 years later. This solution does not play nice with additional parameters in the URL. Adding 'noSignupCheck=1' causes the Power BI service to drop all the other parameters.
Hi,
I have just come across this thread as I'm having the same issue. Adding "noSignupCheck=1" works but for some reason opens the report twice.
Should the fix have been released by now?
Thanks,
Richard
Please be mindful that if the url parameter is the only one added to url, you should use '?' instead of '&'. I rushed into copying the '&noSignupCheck=1' to my link and failed to notice that, unlike the example provided above, that would be the single url parameter, and therefore it required adjustments ('?noSignupCheck=1'). I can certify this workaround is working for me as of now.
I haven't been able to get this to work in conjuction with URL filters. i.e. ?filter=
The URL works below for me but if I add the &noSignupCheck=1 it no longer works. Any clues anyone? I am trying to create a filter listing in Excel by creating the links in Excel.
I was having this same issue with hyperlinks to Power BI Reports from Excel and Word. The &noSignupCheck=1 works for these Office hyperlinks as well. Thank you for the solution.
Hi Amy, thanks for this solution. This really helped!!
@v-jiascu-msft The workaround no longer seems to be working, it opens Power Bi in two tabs and both state the report cannot be found. Any suggestions.
Until recently I could get the &noSignUpCheck=1 to work but now like the above, I get two tabs open in PowerBI saying it can't find the page I'm looking for. Is there not a better fix by now?
Thanks Yuliana,
Am I able to view that ticket? I have tried search but unable to find.
thanks
Amy
Hi @amyjefferson,
I could reproduce the same problem as yours. I have reported this problem internally, I will update here once I get any responce.
Regards,
Yuliana Gu