Forum Discussion

NickTT's avatar
NickTT
Helper III
5 years ago

PowerBI and SharePoint Open File

I have a Power BI report that pulls file information from SharePoint. I want to use the following value as a WebURL type so I can have a link in my Report that will open the related word document. Currently the link I have downloads the file which I don't want people doing.

 

Current link that Downloads

 

Https://mysharepoint.sharepoint.com/sites/site1/documentlibary/mydocument.docx

 

 

Link needed top Open in Office App

 

ms-word:ofe|u|Https://mysharepoint.sharepoint.com/sites/site1/documentlibary/mydocument.docx

 

 

This option doesn't give me the Link Icon in a Report.

Need Help

5 Replies

    • NickTT's avatar
      NickTT
      Helper III
      5 years ago

      My guess is that PowerBI platform has to be updated to support this option as a valid hyper link.

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Just add ?web=1 to your url

     

    Https://mysharepoint.sharepoint.com/sites/site1/documentlibary/mydocument.docx?web=1

     

    Regards,

    Pat

    • NickTT's avatar
      NickTT
      Helper III
      5 years ago

      I have, however my requirement is to open in the thick client first. Not the extra step of going to the web and then clicking open in desktop app. I know... it's not that much different but it is a few extra clicks that could be avoided if the URL worked like it does in SharePoint.

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi NickTT ,

     

    To my knowledge, Power BI isn't supported it currently. You can post your idea here. It is a place for customers to provide feedback about Power BI.

     

    In addition, I find this post: Launch desktop app winword. Maybe it could help you. But I know little about this and can't help you further. Sorry.

     

     

    Best regards

    Icey

     

    If this post helps,then consider Accepting it as the solution to help other members find it faster.