Forum Discussion

parulagarwal's avatar
parulagarwal
Frequent Visitor
9 years ago

hyperlink

I am able to access a hyperlink from my excel sheet but when I change the same URL to WeB URL on my Power BI report, i get an access denied for that page.

What am I doing wrong??

 

Thank You,

Parul.

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion

    is it not the privacy settings?  compare your query settings in power query/excel vs power bi under Options and settings, look for privacy

    • parulagarwal's avatar
      parulagarwal
      Frequent Visitor

      I tried changing the privacy settings. Tried all options. Do I need to save and refresh after that?

      • vanessafvg's avatar
        vanessafvg
        Community Champion

        to be honest thats the only thing i can think of, if you imported your steps into power bi of how you do the query  from excel , so from power bi go  file / import / excel workboot contents and import the power query steps, see if that helps at all, doubt it will change anything though because in my mind it must be privacy settings.  ive never had to save to apply the privacy changes that should be immediatey but refreshing makes sense to do after you have changed them.