cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Re: Power BI Dashboard URL link defaulting to recently viewed items

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.


https://app.powerbi.com/groups/me/apps/cxxxxx-afc0-4926-8455-d954225b0109/reports/215a8f15-278e-4078...

 

Highlighted
Regular Visitor

Re: Power BI Dashboard URL link defaulting to recently viewed items

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

Highlighted
Frequent Visitor

Re: Power BI Dashboard URL link defaulting to recently viewed items

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:

  1. Open the PPT file just exported from PBI Service
  2. Open the VBA editor (Alt-F11)
  3. Select menu Insert > Module (Alt-I-M)
  4. Copy/paste the code below
  5. Execute the script (F5)
  6. Close the VBA Editor (Alt-F4)
  7. Save the PPT file (Ctrl-S)

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

 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Kudoed Authors