PowerBI Table Open URL in a browser

[hdbavda]

Hi,

I currently have a report table where I have added a URL tab. This URL tab contains .pdf/.docx and other related files in https:// format. The current functionality downloads the file that is clicked into directly to the local device, which I don't want due to security and versioning. Where I am trying to get to is that when a user clicks on a specific URL within the table, that docx or pdf file shall open in a web browser. All of these files are currently held in SharePoint online. How can this be achieved? I found this one Launch URL tab under Microsoft: https://learn.microsoft.com/en-us/power-bi/developer/visuals/launch-url but not sure if this is covering different URLs as I have multiple. I would highly appreciate an answer to this.

Thank you,

HD

[christinepayton · Accepted solution]

Add "?&web=1" to the end of the file paths to force them to open in a browser. I did a video on this here, unsure if your source is the same but the calculation at about the halfway point: https://www.youtube.com/watch?v=yeIQ9jKln_I 

[christinepayton · Accepted solution]

Add "?&web=1" to the end of the file paths to force them to open in a browser. I did a video on this here, unsure if your source is the same but the calculation at about the halfway point: https://www.youtube.com/watch?v=yeIQ9jKln_I 

[hdbavda · Accepted solution]

Thank you for your response! This makes sense. Do you have any resource that you could direct me to for being able to do this in Power Query? The URLs are extracted from files that have links active so I had to run a macro within excel to extract them into a new column and this works as new data is added as well. Thanks a lot again!

[christinepayton]

Could you re-word your question for me? Not sure I'm grasping what you're asking - is it how to extract links from inside files without using an Excel macro? You could probably do that with Power Automate Desktop but if you already have it working in Excel I'd go with that. When I'm working with file URLs it's usually just the surface level path from the library in SharePoint, not inside the file content... but Power Automate Desktop can use regular expressions on files so presumably you could get anything that starts with your tenant URL and toss it to Excel with that.